SQL Server Administration and Maintenance

SQT01 Designing and Managing a SQL Server Replication Topology


9:30am - 10:45am

Level: Introductory to Intermediate

Chad Churchwell

Premier Field Engineer


This session is focused on design and architectural decisions when choosing replication technology for your organization. We'll cover all the moving pieces involved with replication, the internal architecture of how replication works, as well as describing the agents in detail. You'll also learn what replication is intended to do as well as what it is not a good fit for. We'll cover the new SQL 2014 support enhancements as well as combining with AlwaysOn Availability groups to protect your replication environment to ensure minimal downtime; also monitoring and alerting on replication errors and latency to ensure accurate data.

You will learn:

  • How replication works behind the scenes and architecturally to better prepare yourself with knowledge to manage a replicated environment
  • How to be proactive and use best practices for monitoring and alerting of replication issues when they arise as well as how to resolve common replication errors
  • How replication can be used with a high availability technology to ensure protection of your mission critical systems