Category: tSQLt

• A Join A Day – How to Test a Join

  

  2012-12-11 - A Join A Day, General, Series, T-SQL Tuesday, TDD, tSQLt

  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.

  [more…]

• The Logic Problem in the EndOfMonth function

  

  2012-03-04 - General, TDD, tSQLt

  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…]

• SQL Test available

  

  2011-12-07 - tSQLt

  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…]

• tSQLt V11 now available

  

  2011-07-17 - tSQLt

  We just uploaded the new version of tSQLt. Check out the changes new features in the release notes

• Constraint Controversy

  

  2008-12-17 - General, tSQLt

  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…]