SQLCop

As part of Redgate SQL Test, you get SQLCop
(although the tests themselves are freely available to use).

SQLCop is a set of over 100 open-source tests for your databases.
The tests were originally maintained by George Mastros but are now managed by Redgate Software