Renaming or disabling the sa login requires a dependency inventory, tested alternate admin access, and monitoring after the change.
Exploring the System Catalog With Queries
Exploring the system catalog with queries reveals SQL Server objects, columns, indexes, and dependencies without relying on stale diagrams.
Responding to a SQL Server Security Bulletin
A SQL Server Security Bulletin should trigger exposure checks, ordered patching, verified recovery, and a clear management update.
SQL SERVER – Guidelines and Coding Standards Complete List Download
My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.
SQLAuthority News – 700 Articles and Author Updates
The blog has reached 700 articles. Here is why I write, plus updates since article 600: the SQL Server MVP award, user group work and 4 million visitors.
SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint
When should you use a Unique Index and when a Unique Constraint? Imran Mohammed explains, and shows how to handle a column with more than one NULL.
The Tools a DBA Installs on Day One
The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.