Browse by Tags

• Unit testing

• Benefit from Unit Testing T-SQL: Speed up Maintenance of Unit Tests

  Once we have a considerable amount of unit tests, their maintenance begins to take noticeable time. If we need to change a module covered by unit tests, it may take less time to make the change itself than to change the corresponding tests accordingly. Read More... Posted Wednesday, October 27, 2010 5:00 PM by Alexander Kuznetsov | 0 Comments Filed under: Database Unit Testing, T-SQL, Unit testing Attachment(s): adding_column.JPG

• Benefit from Unit Testing T-SQL: Speed up Your Test Harness

  Ideally unit test harness should run very fast. Because all unit testing involving a database is quite slowish, we need to apply some effort to ensure that our tests finish in acceptable time. This slowness might not be a concern when we try out a cool Read More... Posted Friday, October 15, 2010 3:04 PM by Alexander Kuznetsov | 0 Comments Filed under: Database Unit Testing, T-SQL, Unit testing

• Benefit from Unit Testing T-SQL: Reuse Unit Tests as Documentation

  Unit tests provide a very accurate snapshot of what we were thinking about (and what we were missing) when we were writing them. In fact, they are working examples of how we think our code should be used. More to the point, unit tests must be up-to-date, Read More... Posted Thursday, October 14, 2010 1:39 PM by Alexander Kuznetsov | 1 Comments Filed under: Database Unit Testing, T-SQL, Unit testing

• How to Benefit from Unit Testing T-SQL: Exposing Failure in a User-Friendly Way

  Well-written unit tests should succeed only when the module being tested meets the requirements completely.If the test fails, it can do much better than just indicate failure. If the test has managed to provide a clear and comprehensive report of what Read More... Posted Friday, October 08, 2010 2:45 PM by Alexander Kuznetsov | 1 Comments Filed under: Database Unit Testing, T-SQL, Unit testing Attachment(s): diff3.JPG

• How to Benefit from Unit Testing T-SQL: Reusing Manual Tests as Parts of Unit Tests

  In this post we shall see how to incorporate a typical manual test in an automated test harness with minimal effort. Because our goal is to benefit from unit testing, and not to develop as many features as we can think of, we shall concentrate on the Read More... Posted Wednesday, October 06, 2010 9:36 AM by Alexander Kuznetsov | 0 Comments Filed under: Database Unit Testing, T-SQL, Unit testing

• How to Benefit from Unit Testing T-SQL: choosing what not to test

  Ideal unit tests are easy to roll out, easy to maintain, run fast, and make a difference: without them making changes and troubleshooting are more difficult. Some common examples of unit tests do not grade well against this criteria. For instance, writing Read More... Posted Thursday, September 30, 2010 4:55 PM by Alexander Kuznetsov | 0 Comments Filed under: Database Unit Testing, T-SQL, Unit testing

• How to Benefit from Unit Testing T-SQL: choosing what to test.

  When we write articles, blog posts, and books, our examples must be simple. On the other hand, when we write automated tests in real life, the most complex modules need automated tests much more than simple ones. Consider, for example, the following trivial Read More... Posted Tuesday, September 28, 2010 5:04 PM by Alexander Kuznetsov | 0 Comments Filed under: Database Unit Testing, T-SQL, Unit testing

• How to Benefit from Unit Testing T-SQL. Part One.

  Unit testing may be extremely useful if we do it right – if . On the other hand, if unit testing is being used inefficiently, it can be a huge waste of time and effort. When we were beginning to unit test our T-SQL more than three years ago, we wrote Read More... Posted Monday, September 27, 2010 10:03 PM by Alexander Kuznetsov | 1 Comments Filed under: Database Unit Testing, T-SQL, Unit testing

• Survey: how do you unit test your T-SQL?

  How do you unit test your T-SQL? Which libraries/tools do you use? What percentage of your code is covered by unit tests and how do you measure it? Do you think the time and effort which you invested in your unit testing harness has paid off or not? If Read More... Posted Monday, May 03, 2010 5:26 PM by Alexander Kuznetsov | 11 Comments Filed under: Database Unit Testing, T-SQL, Unit testing