Monthly Archives: March 2013

The Command Shell

Posted on March 29, 2013 by

Recently I heard a few people arguing over the use of xp_cmdshell in a particular situation. One person was adamant that there was a security risk in using this feature. Many of you probably feel the same way, and even the SQL … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

The Great Laptop Search of 2013

Posted on March 28, 2013 by

It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a couple years ago. Rather some requirements for work, mainly Hyper-V, have come up and I can’t meet them with the … Continue reading →

Posted in Blog | Tagged , | 21 Comments

The DBA Team #1–Code and Slides

Posted on March 27, 2013 by

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again. In the meantime, we … Continue reading →

Posted in Blog | Tagged , , , , , , | 2 Comments

What Do You Want to Know About I/O?

Posted on March 27, 2013 by

There’s lots I want to know. What affect does an SSD have if I use it for a log file? One of my filegroups with indexes? What about tempdb? How do you dig in and prove latency to the storage … Continue reading →

Posted in Editorial | Tagged , , ,

A Good Security Response

Posted on March 26, 2013 by

Security will become more and more important in the future, at least in my mind. As we become more interconnected and dependent on digital services, if the level of fraud and security failures do not fall, many people will hesitate … Continue reading →

Posted in Editorial | Tagged ,

SQL Saturday #187–Richmond Recap

Posted on March 26, 2013 by

I’m late writing this, and I did mean to get to it earlier, but life got in the way. TL;DR: It was a great event, lots of fun, and I’d love to do it again. When I first heard of … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

A Week from Omaha–SQL Saturday #197

Posted on March 25, 2013 by

Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never been to Omaha, and only been to the state once, in the far SW corner to Oshkosh for a horse … Continue reading →

Posted in Blog | Tagged , ,

Car Data

Posted on March 25, 2013 by

I really like cars. In my lifetime I have owned more than my share of vehicles, and I always look forward to renting new makes and models when I travel, just to drive something different. As cars have evolved over … Continue reading →

Posted in Editorial | Tagged ,

Macbook Air v Surface Pro

Posted on March 22, 2013 by

I love my MacBook Air. It’s small, light, and it works well as a traveling laptop for me. It starts and stops instantly, and the only complaint I have is that my 2011 version only has 4GB of RAM and … Continue reading →

Posted in Blog | Tagged ,

Toggle Switches

Posted on March 22, 2013 by

When SQL Server 7 was released, it was touted as a self-tuning, self optimizing database platform requiring much less attention from a DBA. The product had relatively few tuning options and limited information available about how it processed queries. DBAs … Continue reading →

Posted in Editorial | Tagged ,