This SQL Server 2025 cheat sheet puts the T-SQL I use every day on four printable pages. Every query ran on SQL Server 2025 first, and all the scripts are in the post. It covers joins, window functions, regular expressions, JSON, indexes, backups and SSMS shortcuts.
Install AdventureWorks and WideWorldImporters: Updated 2026
Install AdventureWorks and WideWorldImporters once, the right way. Which file to download for your SQL Server, where to put it so the service account can read it, the RESTORE FILELISTONLY step, restore scripts for T-SQL, SSMS, Docker and Linux, and the five errors people email me about. Every command was run on SQL Server 2025.
SSMS and Execution Timeout – SQL in Sixty Seconds 209
Execution timeout in SSMS are a small but important feature that can help you manage query performance. Let us watch the video together.
Why ‘Max Server Memory’ Isn’t Always the Limit
What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?
SQL SERVER – Understanding Maximum Server Memory
When optimizing your SQL Server for superior performance, understanding and correctly implementing the ‘maximum server memory’ setting is crucial.
SQL SERVER – Performance: OR vs IN
I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.
SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing
Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check