This tool slipped out of Redmond with little fanfare, but it looks quite promising. It does for SQL Server databases roughly what FxCop does for .NET Framework applications: specifically, it scans through the database schemas and associated SQL code using a rules-based engine to identify any deviations from accepted best practices.

It's currently in beta, and I found the tool interface a little idiosyncratic (someone took the Windows Update design metaphor slightly too far, perhaps), but it has a fairly comprehensive set of rules (you can access them here so that you can view them without having to install the product). Each rule seems to be implemented as a separate .NET assembly, but for this beta version there's no documentation on how to create your own rule.

The analyzer tool has a lot of potential value for both developers and DBAs; given that you can analyse a remote server, it's worth loading up on a development workstation to iron out any T-SQL glitches before you release a database into production, and then repeating the process once it's in place to spot any operational oversights.