SQL Server

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 …

There’s this weird misconception floating around LinkedIn and reddit that SQL Server CTEs somehow store results in either memory or tempdb. This is wrong and whoever states that CTEs store …

This is a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints. Setting the scene Someone, …

It’s 3AM and I’m curious if Query Store plan forcing works on queries that use the RECOMPILE hint (aka OPTION(RECOMPILE) ).So might as well make a blog post out of …

In this post I explore the impact of SQL Server 2025’s PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022. Spoiler: SQL Server 2025’s PBKDF2 hashing …

In this post I cover a fairly common VM CPU configuration mistake that may end up hurting your SQL Server’s performance and wasting licensing money. Intro It’s not uncommon that …

This post covers creating SQL Server 2025 containers in Podman, Qnap Container Station, and sqlcmd, and restoring a sample database to test the new version. Prerequisites For Podman and go-sqlcmd, …

This post covers, in detail, system object changes in SQL Server 2025 versus 2022 that I was able to find, as well as differences in the install kit. I saw …

If you’ve ever been curios about ways to view SQL Server system objects’ definitions, to see what your favorite system objects do behind the scenes then this blog post is …