After completing this lab, you will be able to demonstrate how unencrypted data can be stolen by restoring a backup file, encrypt sensitive data by using Transparent Data Encryption, and demonstrate that an encrypted database cannot be stolen by restoring a backup file.
Participate in a demonstration of appropriate uses for the Resource Governor, create resource pools and workload groups, and monitor resource usage in SQL Server 2008.
Learn to discuss the components and terminology associated with policy-based management.
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.
In this hands-on lab, you will be better able to add disks to DPM using the DPM Management Shell, use the DPM Console to create protection groups, use the DPM Management Shell to create protection groups, and recover SQL databases in a variety of ways.
