22-25 April 2026 
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
Speakers
Anthony Brown's previous sessions
Geting data from here to there using replication
This will show the replication options available in sql server and in which situations each type can be used. I will also show how to set it up and some diagnostic techniques for when it doesnt work
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
Designing and deploying a database using visual studio 2010
Database projects allow offline development and easy deployment of a database. Previously they were only available in team system versions of visual studio, but with the release of visual 2010 they will also be available in the professional version.
This presentation will introduce the key concepts of database projects. It will also show you how to create a database project, import an existing database, modify objects and then deploy it to any sql server.