Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Test Coverage

By Steve Jones,

I've never had to work full time in a QA group, but I have had to perform software testing of an application and it wasn't fun. Even as I worked through the various features, looking for edge cases, common mistakes, etc., I realized that running tests was something that really required more discipline and process than I was giving it at the time. Too often I 'd realize that my regressions weren't 100% duplicates of previous executions because I'd allowed too much "human effort" into my process.

These days most testing of software is automated. I know QA groups still exist, and they need to handle some of the manual checks that are very hard to automate. However more and more testing is being pushed back onto developers to handle, with frameworks like NUnit and JUnit. In the database world, we haven't done a great job of including testing into the code we write, but there's a great testing framework we can use.

TSQLT is a framework written by Sebastian Meine and Dennis Lloyd and it's free. It's been developed to help you write tests that can exercise your T-SQL code to determine if it's doing what you expect. I've used it a little, and while I see the potential, I also realize that this will take some practice to learn how to more easily write tests that can cover the various potential places where bugs can be introduced.

However, if you use version control, and you should, then you can easily spread the load of writing tests to all of your developers. Since the tests are stored procedures, they can be included in your VCS project and shared by all your developers. With a little effort from each member of your team, you might be surprised at the code coverage you can achieve with this framework.

Testing is important, as we see over and over again as software is released and doesn't work as expected. I think much of that is our fault, as software developers, for not improving our testing skills and discipline.

 
Total article views: 191 | Views in the last 30 days: 2
 
Related Articles
FORUM

Entity Framework - Adhoc queries...

Entity Framework - Adhoc queries...

ARTICLE

Notes from Software Developements Expo 05

Our own Andy Warren recently spent a week in Santa Clara at the Software Development Magazine's SExp...

ARTICLE

Software Estimates

It seems the software industry doesn't do a good job of planning and estimating software development...

ARTICLE

Grown Up Software

We all want to write better software, but do we really want to write grown up software? Steve Jones ...

ARTICLE

Introducing Boomerang - A Notification Framework

Boomerang is a notification framework for IT professionals providing service oriented infrastructure...

Tags
editorial    
 
Contribute