Monthly Archive: August 2012

Using named instances? Test your DAC connection!

Playing around today, I discovered that I was locked out of my local named instance using the Dedicated Administrator Connection. This post shows why and explains how you can avoid getting shut out of your own instance.

Splitting Strings : Now with less T-SQL

Some interesting discussions always evolve around the topic of splitting strings; here I show splitting on the database side may not be necessary in the first place.