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

How to Consolidate & Virtualize SQL Server 2008

Many companies face the decisions to 1) consolidate their SQL Servers, due to sql sprawl; and 2) whether to virtualize their SQL...

Review: Virtual CloneDrive

It’s pretty common to download software as an ISO file (a disk image) and it seems like a waste to...

Volunteering for PASS

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

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

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

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

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

Document, Document, Document

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

Solving All Versus (Select All) SSRS End User Confusion

When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...