Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Working with SQL Server Replication
Module 0: Getting started
Who is this course for? (0:57)
Who is Greg? (1:18)
What will I learn in this course? (0:56)
Configuring your lab environment (12:24)
Module 1: Core replication concepts
Introduction to replication (1:32)
Typical replication patterns (3:24)
Replication vs high availability (1:24)
Replication vs Sync Services (2:45)
Compatiblity with Other SQL Server Features (2:38)
Publisher / Subscriber metaphor (2:02)
Snapshots (2:46)
Important note on server names
Lab 1: Core replication concepts - Installing SQL Server Replication (2:55)
Module 2: Replication styles
Snapshot replication (1:53)
Transactional replication (2:54)
Peer-to-peer transactional replication (3:03)
Merge replication (3:28)
Push vs pull subscriptions (1:30)
Named vs anonymous subscriptions (1:26)
Replicating schema changes (0:59)
Replicating stored procedures (1:17)
Configuring NOT FOR REPLICATION (1:56)
Configuring Distribution (6:20)
Lab 2: Configuring Distribution
Lab 2: Walk-through (1:40)
Quiz 2: Replication styles
Module 3: Snapshot replication
Use cases for snapshot replication (2:07)
Typical snapshot replication topology (1:36)
Determining snapshot locations (1:49)
Configuring a snapshot publication (4:02)
Configuring a snapshot subscription (4:26)
Lab 3: Snapshot replication
Lab 3: Walk-through (5:58)
Quiz 3: Snapshot replication
Module 4: Transactional replication
Use cases for transactional replication (1:37)
Typical transactional replication topology (1:36)
Log reader agent (1:30)
Options for initializing subscribers (1:26)
Overriding change propagation (3:01)
Heterogenous publications (1:24)
Support for switching partitions (1:27)
Configuring a transactional replication publication (3:54)
Updatable Subscribers (1:57)
Azure SQL Database as a subscriber (1:59)
Configuring a transactional replication subscription (4:01)
Considerations for transactional replication (2:40)
Lab 4: Transactional replication
Lab 4: Walk-through (3:57)
Quiz 4: Transactional replication
Module 5: Peer to peer transactional replication
Use cases for peer to peer transactional replication (1:19)
Typical peer to peer transaction replication topology (1:15)
Conflict detection (1:18)
Configuring peer to peer transactional replication (9:09)
Removing publications and published databases (1:32)
Considerations for peer to peer transactional replication (1:03)
Quiz 5: Peer to peer transactional replication
Module 6: Merge replication
Use cases for merge replication (1:05)
Merge replication data flow (1:13)
Subscriber types (1:13)
Database schema changes (2:46)
Working with merge filters (1:53)
Configuring a merge replication publication (7:08)
Managing identity ranges (1:24)
Configuring a merge replication subscription (3:06)
Configuring merge replication conflict resolvers (2:32)
Optimizing merge replication performance (1:03)
Denormalizing to enhance performance (1:10)
Considerations for merge replication (1:25)
Lab 6: Merge replication
Lab 6: Walk-through (5:56)
Quiz 6: Merge replication
Module 7: Replication agents
SQL Server Agent (1:26)
Snapshot agent (1:11)
Log reader agent (1:18)
Distribution agent (1:03)
Queue reader agent (1:03)
Merge agent (1:31)
Miscellaneous agents (2:00)
Agent security model (1:30)
Configuring agent profiles (1:46)
Lab 7: Replication agents
Lab 7: Walk-through (1:36)
Quiz 7: Replication agents
Module 8: Maintaining replication
Replication monitor (2:54)
Changing security accounts (1:29)
Avoiding publisher transaction log issues (1:35)
Backup, recovery, and HA strategies (2:12)
Scripting replication configurations (1:32)
Merge metadata clean up (1:37)
Periodic data revalidation (3:28)
Quiz 8: Maintaining replication
Module 9: Troubleshooting replication
Server name mismatches (1:46)
Troubleshooting snapshot replication (1:29)
Troubleshooting transactional replication (1:24)
Using tracer tokens to detect latency issues (2:09)
Configuring thresholds and alerts (1:43)
Supporting DDL replication (3:26)
Restarting with replicated data only (1:12)
Using sp_repldone (1:35)
Troubleshooting merge replication (0:53)
Recovering expired merge subscriptions (1:19)
Quiz 9: Troubleshooting replication
Module 10: Next steps
Summary and further steps (0:48)
Typical snapshot replication topology
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock