I recently had a great conversation with Louis Davidson as part of his "Coffee chat with…" series on Simple Talk.

I show an inline table-valued function to extract values from an integer encoded with days of the week.

I talk about some of the challenges and qualitative factors that influence how you add, remove, and change indexes.

I consolidate many bits of Docker advice that had previously been scattered across several different posts.

In this post, I talk about why it's so important to regularly test that your backups can be restored.

In the last part of the series, I show how I coordinate multiple parallel jobs… and what comes after them.

In part 3 of this series, I dig into some detail about how I further parallelized the work and reduced overall runtime.

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.