SQL Server Utility in SQL Server 2008 R2

One of the new management related features in SQL Server 2008 R2 is SQL Server Utility. SQL Server Utility gives...

Thoughts on SQL Server Certification

This is probably part 1 of a series, but no guarantees.

Why Certify?
I've been working with SQL Server for 10 years...

Volunteering for PASS

I said I was going to do it last year, and I followed through. After submitting an application to volunteer,...

Finding Date Ranges for Calculating Statistics

Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...

Setting Up a Server Side Trace

Recently I wrote a short post  on the default trace in SQL Server. You can read that here. In this...

Twas the Night Before the MCM ...

T'was the Night Before the MCM ...
SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The...

Document, Document, Document

A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation....

Another Presentation Down

This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV).  I...

Business needs vs dirty reads

I have worked in many industries, but most of my time has been in the publishing industry.  For those not...

Don’t Be a Shock Jock

  One of the dangers of being an “Internet Journalist” or even just a blogger, is that you might compromise who...