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...

Time’s Makin’ Changes

Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...

Importing and Exporting SSIS Packages Using PowerShell

SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...

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...

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....

PASS Summit Location

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

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...

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,...

Something BIG in Boston - SQLSaturday#71

BIG in BOSTON
Last time, I blogged about the first upcoming event in the North East in Philadelphia, PA – SQLSaturday#69, but...

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