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

Liveblog for #SQLBits X Day 1 Keynote

Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...

Re-blog – March 23 – March 29

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

http://blog.csdn.net/zjcxc/article/details/4383113
First, I...