-
Module 1: Core replication concepts
9 Lessons-
StartIntroduction to replication
-
StartTypical replication patterns
-
StartReplication vs high availability
-
StartReplication vs Sync Services
-
StartCompatiblity with Other SQL Server Features
-
StartPublisher / Subscriber metaphor
-
StartSnapshots
-
StartImportant note on server names
-
StartLab 1: Core replication concepts - Installing SQL Server Replication
-
-
Module 2: Replication styles
13 Lessons-
StartSnapshot replication
-
PreviewTransactional replication
-
StartPeer-to-peer transactional replication
-
StartMerge replication
-
StartPush vs pull subscriptions
-
StartNamed vs anonymous subscriptions
-
StartReplicating schema changes
-
StartReplicating stored procedures
-
StartConfiguring NOT FOR REPLICATION
-
StartConfiguring Distribution
-
StartLab 2: Configuring Distribution
-
StartLab 2: Walk-through
-
StartQuiz 2: Replication styles
-
-
Module 3: Snapshot replication
8 Lessons -
Module 4: Transactional replication
15 Lessons-
StartUse cases for transactional replication
-
StartTypical transactional replication topology
-
StartLog reader agent
-
StartOptions for initializing subscribers
-
StartOverriding change propagation
-
StartHeterogenous publications
-
StartSupport for switching partitions
-
StartConfiguring a transactional replication publication
-
StartUpdatable Subscribers
-
StartAzure SQL Database as a subscriber
-
StartConfiguring a transactional replication subscription
-
StartConsiderations for transactional replication
-
StartLab 4: Transactional replication
-
StartLab 4: Walk-through
-
StartQuiz 4: Transactional replication
-
-
Module 5: Peer to peer transactional replication
7 Lessons-
StartUse cases for peer to peer transactional replication
-
StartTypical peer to peer transaction replication topology
-
StartConflict detection
-
StartConfiguring peer to peer transactional replication
-
StartRemoving publications and published databases
-
StartConsiderations for peer to peer transactional replication
-
StartQuiz 5: Peer to peer transactional replication
-
-
Module 6: Merge replication
15 Lessons-
StartUse cases for merge replication
-
StartMerge replication data flow
-
StartSubscriber types
-
StartDatabase schema changes
-
StartWorking with merge filters
-
StartConfiguring a merge replication publication
-
StartManaging identity ranges
-
StartConfiguring a merge replication subscription
-
StartConfiguring merge replication conflict resolvers
-
StartOptimizing merge replication performance
-
StartDenormalizing to enhance performance
-
StartConsiderations for merge replication
-
StartLab 6: Merge replication
-
StartLab 6: Walk-through
-
StartQuiz 6: Merge replication
-
-
Module 7: Replication agents
12 Lessons-
StartSQL Server Agent
-
StartSnapshot agent
-
StartLog reader agent
-
StartDistribution agent
-
StartQueue reader agent
-
StartMerge agent
-
StartMiscellaneous agents
-
StartAgent security model
-
StartConfiguring agent profiles
-
StartLab 7: Replication agents
-
StartLab 7: Walk-through
-
StartQuiz 7: Replication agents
-
-
Module 8: Maintaining replication
8 Lessons -
Module 9: Troubleshooting replication
11 Lessons-
StartServer name mismatches
-
StartTroubleshooting snapshot replication
-
StartTroubleshooting transactional replication
-
StartUsing tracer tokens to detect latency issues
-
StartConfiguring thresholds and alerts
-
StartSupporting DDL replication
-
StartRestarting with replicated data only
-
StartUsing sp_repldone
-
StartTroubleshooting merge replication
-
StartRecovering expired merge subscriptions
-
StartQuiz 9: Troubleshooting replication
-
