Russ Thomas – SQL Judo

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

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

Featured · 3 Comments

Confessions of a Brand Snob

I’m actually pretty used to finding things out about myself that I would rather not know.  I can’t bench 400 lbs.  I haven’t run a sub 6 minute mile in 20 … Continue reading

June 4, 2014 · 1 Comment

Is Your SQL Server in Daylight Savings Time?

Remember the old ‘Deep Thoughts – by Jack Handy’ bit on Saturday Night Live.  One of those came across the cube wall today. “Hey – how can we figure out if the … Continue reading

May 1, 2014 · 2 Comments

When Is Alter Table Just a Meta Data Change

A typical question while reviewing code for release to production is whether an alter statement will change meta data only or cause page level activity.  I am not aware of a matrix or chart in … Continue reading

March 26, 2014 · 3 Comments

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

T-SQL Tue #51: Eye Heart You Dee Effs

I absolutely love this month’s TSql2sDay topic.  Take a generally accepted rule of being a DBA and argue against it.  If there is one thing I like more than being a DBA it … Continue reading

March 11, 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
Follow

Get every new post delivered to your Inbox.