Getting back to basics

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...

Outlier Detection with SQL Server, part 2.1: Z-Scores

By Steve Bolton
…………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex...

Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve...

Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !

The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the hotfixes released since the...

Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...

Last Weeks Top “Reading” Links #106

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Minion Reindex is here

We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...

A script to list the DTS connection information for every package on the instance.

For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...

Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !

The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...

Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2)...