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

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

Bit columns can be tricky, and I discuss a few techniques for sanity and performance – including filtered indexes when skew is dramatic.

For this month's T-SQL Tuesday, Steve Jones asks us to talk about problems we've solved using window functions.

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.

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.

I recognize this year's recipient of my Community Influencer of the Year award.

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