See how to work around some of the blockers for replacing legacy UDFs with STRING_SPLIT.

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.

In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.

I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.

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.

Updated for a more modern version, I explain how to install and use SQLLocalDB.