Use a change freeze checklist for SQL Server to verify backups, integrity checks, disk headroom, Agent jobs, and serious errors.
Turning a Business Question Into a Query: Define the Metric First
Turn a business question into a tested T-SQL metric with explicit time zones, cancellations, returns, and a hand-checked sample.
Blocking Alert: A T-SQL Check for Sessions Blocked Too Long
Short blocking is normal. This check flags lock waits past a threshold and walks each chain to the session at the front of the line.
BDD vs TDD: One Small Feature, Two Ways to Test It
BDD vs TDD is easy to mix up until you test the same feature both ways. This post checks one delivery rule with a unit test and then with a plain-language scenario, runs the unit test, and explains when each approach fits.
Running Distinct Counts: Working Around COUNT(DISTINCT) OVER
Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.
Given-When-Then for Database Tests
Use Given-When-Then for readable database tests with known input, explicit THROW checks, and transaction rollback after each case.
Go Programming Language: 10 Interview Questions With Tested Answers
The Go programming language is small, so ten questions cover most of an interview. This post answers each one in plain words with a tiny program. Every program was run twice on Go 1.27.1, and the real output is shown.







