SQL Server can learn that an order date and a ship date move together. Here is a small demo of the read savings and the trade you accept.
Linting T-SQL: Rules Worth Automating in a Build
Use linting T-SQL to flag repeatable code risks, review catalog-based candidates, and automate confirmed rules without false certainty.
ENCRYPTBYPASSPHRASE: Simple Encryption and Its Weak Spot
One function in, one function out, and then the real question: where does the passphrase live? A short tour with demos you can run.
The sp_ Prefix: Finding Stored Procedures Named the Risky Way
Find user procedures with the sp_ prefix across databases, understand the lookup risk, and move callers through a synonym safely.
Moving From Express to Standard Without Reinstalling
Plan how to upgrade SQL Server edition from Express to Standard, preserve the instance, and verify databases and applications after setup.
Collapsing Repeated Spaces and Line Breaks With REGEXP_REPLACE
Tabs, line breaks and a sneaky character 160 can all hide in a name that looks fine. Here is how to clean them on purpose.
CPU-Bound Queries: Comparing worker_time to elapsed_time
Is a slow query working or waiting? Compare its two clocks and you will know what to fix before anyone buys more CPU.







