OR Short Circuits

When your query has an OR, short circuits minimize SQL Server's work.

Why NOLOCK is Bad

Demos showing incorrect query results.

How to Pick a Database

For serverless apps. Good analysis - our experience with SQL ConstantCare mirrors this post.

Nines are Not Enough

Customers want strong, understandable promises that their apps will run reliably and quickly.

Updating Stats in an AG

Niko figured out how to offload this to a secondary.

Trailing Spaces in SQL

Sometimes SQL Server trims them, sometimes it doesn't.

Stored Procs in TempDB

Don't have ownership chaining.

Troubleshooting Perf Issues

Erin Stellato walks you through a problem.

Gorgeous Modern House

I'm in love with Wallace Cunningham's architecture, like this long house with no interior doors.

Mountains and Molehills

Don't turn speed bumps into roadblocks.