Via Eric G. Harrison – MS have developed a SQL Server Best Practices Analyser Tool. It’s like a cross between FxCop and Baseline Security Analyser, for SQL Server. Very useful. I just downloaded it, ran it against some of my databases, and it made some useful suggestions. This could quickly become indispensable.