I demoed Visual Studio features at one point and the rules are extensible.

Create and Register Additional Rules for Analyzing Database Code - Visual Studio 2010

Analyzing Database Code to Improve Code Quality - Visual Studio 2010

Not a lot of shops adopted the database tools integrated in versions of Visual Studio 2010 and before because it was cost prohibitive, instead opting for some combination of SSMS and other tools. The good news is that Microsoft has carried static code analysis forward into SSDT for SQL 2012 which is free 😀 I havent demoed it yet though to see how much they brought forward.