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

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

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

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

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

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

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

Spring SQL Server Connections / DevConnections

I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...

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

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