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 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.

Download

 


Module 2: Database Schema Creation and Data Input 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 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 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 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