SQLSaturday#39 in NYC!

 If you can't make #33 in NC, there's always #39 in NY -

SQLSaturday#39 in NYC!
It's shaping up to be another...

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 Perfect is the Enemy of the Good (Again)

I wrote an editorial for SSC back on January 19th about the perfect being the enemy of the good. It’s...

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

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

In Vs. Inner Join

This is tightly related to another of my forays into tuning some slowly/poorly performing processes.  This process came across my...

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

Presenting in Colorado Springs on May 19, 2010

I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...

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