United States   Change   |   All Microsoft Sites

Home

Virtual Labs – Data Warehousing

SQL Server 2008 and its integration with the Microsoft BI platform provides a comprehensive view of your business, by increasing the freshness of the data, incorporating all your systems, and validating the data while helping reduce the burden on your IT department.

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

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

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

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

Microsoft TechNet

Resources for
IT Pros

SQL Server 2008

MSDN - Microsoft Developer Network

Resources for Developers

SQL Server 2008