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
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
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
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
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
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
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
When was the last time you used sqlcmd.exe?
With the growing popularity of windows server in CORE mode the command line is officially back in vogue. PowerShell is getting all the press but there is a lot more … Continue reading
My favorite lesser known features of SSMS
A few days ago Mickey Stuewe and I were talking on twitter if there was a way to generate an alter view script from object explorer using only keystrokes. Turns out you can mimic … Continue reading
Russ Thomas - SQL Judo 