Monthly Archive: August 2012
Today the SQL Server Release Services Team has released the third Cumulative Update for SQL Server 2012. The KB article is at: http://support.microsoft.com/kb/2723749. The build number is: 11.0.2332.0. There are 35 fixes publicly documented at the...
Tip : Recover access to a SQL Server instance
Microsoft has released cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 SP1 Cumulative Update #8 KB article is http://support.microsoft.com/kb/2723743 Build number is 10.50.2822.0 There are 20 fixes published as of 2012-08-31...
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.
Microsoft has released a cumulative update for SQL Server 2008 R2 SP2, which was only released last week. KB article is http://support.microsoft.com/kb/2720425 Build number is 10.50.4260.0 There are 35 fixes published as of 2012-08-01...
This week I came across a case where DRY should be thrown out the window. There are other cases as well (for example, scalar functions), but this one was an interesting one involving Bitwise logic.