SQL Server 2017

Measure Delayed Durability impact

In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.

Using metadata to troubleshoot metadata

I show how I tried to chase down a very unexpected issue with SQL Server metadata. Spoiler: it didn't end the way I thought it would.