SQL Server

Snake draft sorting, part 4

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

Snake draft sorting, part 3

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

Snake draft sorting, part 2

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

Snake draft sorting, part 1

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.

Clean up your setup config file

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

2023 : A year in review

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

Counting more efficiently

I show how to use metadata to avoid costly reads when retrieving counts, even for a subset of the table.

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.

Oct. '23 security fixes

SQL Server has updates that fix several vulnerabilities, for all modern versions from 2014 SP3 through 2022.

SQL Server query performance decay

In this tip, I talk about various reasons a query's performance can change over time – even when the application hasn't changed.

Manage schema drift

I talk about how I use dynamic SQL to handle many databases with not-quite-identical schema.

T-SQL Tuesday #154: SQL Server 2022

For this month's T-SQL Tuesday, I talk about a not-quite-yet-announced feature in SQL Server 2022 that has the potential to function as a low-effort bad habit logger.