In this post I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables. In the past couple of months I’ve been running into …

I recently ran into SQL Server’s page compression being applied to a heap, and I figured I’d cover why that won’t work how some folks expect. SQL Server’s page compression …

In this post I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information. This script builds on the one for importing saved …

I wasn’t really planning on writing a blog post today, but I got curios if there’s any way in which connections saved in SQL Server Management Studio 21 can be …

SQL Server Management Studio 22 just went GA this week, so I figured I’d document my new configuration in a blog post. A while ago I made a post about …

In this post I talk some more about SQL Server 2025’s new PBKDF2 and demo a method to replicate it using T-SQL. Intro Back in June I wrote a post …

SQL Server Management Studio 22 Preview 3 was released 2 days ago, and since I didn’t have the time to try out the previous preview versions, I took it out …

In this post I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814. This August’s Patch Tuesday came with a security patch for SQL …

This post is an overview of PSBlitz, how I use it in diagnosing SQL Server issues, and the notable changes it went through over the past 3 years. Intro In …