I written a couple of post about Datadude by now, and unfortunately both of them have been about issues that I've had, so I thought it would be about time that I wrote about something that I like :)
I've used the possibility to create database unit tests, manly to test some user defined functions that I have created, but also some stored procedures, and it works great. This features bring the positive effect of unit testing, to the database, that we are used to have when writing our code. Instead of me writing a guide about how to do database unit testing, I can recommend you to read
Sachin Rekhi's article "
Database Unit Testing with Team Edition for Database Professional" that was recently published on MSDN.