I show how to piece together portions of SQL Server metadata to generate DBML (which is more useful than it sounds).

I wrote two tips around what you can do when a table that stores the same strings over and over again has grown to an unmanageable size: create a dimension table!

A recent documentation update raises questions about the love-it-or-hate-it READ UNCOMMITTED isolation level.

In this tip I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.

I talk about progress in aggregating strings – both in the functionality offered by SQL Server and the quality of my own code samples.

I harassed Erik Ejlskov Jensen enough to make me a universal command-line version of SqlQueryStress, and walk you through setting up a performance test between an Intel and M1 MacBook.

In this tip I show how indirect checkpoints can help improve performance and stability of more than just checkpoint operations themselves, and stifle some (but not all) problems. I conclude that you should proactively change this setting everywhere.

I show how I set up Azure SQL Edge in a Docker container on the new M1 MacBook.

See one way to use a queue table to spread out spiky, ad hoc deletes from a clustered columnstore index.

These functions aren't brand new, but they're in Azure SQL Database and Azure SQL Managed Instance, and they're coming to SQL Server 2022 soon.