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
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.
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
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