What SQL Server Service Pack Do I Have Installed?

If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that...

Who Changed Jobs in 2010?

Linked in sent me an email saying that an astounding 209 of my connections changed jobs in 2010, out of...

A Full Backup can Impact a Log Backup–MCM Prep

In the early days of SQL Server you could not run a log backup while a full backup was running....

A Mish Mash of Stuff

I don’t generally post bits of this and that, but I’ve accrued a few things that I wanted to share,...

February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries

Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...

Meet Me In Florida!

While much of North America is bracing for the Snowpocalypse 2011, my thoughts are turning to sunny Florida.

I’m not just...

PASS Summit Location

Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...

Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features

Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features

This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL...

Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features