We’re All Mad Here!

The title says it all!
I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited...

2014 SQL Server Editions – Overview

2014 is the latest edition of SQL Server available[/caption]
SQL Server 2014 was officially released in April 1st, 2014. You can...

Why a Boot Camp?

As a some of you may already know, I am now offering SQL Server boot camps with the first one...

When Data Should Walk Out The Door

What would you do?
What would your reaction be if, one day, all that old data you’ve been holding onto for...

Counting Work Days

Don’t forget that most holiday’s aren’t work days.
Recently while working with a client I was faced with some seriously convoluted...

Digby’s Top 10 reasons you need a DBA

Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.

They can handle unexpected database growth...

Optimizing Protected Indexes (was Indexing Encrypted Data)

Why bother encrypting?
Riddle me this batman? Why bother to Encrypt?
As a SQL Server DBA I am primarily responsible for making...

Type 2 SCD with SQL Merge

I was going through some notes I had from previous projects and came across a sample script for created a...

Gain exclusive control of a database

Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...

10-minute SQL: Filtered Delete: join vs. sub-select vs. exist

I was doing some simple tuning of procedures for a client when I came across some delete statements that I...