Tuesday August 8th Sachin and I recorded a MSDN webcast about database unit testing and refactoring, we wanted to show-off CTP5 but we were not able to get it all setup in time for the webcast, so this covers CTP4. Bummer because Sachin really wanted to show of the new client side assert extensibility in Database Unit Testing, which allows you to create your own client side test assertions and add them to the product, oh well next time.

To see the webcast follow the link below:
MSDN Webcast: Visual Studio 2005 Team Edition for Database Professionals (Part 3 of 4): Database Testing and Refactoring (Level 200)

Today, Thursday August 10th I recorded an other webcast covering the basics of schema change managent and version (yes I know the listed titles is weird :). This time I was able to use an early CTP5 build, so you can get a preview of the new: "New Project Wizard" which integrates reverse engineering of an existing schema in to the project creation and the new Import Script Wizard, which allows you to import your existing .SQL script files in to the project and convert them in to schema objects. Besides that the sessions briefly touches on the use of the MSBuild tasks for building and deploying the project.

To see the webcast follow the link below:
MSDN Webcast: Visual Studio 2005 Team Edition for Database Professionals (Part 4 of 4): Schema Source and Version Control (Level 200)

Next month we will be doing more webcasts, the following topics in the pipeline:

  • Establishing the Database Development Lifecycle
  • Supporting Evolutionary Database Design
  • Extending Data Generation
  • Build & Deploy (including the use of Team Build)
  • Extending Database Unit Testing

Please let me know if you have any specific requests for topics; one that I personally wanted to do is around how to setup you source control environment, performing branching and other basic SCM operations in order to version you database projects.

That's it for now, back to fixing CTP5 bugs,
-GertD
"DataDude" Development Manager