Virtual Labs – Data Warehousing

SQL Server 2008 Data Warehousing: Using Performance Studio in SQL Server 2008

Discover more about the components and terminology associated with Performance Studio and especially Data Collection, create and properly configure a Management Data Warehouse, manage data collection types and intervals, analyze the results of data collection, and create custom data collection types.

SQL Server 2008 Data Warehousing: Working with Change Data Capture

Change data capture 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. Change data capture uses change tables that contain columns which 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.

SQL Server 2008 Data Warehousing: Using Partition Processing

Partitions enable organizations to manage large, growing tables more effectively by transparently breaking them into manageable blocks of data. This lab walks you through using SQL Server 2008 partitioning enhancements for improved performance on large, partitioned tables.

SQL Server 2008 Data Warehousing: Using Resource Governor for Predictable Performance

SQL Server 2008 introduces Resource Governor to help organizations provide a consistent and predictable response to end users. Resource Governor enables database administrators to define resource limits and priorities for different workloads. This lab walks you through how to utilize the new capabilities with Resource Governor.

What is New in SQL Server 2008 for Database Administrators

In this hands-on 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 datatype, implement Policy-based Management, 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 CDC.