November 2023
When an update doesn't update

I discuss reasons you might think a data change was successful when it wasn't – or vice-versa.

Anatomy of a featured image

I talk about the evolution of my thinking on featured images, and how I use generative AI for most post companions these days.

Unpivoting multiple sets of columns

UNPIVOT works great when you're populating a single output column, but I talk about how CROSS APPLY can work better in more complex scenarios.

Modernizing Stack Overflow for Teams

I discuss decisions and trade-offs when migrating Stack Overflow for Teams – first to a new cluster, and then to a new version of SQL Server.

Deployment checklists

In this tip, I talk about checklists to keep everyone involved in a deployment or migration – regardless of technical acumen – on the same page.