tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
This guide has everything you need to know about JSON indexing in SQL Server 2025: what it is, how it works, and current limitations.
You may not be old, but I sure am. As I travel around to all the different conferences to speak, whether we're talking a dev conference, SQL Server, or PostgreSQL, one of the topics that keeps coming up is age. The age of the organizers. It's mostly the same people putting on events for the […]
See how SQL Server's Parameter Sensitive Plan optimization handles skewed parameters, how to verify dispatcher plans, and where PSP still falls short.
It's the first week of September, but Steve sees it as the end of summer. It's a time to catch up on things.
This guide covers how TRANSLATE() works, how it compares to REPLACE(), and where it falls short compared to other SQL dialects like PostgreSQL and Oracle.
Learn to use DuckDB to read data from Excel and then send it to SQL Server with Python and Pandas.
Today Steve wonders if the data professionals out there measure themselves on the job.
What's the difference between SQL Server's row compression and page compression, and when does each one make sense?
How a simple Extended Events session can turn you from a silent guardian to a developer’s best ally. There is an old, undeniable paradox in the life of a Database Administrator: If you do your job perfectly, nobody remembers you exist, only when you resolve problems. When queries are fast, backups are pristine, and the […]
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hi, I have a trigger, that works fine elsewhere but is not working at...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers