DEFAULT_DATABASE and MUST_CHANGE shape the login experience. Tested on SQL Server 2025: the syntax that fails, and how the two lock a user out.
SQL SERVER – Ins and Outs of Online Index Operations
I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.
SQL SERVER 2022 – Oldest Compatibility Level Supported
What is the oldest compatibility level supported by SQL Server 2022? It goes back to SQL Server 2005, and here is why that backward compatibility matters.
Data Binning in T-SQL: Fixed Width, NTILE, CASE, DATE_BUCKET
Data binning turns a column of numbers into a few groups you can count and chart. This post runs four T-SQL methods on the same orders on SQL Server 2025: fixed width, NTILE, CASE ranges and DATE_BUCKET. It shows what each method tells you and one trap with BETWEEN.
Histogram Buckets in T-SQL: Counting Values per Range
Create histogram buckets in T-SQL with fixed widths or explicit ranges, retain empty buckets, and display scaled text bars.
SQL SERVER – Understanding When to Use DBCC UPDATEUSAGE in SQL Server
DBCC UPDATEUSAGE is a command available in SQL Server that is used to update the page and row count metadata for database objects.
Gherkin Language Beyond English: Keywords in Other Languages
The Gherkin language is not limited to English. This post shows the language header, the same scenario in English, French and Hindi, a keyword table, why a team gains from writing in its own language, and the limits found when the keywords are mixed.