SQL Server 2008 Advanced Database Administration: Part 2
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.
What you'll learn
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.
Table of contents
- Introduction 2m
- Encryption Background Information 1m
- SQL Server 2008 Encryption Hierarchy 5m
- Encryption Hierarchy Components 4m
- Data Encryption vs. Transparent Data Encryption 3m
- SQL Server 2008 Column Encryption 13m
- Column Decryption 2m
- Transparent Data Encryption 11m
- Encryption Algorithms 2m
- Vocabulary Review 1m
- What We Covered 1m
- Introduction 1m
- Mirroring Overview 4m
- Operating Modes 1m
- Mirroring Roles 2m
- Mirroring Service Account 2m
- Setting Up Server Engine Service Accounts 5m
- Database Mirroring Sessions 1m
- Creating Database Mirroring Endpoints 2m
- Role Switching 1m
- Configuring Endpoints and Starting Mirroring 6m
- Recommendations and Restrictions 2m
- What We Covered 1m
- Introduction 4m
- The Need for Replication 3m
- What is SQL Server Replication? 1m
- Two Categories of Replication: Server to Server 1m
- Replication Roles: Publisher, Distributor, and Subscriber 1m
- Replication Agents 1m
- Replication Configuration 2m
- Adding Computers to the Domain 1m
- Creating Domain Accounts 6m
- Replication User Accounts 6m
- Configuring the Firewall 3m
- Installing SQL Server and Replication 4m
- Configuring Distribution 11m
- Creating the Publication 8m
- Configuring the Subscriber 1m
- Creating the Subscription and Verifying Data Was Replicated 3m
- Best Practices 2m
- Vocabulary Review 1m
- What We Covered 3m
About the author
Mel has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK. As a Member of Technical Staff (MTS) at Bell Labs in Naperville he worked as a C/UNIX software developer and in Quality Assurance (QA) for 5ESS international switching. Mel first taught computer science while completing his Masters in Computer Science at Bradley University in Peoria, IL. He started working with Visual Basic in 1992 and began teaching VB as an MCT in... more