In part 2, I show how I take advantage of snake draft order with a couple of real use cases.

In this four-part series, I borrow a concept from fantasy football to solve an optimization problem in a long-running weekly job in SQL Server.

I talk about a technique that can avoid expensive sorting to paginate by large string values.

In this post I talk about how to avoid losing valuable debugging information in the abyss and noise of SQL Server Agent's history.

I put together a few pointers about upgrading SQL Server, including /SkipRules, and avoiding the web installer.

For this month's T-SQL Tuesday, Brent Ozar asks about the last ticket we closed. I came close…

I talk about several things you can do to clean up after yourself and be a good RDP citizen.

If you're planning to roll forward your existing configuration file to SQL Server 2022, read this first.

Azure SQL Database got an update: A new locking model that might finally displace NOLOCK.

2023 was an interesting year for SQLblog.org – I talk about top posts and some changes I made here over the year.