Russ Thomas – SQL Judo

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

TSQL Tue #79: When the Memory is All Gone

I used to blog.  Today I ashamedly realized it’s been nearly six months since my last post.  That’s pretty pathetic.  I was doing a couple a month there for a nearly 2 years … Continue reading

June 14, 2016 · 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 Single Greatest Feature of Microsoft SQL Server

SQL 2014 RTM was just announced! I started working with SQL Server at version 7.0.  It was upgraded to 2000 a few months later so I don’t have tons of experience with 7.0 but … Continue reading

March 15, 2014 · 1 Comment

Cardinality of dm_exec_sessions and dm_exec_connections

For my own edification I have been working on a simplified entity relationship map of some of the more popular DMVs.  Yes I know Microsoft already makes this available.  But working it … Continue reading

March 7, 2014 · 1 Comment