A short regular expression can list the procedures that hide a password, without printing it. Here is the scan, its false alarms and its blind spots.
Serial Zones in Parallel Plans: Where One Thread Does the Work
A parallel plan can still leave one core busy. See a harmless serial zone, a costly one, and how to read per-thread rows from the plan.
Listing Server Credentials and Where They Are Used
Credentials hide their secrets but still tell you who depends on them. Build a small demo and follow a credential to its login, proxy and job step.
Names That Differ Only by Case: Finding Them With COLLATE
A case-insensitive target can turn two rows into one. This walk-through finds the colliding names first, including the ones with trailing spaces.
DATE_CORRELATION_OPTIMIZATION: Helping Joins on Related Dates
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.