Renumbering Rows in a Table Variable (or Table/Temp Table)

I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...

SSWUG Free SSIS Expo – Today!

SSWUG Free Expo Event: Basic and Complex SSIS Features virtual conference is today!  There’s a chance that you can probably...

The Importance Of Managing Expectations

Have you ever taken a sip of sweet tea only to discover that it was soda instead? Eeww! What an eye-opening experience! Don’t misunderstand; I like soda. But when...

The Importance Of Managing Expectations

Have you ever taken a sip of sweet tea only to discover that it was soda instead? Eeww! What an...

What Should PASS Be? I Challenge You

PASS isn’t what it should be. I hear that a lot, and in many ways I agree with you. We’re...

DenverSQL UG Meeting: Tim Mitchell presents Dirty Data? Clean it up!

 Denver SQL Server User Group - Thursday, February 17, 2011

 
Main Presentation
"Dirty Data? Clean It Up! By Tim Mitchell"Dirty Data? Clean It...

How to Interpret SELECT @@VERSION in SQL Server

One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly...

SQL Rally

I believe I’ve been far too quiet about this event.
In May, in Orlando Florida, there will be a two...

SQLServerPedia Blogger Awards

Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards.  You can read about that here.  Of all of the...

SQLServerPedia Blogger Awards

Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards.  You...