Virtual Labs – Application Development

SQL Server 2008 is at the heart of a comprehensive data platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data services across the enterprise.

SQL Server 2008 Programmability: Plan Freezing with SQL Server 2008
Prevent query plan regression after a server upgrade, use plan freezing to optimize query performance, and copy query plans between servers.
SQL Server 2008 Programmability: Using the New DATE/TIME Data Type
SQL Server 2008 supports several new datatypes. In this hands-on lab, you will compare the new DATE/TIME datatypes to the SQL Server 2005 datatypes, and implement the new datatypes in table definitions and T-SQL batches.
SQL Server 2008 Programmability: Learn How to Build Occasionally Connected Applications with Compact
Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact 3.5.
Using Table Valued Parameters in SQL Server 2008
Work with Change Data Capture in SQL Server 2008.
SQL Server 2008 Spatial Data: Using the new SQL Server 2008 Spatial Capabilities - GEOGRAPHY
Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact 3.5.

Resources for
IT Pros

SQL Server 2008

Resources for Developers

SQL Server 2008