SQL Server 2005 Developer Productivity Guided Tour
Get a demo tour of an end-to-end application that highlights how the deep integration between Visual Studio 2005 and SQL Server 2005 enables developers to deliver faster results when building data-driven applications.
- Download the complete tour for offline viewing.
Module 1: Web Application and SQL Server Database Creation See how a new web application can rapidly be built using a Starter Kit and how a new SQL Server 2005 database can be created and associated with the web application.
|
|
Module 2: Database Schema Creation and Data Input See how the integrated tools in Visual Studio 2005 such as the Database Diagram Designer enable users to easily create database schemas for an application and add real data to the new database tables. Download |
|
Module 3: Stored Procedures and User Defined Functions See how T-SQL stored procedures can be visually added to the newly created database via the Query Designer and how Managed User Defined Functions can be built for simplified yet powerful data access. Download |
|
Module 4: Data Access and Data Binding in Web Applications See how ASP.NET and ADO.NET, coupled with the new controls embedded in Visual Studio 2005, enable you to retrieve data efficiently from a SQL Server database and bind it to web pages and forms with little to no code. Download |
|
Module 5: End-to-End Web Application Debugging Debug your application by setting break points in your presentation tier, custom logic tier and data tier and see how the hosted CLR (Common Language Runtime) in SQL Server 2005 allows you to debug your application end-to-end from ASP.NET to Managed code to T-SQL statements. Download |