Integrating tSQLt with CruiseControl
How to integrate tSQLt test results with the popular continuous integration tool, CruiseControl.
Supporting a database refactoring with tests and views
How a change to the database structure does not have to halt development and can be appropriately unit tested.
Using the tSQLt ResultSetFilter
How to retrieve a single result set from a statement which produces multiple result sets.
Refactoring SQL Server code
A look at how to improve the quality of SQL Server code using a valid set of tSQLt tests.
Testing COALESCE with tSQLt
Learn how to use tSQLt to test COALESCE queries.
Adding PK exceptions to SQLCop tests
How to enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
tSQLt and the INSERT EXEC problem
A proposed solution to the INSERT EXEC problem in tSQLt.
Checking table metadata with tSQLt
How to use the AssertResultSetsHaveSameMetaData method from the tSQLt framework to enforce APIs.
Testing simple calculations and UDFs with tSQLt
A basic look at how to test user-defined functions with the tSQLt framework.
Prevent sp_ procedures with SQLCop
Using SQLCop with tSQLt to check for check for sp_ named procedures.