The good part of this Webcast is that I love to program databases. Although it is somehow very confusing to study the 7 types of Normalization, database and relation database programming is a pretty cool one to learn. Almost every company has a database that's why it is not new if you are a programmer and have been assign to connect to a database application. One thing, I am not really particularly aware with the different editions of Visual Studio 2005. I concentrated myself studying .NET Framework 2.0 by using only 2005 Express Editions but somehow, I knew some of them. Now I've learned again and its Database Professionals.
Database Professionals was obviously for database programmers who want the ease of programming and binding their controls on a back-end database which is usually SQL Server for Visual Studio 2005. Unbound was also a common practice but it is for the programmer's perspective on what method he will use. One great thing I notice in this edition of 2005 is the use of Database Wizard, here you will declare and configure everything you need for your database application. The next which I like is the ability to work SQL Server Management Studio within the IDE of Visual Studio 2005 for Database Professionals. It is quite cool because you can even work with SQL Statements and executing it.
Refactoring was one of its main feature. The word refactor was actually new to me and I discovered it on our local Microsoft Technet Seminar in Microsoft Philippines with our speaker Mr. Andre Cruz. It was actually a TDD Seminar. So back to my topic, refactoring in Database Professionals in such a way you have the power to SQL Server, update all dependent object in database projects like schema objects, data generations and unit test, make an atomic change and meet corporate standards. Lastly, MSBuild Integration was used for database project deployment.
One thing I want to consider here, the schema document that was presented here is not the xsd or xml schema document. I thought it was but it isn't.
