SQLBits 2011

Database unit testing with visual studio 2010

This session will cover why you should run database unit tests (and when you should not). It will show how to set them up and run them in visual studio 2010
Writing unit test have long been part of best practice recomendations when writing code. This has normally been done in the code layer (eg c#, vb.net) but not done for any database code. With Visual Studio 2010 database projects you can now create unit tests as part of a database project and easily run them again and again. In this session we will cover why you might do this (and why you might not) and how to set up and run some basic tests