Slides & Samples for my DevWeek and SQLbits sessions

As I have announced in my DevWeek and SQLbits sessions, you can find my session materials
(slides & samples) here for download:...

SQL 2012 has Launched

LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched.  With it,...

SQL 2012 has Launched

LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched.  With it, some really cool features are now available to...

Monitor SQL Server Backup job duration

if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the...

Presenting at SQLSaturday #107 in Houston in April 2012

I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....

Reflections on Leaving Microsoft

Reflections on Leaving Microsoft
Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)

Several members of my SQLFamily have made adjustments to their career...

Remote DAC connections

TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...

Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial

My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...

BIDS Helper 1.6 for SQL Server 2012 released

BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...

Execution Plan for a User Defined Function

When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:

It appears as...