Nearly 4 Hours of Video Instruction
Everything you need to know in order to implement and work with SQL Server Replication!
Replication is a common method of moving from one SQL Server to another. It enables moving data to a reporting server, creating a basic failover site, providing data to development environments, and addresses many other issues. Most DBAs have or will encounter Replication when working …
Nearly 4 Hours of Video Instruction
Everything you need to know in order to implement and work with SQL Server Replication!
Replication is a common method of moving from one SQL Server to another. It enables moving data to a reporting server, creating a basic failover site, providing data to development environments, and addresses many other issues. Most DBAs have or will encounter Replication when working with SQL server. The Replication system is large enough that it is often difficult to master without some form of training. SQL Server Replication Fundamentals LiveLessons provides the information needed in order to work with replication.
Description
Every SQL Server Admin in the market needs to understand Replication in order to do their jobs. Individuals in the accidental DBA category who find Replication installed on their system, also need to understand how to use it. This LiveLesson covers all the basic building blocks of Replication. Expert Eric Johnson begins with a basic overview of the components and terms and progress into advanced configuration and troubleshooting. There is a lot to learn in order to use Replication correctly. The configuration is very visual and often more easily explained with this medium than any other delivery mechanism. This LiveLesson uses the most current version of SQL Server, but almost all the content can be applied to SQL Server versions as far back as 2005, and in some cases, even older versions of SQL Server.
About the Instructor
Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is a co-founder of Consortio Services, and the primary Database Technologies Consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks. Since IT is really just a way to support business processes, he has also acquired his MBA. All in all, he has 10 years of experience with IT, a great amount of which has been working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes. He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the recent four-part series, Tour de SQL, published in Redmond magazine. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users' Group.
Skill Level
Beginner to Intermediate
What You Will Learn
Introduction
SQL Server Replication Fundamentals LiveLesson: Introduction
Lesson 1: Overview of SQL Server Replication
Learning Objectives
1.1 Define Replication
1.2 Identify Replication Types
1.3 Understand Server Roles
1.4 Identify Replication Agents
Lesson 2: Configuring Replication
Learning Objectives
2.1 Set up Distribution
2.2 Set up Publishing
2.3 Set up Subscribers
Lesson 3: Working with Snapshot Replication
Learning Objectives
3.1 Configure Snapshot Replication
3.2 Work with Snapshot Options and Settings
3.3 Generate Snapshots
3.4 Configure Snapshot Agent Profiles
Lesson 4: Working with Transactional Replication
Learning Objectives
4.1 Configure Transactional Replication
4.2 Create Subscriptions
4.3 Synchronize Transactional Subscriptions
4.4 Modify Publications
4.5 Understand Replication Stored Procedures
4.6 Configure Distribution Agent Profiles
Lesson 5: Working with Merge Replication
Learning Objectives
5.1 Configure Merge Replication
5.2 Synchronize Merge Subscriptions
5.3 Understand Replication Triggers
5.4 Configure Merge Agent Profiles
Lesson 6: Working with Peer-to-Peer
Learning Objectives
6.1 Configure Peer-to-Peer
6.2 Work with Peer-to-Peer Replication
Lesson 7: Special Considerations for Replication
Learning Objectives
7.1 Use Identities in Replication
7.2 Replicate Indexes and Foreign Keys
7.3 Understand the NOT FOR REPLICATION Option
7.4 Backup Replication with Scripts
Lesson 8: Configuring Replication Security
Learning Objectives
8.1 Configure the Publication Access List
8.2 Identify Accounts with Replication Access
8.3 Set up Permissions
Lesson 9: Troubleshooting and Monitoring Replication
Learning Objectives
9.1 Use Replication Monitor
9.2 Identify Replication System Tables
9.3 Use the Ignore Error Option
9.4 Understand the MSdistribution_status View
Summary
SQL Server Replication Fundamentals LiveLesson: Summary