SQL Test includes a number of static analysis tests you can run to detect issues with your database. For a comprehensive set of over 100 advanced static code analysis rules for SQL, Redgate offers SQL Code Guard.
SQL Cop tests were originally contributed by George Mastros of Less Than Dot and are now hosted on GitHub under the stewardship of Redgate (see announcement on SQL Server Central). Issues and pull requests welcome!
To add the tests, when you add a new database to SQL Test, make sure the Add SQL Cop static analysis tests check box is selected:
To add the tests to a database you've already added to SQL Test, in the SQL Test tab right-click the database and click Add SQL Cop Static Analysis Tests:
The following static analysis tests are included: