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

A Good Security Response

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

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

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

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

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

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 ,