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.

T-SQL Tuesday #152: Soapboxing

For this month's T-SQL Tuesday, Deb Melkin asks us get up on our favorite soapbox. I have so many, but this time I picked a new one…

Using goal posts to reduce scan impact

Logging tables get huge, and date range queries get more if they don't use the clustered index. Here's one way I've addressed the issue.

On Cumulative Updates and GDRs

Using a fictitious future timeline, I explain how CUs and GDRs differ and why build number alone might not tell the whole story.