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 …

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 …