This is an advanced article showing how to use the “0-1-some” heuristic to select the right test cases when unit testing a join query. The example will approach the task following Test Driven Design.
Test case heuristics can help picking the right test cases for the logic you are developing. This article is a brief introduction into that field, extending on the example of the EndOfMonth function. [more…]
Exciting news! Red Gate is now shipping SQL Test, a graphical UI for tSQLt. tSQLt is a Database Unit Testing Framework for SQL Server that was developed by Dennis and me. SQL Test integrates with SSMS and allows you to [more…]
We just uploaded the new version of tSQLt. Check out the changes new features in the release notes
It wasn’t until recently that I ever thought to do away entirely with database constraints. Aside from appropriate normalization and writing fast SQL code, much of the time database professionals spend is on figuring out exactly what constraints to put [more…]