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 …

This is a brief post containing my information about my PowerShell coding setup, IDE, extensions, etc. I’m writing this mainly because, based on the reactions to my reddit comment, some …

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 …

In this post I go over some useful information that you should be aware of when working with SQL Server’s IDENTITY columns. I initially intended for this to be more …

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, …