SNESSUG March Meeting

Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our...

Speaking at SQLSaturday #29 in Birmingham, AL

On Saturday the 27th of March, I’m going to be presenting two sessions at SQLSaturday #29 in Birmingham, Alabama.
1:30 PM:...

SQL 2008 Auditing Presentation in NJ by the MAK!

If you are a regular to the sql server community sites, forums and blogs, then you know about the awesome stuff brought...

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