Inspect an unfamiliar SQL Server with read-only queries for version, uptime, database size, waits, backup history, and settings.
Checking Optional Features Installed on an Instance From T-SQL
A 1 in SERVERPROPERTY does not mean the feature runs. Here is how I line up the flag, the setting and the service in one query.
Wide Covering Indexes: The Cost of INCLUDE Everything
Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.
Finding Hard-Coded Passwords in Stored Procedures
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.







