SQL Server: Transactional Replication Fundamentals
Pluralsight
Course Summary
Learn how to configure, monitor, and troubleshoot SQL Server transactional replication, as well as the fundamentals of how it works and key performance considerations.
-
+
Course Description
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.
-
+
Course Syllabus
Course Introduction- 1m 44s
—Course Introduction 1m 5s
—Course Structure 0m 39sReplication Types and Scenarios- 7m 13s
—Module Introduction 0m 51s
—Terminology - Publishing Industry Metaphor 1m 6s
—Types of Replication (1) 1m 21s
—Types of Replication (2) 1m 5s
—Types of Replication (3) 1m 56s
—Common Transactional Replication Topologies 0m 54sSetup and Configuration- 40m 45sPerformance Considerations- 28m 33sCombining Replication with other Technologies- 4m 21sMonitoring- 12m 23sTroubleshooting- 17m 56s