SQL Server Replication for Developers and DBAs

Zenler Player

Your course is loading. Hang tight.

Who is this course for? Preview
Who is Greg? Preview
What will I learn in this course? Preview
Configuring your lab environment

Introduction to replication
Typical replication patterns
Replication vs high availability
Replication vs Sync Services
Compatiblity with Other SQL Server Features
Publisher / Subscriber metaphor
Snapshots
Important note on server names
Lab 1: Core replication concepts - Installing SQL Server Replication

Snapshot replication
Transactional replication Preview
Peer-to-peer transactional replication
Merge replication
Push vs pull subscriptions
Named vs anonymous subscriptions
Replicating schema changes
Replicating stored procedures
Configuring NOT FOR REPLICATION
Configuring Distribution
Lab 2: Configuring Distribution
Lab 2: Walk-through
Quiz 2: Replication styles

Use cases for snapshot replication
Typical snapshot replication topology
Determining snapshot locations
Configuring a snapshot publication
Configuring a snapshot subscription
Lab 3: Snapshot replication
Lab 3: Walk-through
Quiz 3: Snapshot replication

Use cases for transactional replication
Typical transactional replication topology
Log reader agent
Options for initializing subscribers
Overriding change propagation
Heterogenous publications
Support for switching partitions
Configuring a transactional replication publication
Updatable Subscribers
Azure SQL Database as a subscriber
Configuring a transactional replication subscription
Considerations for transactional replication
Lab 4: Transactional replication
Lab 4: Walk-through
Quiz 4: Transactional replication

Use cases for peer to peer transactional replication
Typical peer to peer transaction replication topology
Conflict detection
Configuring peer to peer transactional replication
Removing publications and published databases
Considerations for peer to peer transactional replication
Quiz 5: Peer to peer transactional replication

Use cases for merge replication
Merge replication data flow
Subscriber types
Database schema changes
Working with merge filters
Configuring a merge replication publication
Managing identity ranges
Configuring a merge replication subscription
Configuring merge replication conflict resolvers
Optimizing merge replication performance
Denormalizing to enhance performance
Considerations for merge replication
Lab 6: Merge replication
Lab 6: Walk-through
Quiz 6: Merge replication

SQL Server Agent
Snapshot agent
Log reader agent
Distribution agent
Queue reader agent
Merge agent
Miscellaneous agents
Agent security model
Configuring agent profiles
Lab 7: Replication agents
Lab 7: Walk-through
Quiz 7: Replication agents

Replication monitor
Changing security accounts
Avoiding publisher transaction log issues
Backup, recovery, and HA strategies
Scripting replication configurations
Merge metadata clean up
Periodic data revalidation
Quiz 8: Maintaining replication

Server name mismatches
Troubleshooting snapshot replication
Troubleshooting transactional replication
Using tracer tokens to detect latency issues
Configuring thresholds and alerts
Supporting DDL replication
Restarting with replicated data only
Using sp_repldone
Troubleshooting merge replication
Recovering expired merge subscriptions
Quiz 9: Troubleshooting replication

Summary and further steps