July 2025

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 …