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

Intro to SSAS BI Workshop - Review

 A Synopsis of My Experiences of the “Intro to SSAS” BI Workshop in NYC!
By Robert Pearl
Well it’s a wrap of...

I'm in at SQL Connections!

At the end of March I'll be journeying down with the family to Orlando, Florida. We plan on stopping in...

Can You Dig It? – Plan Cache Series

She can dig it!
D Sharon PruittA few PASS Summit’s ago, I became interested in the information available in the...

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

Who Is This Super Hero?

We recently switched from Brighthouse to DirectTV and of the first things we did was to find the kids channels...

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

VSone session material

As I have announced in both of my sessions at the VSone conference in Munich, you
can find the session material...

SQL Rally

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