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.
Course info
Rating
(227)
Level
Intermediate
Updated
June 21, 2013
Duration
1h 52m
Table of contents
Monitoring
12m 23s
Troubleshooting
17m 56s
Description
Course info
Rating
(227)
Level
Intermediate
Updated
June 21, 2013
Duration
1h 52m
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.

About the author
About the author

Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.

More from the author
More courses by Joe Sack