Russ Thomas – SQL Judo

The Art of SQL Server Database Administration, Development, and Career Skills for the Technically Minded

TSQL Tue #59: My Heroes

I’m looking forward to reading the TSQL2SDAY posts this month.  Hero worship is something I have a bit of a problem with.  The problem being, there are way too many … Continue reading

Featured · Leave a comment

Violating AdventureWorks Dating Policy with Merge, Hash, and Loop Joins

The logical joins (inner, outer, left, right etc) are familiar to any SQL pro.  As the optimizer selects the physical join type that will actually perform the work however, this part of … Continue reading

Featured · Leave a comment

Rolling Upgrade: Synch Mirrors, Log Shipped DR – Lessons Learned

We recently did a hardware/software upgrade of a set of servers participating in synchronous mirroring for HA purposes with a log shipping solution for disaster recovery to a remote location. … Continue reading

October 2, 2014 · Leave a comment

HELP! PK is Running out of Identity Values

You never thought it’d happen.  Way back when you picked an Int as your PK with an auto-increment identity you said.  2.1 billion inserts??  That’ll never happen.  But business exploded.  Developers … Continue reading

September 16, 2014 · 1 Comment

TSQL Tue #58: Passwords and Registered Servers

It’s TSQL Tuesday!!!  The topic was picked by Sebastian Meine over at SQLIty.net who is hosting this month’s edition of the rotating monthly blog party known as TSQL Tuesday.  Sebastian … Continue reading

September 9, 2014 · 2 Comments

31 Days of SQL Server Management Studio

I have always wanted to do a 31 day series.  Something like Kehayias’ 31 days of extended events, or Strate’s 31 days of SSIS.  These posts in turn were inspired by … Continue reading

August 1, 2014 · Leave a comment

T-Sql Tue #56: Aint Nutin’ My Problem

You know what happens when you assume right?  Of course you do.  That little play on words is pretty well played out.  In fact, if at least one other blog … Continue reading

July 8, 2014 · 3 Comments
Follow

Get every new post delivered to your Inbox.