SQL Server 2008 Administration (70-432): Part 2
Part 2 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system.
What you'll learn
Part 2 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, replication, and optimized use of SQL server FileGroups. Whether you're a beginner or experienced in SQL Server administration, you will benefit from this in-depth course.
Table of contents
- Introduction 1m
- What's the Problem to Solve? 4m
- SQL Server Replication Concepts 4m
- SQL Server Roles 7m
- Creating Replication Admin Account 10m
- Changing Firewall Settings 2m
- Giving Replication Admin Access to the SQL Server 13m
- Adding Replication Accounts to Database 6m
- Creating Publication 7m
- Creating Push Subscription 7m
- Best Practices 4m
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