DBA.Sleep(8hrs)

I have been pondering recently what helps me to sleep at night.  Or, conversely, what prevents me from sleeping at...

The Power Grid (No, Not THAT Power)

Yesterday I had the Adversity Index, today it’s the Power Grid from MediaIte. It attempts to score the power of...

MVP Summit Impressions From Day 1

Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side...

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