Tip : Recover access to a SQL Server instance
This post explores the performance characteristics of several solutions to the median problem.
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.
Sometimes it can make sense to check for potential errors and prevent them, instead of letting them happen.
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.
I describe a way to use ALTER SCHEMA … TRANSFER to refresh data with minimal disruption.
See how you can dynamically drive sort column and sort order.
There were a lot of comments following my post last week about string splitting, and I have tried to address those here.
This week I came across a case where DRY should be thrown out the window. There are other cases too; this one involved bitwise operators.