SQL Saturday returns to Redmond, WA

SQL Saturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons.

I have submitted 2 proposals for presentations,...

SSIS 2008 Script Component variable gotcha..

In a previous post I showed you how to access variables from within an SSIS script component.  More specifically I...

The T-SQL Hammer

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...

SQL Server - Checkpoint

What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages  out to...

Buck Woody on Code Writing Code

I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...

Job Quality

Through a circuitous route, I encountered a meaningful, thought-provoking quote lately: "... the best way to predict the future is to...

Panic Attack

I had a minor panic attack recently where I was getting ready for bed and all of a sudden thought...

SQL Developers Please Use the Table Name/Alias to Prefix Columns

Note:  After I completed this post Aaron Bertrand added this subject to his “Bad Habits to Kick” series for myself...

Quick Tip Of The Day

Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...

Review: Windows Live Writer Backup

Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...