Test data that looks like production matches distributions, relationships, and volume without copying sensitive values into development.
Refactoring Old T-SQL One Procedure at a Time
Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.
Assertion Queries: Data Checks That Should Return Zero Rows
Let a short query find the order with no lines before a customer does. A small demo shows the failing keys, constraint error 547 and a clean repair.
Case-Insensitive and Multiline Regex Flags in SQL Server 2025
Your pattern passed the test string and then missed rows in the table. The flags and the line endings are the usual reason.
Trying New SQL Server Features Without Risk
Trying New SQL Server Features safely takes a separate instance, a controlled data copy, and before and after measurements.
Keeping a Patch Test Environment Honest
A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.
A Repeatable Workload: Testing a Tuning Change Fairly
One quick run can fool you. Here is a small, fixed test you can rerun before and after any index.