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

Speaker

Anthony has been a sql server DBA since 1998. Since 2001 he has worked at John Lewis on their website infrastructure. He has experience in many areas of sql server including service broker, replication and database projects

Anthony Brown's Sessions

Geting data from here to there using replication

Database unit testing with visual studio 2010

Designing and deploying a database using visual studio 2010