Wednesday, July 12, 2006

SQL Server 2005 and Visual Studio 2005 integration - good demos

Today I ended up on these very cool demos. I usually like a lot that kind of quick HOWTOs, which are straight to the point and give you a good overview of the possibilities that bring you a given technology piece. Well, the demos I found today are really like that - most of them are like 5 to 7 minutes long, but give you a clear view of how to do the things. Nevertheless, I bet that you won't become a MSSQL 2005 guru after going thru all of them, but they will give you a good foundation what to expect from the collaboration between Microsoft SQL Server 2005 and Microsoft Visual Studio 2005 (from developer's perspective).

Anyhow, here is a link where you can view or download the content for offline browsing - SQL Server 2005 Developer Productivity Guided Tour [link].

Here is a quick overview of what this tour includes:

1. Web Application and SQL Server Database Creation (4 min. 34 sec.)
- Creating a New Web Application
- Adding a SQL Server Database
- Inspecting the SQL Server Database
2. Database Schema Creation and Data Input (6 min. 52 sec.)
- Creating Tables With the Database Diagram Designer
- Modifying Tables with the Table Explorer
- Populating the Tables with Test Data
3. Data Access via Stored Procedures and User-Defined Functions (7 min. 49 sec.)
- Creating a Stored Procedure
- Creating a User-Defined Function
4. Data Access and Data Binding in Web Applications (5 min. 41 sec.)
- Adding a New Form to a Web Application
5. Web Application Debugging (6 min. 23 sec.)

No comments: