A minor CPU upgrade
Some quick notes on how easy it was to take advantage of falling Ryzen prices and give my Windows PC a little boost.
Monthly Archive: April 2022
SQL Server 2019 Cumulative Update #16
SQL Server 2019 Cumulative Update #16 is available, with 47 enhancements. The build number is 15.0.4223.1.
Building DBML syntax from SQL Server
I show how to piece together portions of SQL Server metadata to generate DBML (which is more useful than it sounds).
Populate dimension tables dynamically – Parts 1 & 2
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!
Why I always start CTEs with a statement terminator
I talk about why every CTE I write starts with a semi-colon, and why you won't change my mind about it.
All you NOLOCK lovers better read this!
A recent documentation update raises questions about the love-it-or-hate-it READ UNCOMMITTED isolation level.