Sachin Rekhi (Microsoft Team System for Database Professionals team) recently posted a very well done whitepaper on Database Unit testing using Team System for Database Professionals. Check it out here.
The opinions expressed here are my personal opinions. Content published here is not read or approved in advance by anyone at Microsoft and does not necessarily reflect the views and opinions of Microsoft.
I am currently a Solutions Architect at Microsoft in the US Federal Specialist Technical Unit. I support our Federal Government customers around the Data Platform, including Big Data, Hadoop, Machine Learning and Open Source development.
Prior to Microsoft, I worked in the CTO office at EMC Corporation, and prior to that, I was a consultant and trainer and worked with many Fortune 1000 clients to deliver dynamic, data-driven solutions using Microsoft SQL Server and the Microsoft suite of development products. I have worked with SQL Server since version 1.0 (Yes, there really was a 1.0 version) on OS/2.
I have been involved with the Visual Studio Team System suite of products since the beginning, and have focused heavily on Agile Database development methods using MSF and "Data Dude" (Team System for Database Professionals).