Microsoft has added "Static Code Analysis" to Visual Studio 2013 - SQL Server Data Tools (SSDT).

See attachment.

For example you have rules to avoid SELECT * in stored procs or...