Some quick notes on how easy it was to take advantage of falling Ryzen prices and give my Windows PC a little boost.

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!

I talk about why every CTE I write starts with a semi-colon, and why you won't change my mind about it.

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