Thanks for the Help with Deadlocks

It's time to start blogging again. And for my first post in a very long time, I mainly want to...

SQLSaturday #250 Pittsburgh

SQLSaturday #250 Pittsburgh is in the books, and I'd like to sincerely thank the organizers, sponsors, volunteers, and speakers for...

SQL Saturday #171 Pittsburgh, the Schedule is Up!

SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the...

SQLSaturday #171 Pittsburgh Prep Continues

Hey, did I mention that Pittsburgh is having a SQLSaturday this year?

Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...

ComputeReach

Man it's tough to get in all that you want to do, isn't it? I've been trying to get my...

SQL Saturday #171 Pittsburgh!

It's official, there's going to be a SQL Saturday in Pittsburgh this year!

The date is October 6th, and the...

How Good is Good Enough?

I was running some tests on some purchased data this morning, and was getting a little perturbed because I was...

Using "Multiple Assignment Variables" for a Generic Compare Data Script

Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.

Caution with EXCEPT

The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.