T-SQL Tuesday #201 - Temp Tables, Friend or Foe?

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Jeff Taylor
(blog) asks us for our take on temp tables:

So, do you...

T-SQL Tuesday #200 - I Bet It's Bad if I See...

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Brent Ozar
(blog) asks us to fill in the blank:

When I’m looking at...

Did You Really Name That Default?

Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:

SQL Server...

Presenting Twice in May 2026

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...

PASS Data Community Summit 2025 Recap

This is long overdue but life and distractions happened. It’s been a little over two months since I returned home from PASS Summit 2025.

T-SQL Tuesday #193 - Notes to Self

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mike Walsh
(blog) asks us:

Write two short notes to yourself. One to the...

PASS Data Community Summit 2025 Slides and Code

Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with Automation! I will have a more comprehensive post in the coming days. Slides and demo...

Finding Data Friends

I’ve been enjoying Ben Weissmann (Blog | LinkedIn) & Jess Pomfret’s (Blog | LinkedIn ) weekly program Finding Data Friends for a couple years now, getting to know (by...

Speaking at PASS Summit 2025

In less than one month, I will be speaking not once but twice at PASS Data Community Summit 2025.
Thursday, November 20th at 1 PM I will be in the...

Installing Old Versions of PowerShell Modules with Their Dependencies

I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...