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

2010 MVP Summit Held This Week

If you can’t tell what is happening in the above photo, you won’t be alone. Today, at the opening keynote...

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