Monthly Archives: March 2013

The Command Shell

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

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

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?

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 , , ,