Russ Thomas – SQL Judo

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

A Group of Basic Availability Groups

Can a group of basic availability groups mimic an enterprise level availability group for far less cost? With SQL Server 2016 we have finally been able to have some form … Continue reading

Featured · Leave a comment

Pass 2016 Summit Application and Feedback

For the past three years I have put myself out there and submitted for PASS.  While a long time user of SQL Server, and a somewhat recent IT manager of … Continue reading

June 28, 2016 · 2 Comments

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

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

December 30, 2015 · 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

December 29, 2015 · 5 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
Follow

Get every new post delivered to your Inbox.