Microsoft SQL Server 2008 Virtual Labs

Want to learn more about SQL Server 2008? Check out these Virtual Labs

What's new in SQL Server 2008 for Database Administrators

In this lab you will be introduced to some of the new features for database administrators in SQL Server 2008. You will work with the new date data type, implement a Declarative Management Framework (DMF) policy and look at new features added to database mirroring. You will also implement and work with table valued parameters and look at database changes using change data capture (CDC).

Implementing Change Data Capture (CDC) in SQL Server 2008

Change data capture (CDC) is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by CDC contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred. In this lab you will perform the necessary steps to enable data capture in a database.

Working with the new DATE data type in SQL Server 2008

SQL Server 2008 supports several new data types. In this lab you will compare the new DATE/TIME data types to the SQL Server 2005 data types and implement the new data types in table definitions and T-SQL batches.

Administering Servers by Using Declarative Management Framework (DMF) Policies

Declarative Management Framework (DMF) is a policy-based system for managing one or more instances of SQL Server 2008. When SQL Server policy administrators use DMF, they use SQL Server Management Studio to create policies to manage entities on the server such as the instance of SQL Server, databases, or other SQL Server objects. In this lab you will implement a DMF policy and implement that on the server-level, including filtering.

Learn How to Build Occasionally Connected Applications with SQL Server 2008

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.

Authoring Reports Using SQL Server 2008 Reporting Services

After completing this lab, you will be able to launch the Report Designer Preview, create a data source and a data set, design a new report using the Report Designer of SQL Server 2008 Reporting Services, preview your report, enhance your report layout by working with Tablix functionality, and enrich your report using charts.