SQL Server 2008 Advanced Database Administration: Part 2

Pluralsight
Course Summary
Part 2 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security.
-
+
Course Description
Part 2 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.
-
+
Course Syllabus
SQL Server 2008 Policy-Based Management- 31m 45s
—Introduction 1m 45s
—Policy-Based Management Benefits 3m 21s
—Policy-Based Management Terms and Concepts 3m 35s
—Setting Up Naming Restrictions 8m 5s
—Controlling Feature State 5m 34s
—Security 2m 34s
—Adding a User to the Policy Administrator Role 3m 3s
—Recap and Other Things to Remember 3m 14s
—What We Covered 0m 34sSQL Server 2008 Data Encryption- 45m 29s
—Introduction 1m 59s
—Encryption Background Information 1m 22s
—SQL Server 2008 Encryption Hierarchy 4m 55s
—Encryption Hierarchy Components 4m 5s
—Data Encryption vs. Transparent Data Encryption 2m 52s
—SQL Server 2008 Column Encryption 13m 14s
—Column Decryption 2m 5s
—Transparent Data Encryption 11m 22s
—Encryption Algorithms 1m 37s
—Vocabulary Review 1m 8s
—What We Covered 0m 50sSQL Server 2008 Backup and Recovery- 43m 56sSQL Server 2008 High Availability- 32m 44sSQL Server 2008 Failover Clustering- 18m 42sSQL Server 2008 Database Mirroring- 29m 23sSQL Server 2008 Log Shipping- 37m 39sSQL Server 2008 Replication- 1h 3m