I found this new article written by Sachin Rekhi on Database Unit Testing with Team Edition for Database Professionals.
I think it's an excellent read. The only thing I don't think it covers is what is not included in the product. The most notable piece of Team System Unit Testing functionality that isn't included with DB Pro is Code Coverage i.e. the tab that tells you how complete your test coverage is.
On the upside Gert Drapers has commented numerous times in the forums on this and it looks like it will be in a future release.
Enjoy!
Cheers, James