Russ Thomas – SQL Judo

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

A Sane TSQL Repository

In the previous post we talked about using the template explorer within SSMS to keep a sane TSQL library.  People have complained for some time that the template explorer within … Continue reading

Featured · Leave a comment

A Sane TSQL Script Library

Earlier this year I got to speak at SQL PASS on performing under pressure.  Leading up to that event I previewed my session at a couple SQL Saturdays and during … Continue reading

Featured · 4 Comments

Your NoSQL Choice Needs More Relational Algebra

Whether you can admit it to yourself or not, data without relation or context is pointless.  Let’s say I have a database with 14 TB of integers between 0 and 100, with … Continue reading

December 1, 2015 · Leave a comment

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
Follow

Get every new post delivered to your Inbox.