In this tip, I show how indirect checkpoints can help improve performance and stability, and conclude that you should proactively change this setting everywhere.

For T-SQL Tuesday #146, I talk about a couple of crazy ideas I had in my head about filtered indexes.

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.