SQL Server: Transactional Replication Fundamentals
Learn how to configure, monitor, and troubleshoot SQL Server transactional replication, as well as the fundamentals of how it works and key performance considerations.
What you'll learn
SQL Server replication remains a viable data distribution and availability feature that has inherent advantages that are not entirely covered by other out-of-the-box SQL Server features. This course will briefly examine the various replication types before delving more deeply into transactional replication. In addition to the fundamentals, this course will also review the key performance considerations, monitoring techniques and troubleshooting scenarios. After viewing this course you should be ready to use transactional replication in the appropriate contexts, as well as deploy, support and troubleshoot issues accordingly. This course is perfect for developers, DBAs, and anyone responsible for SQL Server replication, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onwards.
Table of contents
- Module Introduction 1m
- Transactional Replication Components 1m
- Transactional Replication Initial Dataset 1m
- Transactional Replication Log Reader Agent 1m
- Transactional Replication Distribution Agent 1m
- Deployment: Wizard or Scripts? 1m
- Configuring the Distributor 1m
- Demo: Configuring the Distributor via Wizard 6m
- Demo: Configuring the Distributor via T-SQL 3m
- Creating the Publication 1m
- Demo: Creating the Publication via Wizard 5m
- Demo: Creating the Publication via T-SQL 3m
- Creating the Push Subscription 0m
- Creating the Pull Subscription 1m
- sp_addsubscription @sync_type 2m
- Demo: Creating a Subscription via Wizard 6m
- Demo: Testing a Transactional Replication Topology 2m
- Demo: Creating a Subscription via T-SQL 3m
- Deploying with Least Privilege (1) 1m
- Deploying with Least Privilege (2) 1m
- Module Introduction 1m
- Factors that Affect Replication Performance (1) 3m
- Factors that Affect Replication Performance (2) 2m
- Demo: Replication Multiplier Effect 4m
- Distribution Database 1m
- sp_addpublication's immediate_sync 2m
- Demo: Checking Distribution Database Settings 3m
- Demo: Validating immediate_sync options 1m
- Log Reader and Transaction Log Activity 1m
- Hidden Costs of a Single Command 1m
- Demo: Measuring Agent Reader vs. Writer Time 6m
- Demo: Wait Statistics by Agent 5m
- Module Introduction 1m
- Tools and General Troubleshooting Steps (1) 2m
- Tools and General Troubleshooting Steps (2) 1m
- Data Not Being Delivered to Subscribers 1m
- Demo: Replication Validation 2m
- Publisher and Subscriber Data Does Not Match 1m
- Danger of -SkipErrors 1m
- Demo: Skipping a Failed Command 4m
- Skipping Specific Commands 1m
- Process Could Not Execute sp_repldone/sp_replcounters 1m
- Impact of DBCC CHECKDB Repair 1m
- Error 2812: Could not find stored procedure %.*ls 1m
- Course Summary 1m
