Help the fight against cancer

Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community,...

Exciting New Projects

We Speak Linux
I am super excited to be to have launched this website. We Speak Linux is a place for...

Toolbox - Which Clerk Is Busy?

A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error...

UNDERCOVER TOOLBOX: Get Details of All Open Transactions

It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a...

Backups of backups or How long is my backup really available?

I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important,...

Azure SQL Database sa Connections?

I was using a query on one of my local SQL Servers where I wanted to know what logins were...

Expanding My Reach

I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted.  Simple- Talk is technical journal and...

SQL Server in Kubernetes on Docker for Windows

Last week Docker announced a feature that I’ve been looking forward to for a while: –

And sure enough, when I...

Scale-out SSRS (a brain dump)

So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...

SQL Server – Internals of sp_spaceused

This article is an effort to dissect the output of the sp_spaceused stored procedure.

Introduction
Understanding the database usage internals and the growth trends...