Exploring the system catalog with queries reveals SQL Server objects, columns, indexes, and dependencies without relying on stale diagrams.
SQL Server – 2008 – Cheat Sheet – One Page PDF Download
A one-page SQL Server 2008 cheat sheet PDF with the commands DBAs and developers use every day. Print it on A4 and keep it handy.
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 Author Visit – Ahmedabad User Group Meeting September 2008
Every third Saturday is the Ahmedabad User Group Meeting. Today I present SQL Server CTE and Recursive CTE, followed by a real life CTE example by Jacob.
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.