Russ Thomas – SQL Judo

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

Including Cluster Key in Non Clustered Index Definition

I ran into a question I haven’t gotten in a while – does including a clustered key as part of a non-clustered index offer any benefit? It came up because … Continue reading

October 6, 2015 · 3 Comments

24HOP: Stress Inoculation (2015 PASS Summit Preview Session)

Today was my first dress rehearsal presenting my PASS 2015 presentation to a living audience.  I was fortunate enough to get an invite to 24 hours of PASS.  My session … Continue reading

September 17, 2015 · Leave a comment

Experience; There is no Substitute

A few weeks ago I wrote a blog post entitled experience is over-rated.  Today you’ll get a little peak inside my mind while I counter that original argument myself.  Experience, … Continue reading

July 22, 2015 · 1 Comment

Finding Trouble

If there was any one skill I could rank as number 1 for new hires, be they junior or senior, it would be troubleshooting.  If someone out there has a … Continue reading

July 1, 2015 · Leave a comment

Coming Soon SQL 2016 Live Query Statistics (LQS)

I recently stumbled onto a feature in the upcoming release of SQL Server 2016 that at first seemed really intriguing.  Live Query Statistics – a way to see the query … Continue reading

June 2, 2015 · 1 Comment


Recently we had a disaster recovery event on a couple of mirrored servers.  By that, I mean we were required to move primary database operations to an offsite mirror partner.  Because … Continue reading

May 15, 2015 · 1 Comment

The Road to SQL Server 2014 MCSE

This afternoon I finally passed the last test in the Microsoft Certified Solutions Expert series for Data Platform.  I started the first test in the series while at Tech-Ed 2013 New … Continue reading

April 21, 2015 · 4 Comments