Monday - Agile Development in VS2008 and VS2010

DVP03-IS - Agile development with Visual Studio Interactive session with Stephanie Saad who demonstrated some features of VS2008/2010. There are very interesting things for database development in the DB edition of Visual Studio Team System:

• DB refactoring: changing a table name automatically updates all dependencies
• DB deployment: you can generate a script that contains all differences between the current schema and the production schema.
• DB testing: C# Unit-tests for T-SQL stored procedures where you define setup, test and teardown Test data generation (that's really handy for the setup part of the unit tests)

Apparently the dev and db versions of Visual Studio Team System have been merged into one license for 2008 so if you buy one, you get the other one for free. Other notes: VSTS 2008

• see author/changes directly in code
• define check-in policies (to force you to pass unit-tests for instance)
• define triggers such as on check-in build
• setup build notifications popups (through powertools)
• code metrics: show the number of lines, cyclomatic complexity
• all of the above present in VSTS for DB, Team System Server is not required

Coming up in VSTS 2010

• Planning, task management: creation of user stories / tasks hierarchy, capacity planning, reports to show test results per user story / task.
• Gated check-in: define check-in conditions, for instance you can't check-in if it doesn't build or if the unit-tests don't pass