Move the T-log file of the Mirror Database

On more than one occasion, I have run into a case where a large database with a large transaction log...

Parallel Data Warehouse – Slowly Changing Dimension

Most of my day-to-day work is currently centered around Microsoft’s Massively Parallel Processing Appliance call PDW (Parallel Data Warehouse).  Many...

Install SQL Server 2012 Book online on local disk

After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book...

April Question: What’s your favorite DBA book, and why?

Over and over again, I get asked which DBA books I recommend. With this in mind, this month’s qustion is...

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

Announcing SQLSaturday #175–In Flight Edition

One of the things I like about SQLSaturday is that it’s a place to try new ideas. This year on...

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

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