Kansas City, Pork, and Performance Tuning

What do all three of those things have in common? Here’s a hint: it’s me! That’s right, this weekend I will be at SQL Saturday #53 in Kansas City. I am especially looking forward to the BBQ crawl on Friday afternoon followed by the Royals game that night. I’ll pick up a KC cap while … Read more

SQLSaturday Raleigh Recap

This past weekend I went down to Raleigh to participate in the SQLSaturday event there and wanted to give a quick recap of the event. First things first, getting in and out of Raleigh this past weekend was quite easy. How easy? Well, on the way down I connected through Atlanta. I arrived at gate … Read more

A Better DBA Job Description For Everyone

Here is a typical job description that you can find online just about anywhere. It lists almost everything possible and imaginable. And it, well…I’ll just let you read it all for yourself and make up your own mind. Enjoy. Position Summary: This is a MS SQL Server DBA role largely responsible for providing operational database … Read more

How To Find Duplicate Indexes

I’ve had this script in my toolbox for a few years now. I didn’t create it initially, and I have no idea who did. This script helps you to identify duplicate indexes. Why is that important? I’m glad you asked, mostly because I’m tired of answering my own questions and it’s good to have someone … Read more