TSQLt

tSQLt is a testing framework for SQL Server, that basically means it provides everything you need to write tests against your database. All the tests are written in T-SQL, which means that anyone working with SQL Server can write them and they are executed by a stored procedure. One can stay working in SQL Server Management Studio without a need to context switch to another tool to write or execute your tests.