Rehearse a master database restore on a matching test instance, including single-user sqlcmd, automatic shutdown, and configuration checks.
Optimized Locking in SQL Server 2025: What Changes for Blocking
Enable optimized locking in SQL Server 2025 with ADR and RCSI, then compare lock counts and blocking while checking LAQ limits.
Formatting T-SQL Consistently Across a Team
Formatting T-SQL consistently means choosing a few readable rules, using a formatter carefully, and keeping historical changes focused.
SQL Server Version and Edition: SQL in Sixty Seconds #043
To find the SQL Server version and edition, read SERVERPROPERTY instead of parsing @@VERSION. The tests here show every useful property on SQL Server 2025, why ProductLevel can say RTM after an update, and how to read the version from the ERRORLOG.
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5
Part 5 of my redundant indexes series looks at an index on Col1 with included columns Col2 and Col3, and how it compares with the earlier cases.
SQL SERVER – What is Semantics Model – A Simple Explanation
What is a semantics model? In simple words, it is how data is organized in a database so that it makes sense to the users, not only to programmers.
SQL SERVER – Primary Key and NonClustered Index in Simple Words
In 2006 I wrote how Primary Key and Unique Key differ. Now I fill the gap and explain primary key and nonclustered index in simple words.