String Aggregation Over the Years in SQL Server
I talk about progress in aggregating strings – both in the functionality offered by SQL Server and the quality of my own code samples.
Monthly Archive: February 2022
FORMAT is a convenient but expensive function, part 1
In this tip I confirm that FORMAT is still a dog compared to even very complex expressions using CONCAT_WS, DATENAME, DATEPART, and CONVERT.
Mixed Extents Podcast – 2022.02.14
I was honored to be a guest on the most recent Mixed Extents podcast, along with my friend and colleague Andy Mallon, where we talked about patching SQL Server.
Performance Testing Docker Between Intel and M1 MacBooks
I harassed Erik Ejlskov Jensen enough to make me a universal command-line version of SqlQueryStress, and walk you through setting up a performance test between an Intel and M1 MacBook.