Misusing tSQLt

tSQLt is a great T-SQL based unit testing framework for SQL Server.

In addition to using it for unit testing, I’ve recently been (mis)using it to do some sanity testing of a slowly-updating data warehouse that I’m responsible for. The data warehouse is updated roughly once a quarter from new or refreshed data sources & this is a highly manual process because of the format of the data. So it’s useful for me to have some sanity checks in place to make sure I haven’t broken anything obvious.

The following are the tSQLt tests I’ve created as part of this process. I’ll update this list weekly until I run out of tests.

• Misusing tSQLt: test that table/view metadata is correct
• Misusing tSQLt: test that table data is correct (dims or reference data)
• Misusing tSQLt: test that table data is correct (historical unchanging fact data)
• Misusing tSQLt: test that indexes exist
• Misusing tSQLt: test that view is not empty