SQL Server Replication for Developers and DBAs

Not sure if SQL Server replication is what you should be using? Not sure how to configure it? Find out fast !

Course Summary

Learn to use SQL Server Replication effectively

Your main system is way too busy
You want to offload reporting and analytics to another server
You think that moving data closer to your users would help
You need to understand the options that replication can provide to you
You’ve heard that replication is difficult but not sure if that’s true
You’ve configured some replication but not sure if you’re doing it correctly
You’ve seen slow systems with replication but you’re wondering if they were using the right type of replication
You want to learn from an expert

If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers hands-on labs with downloadable resources, and video lab walk-throughs, quizzes to check your learning, and a certificate on completion.

Enroll now for $295 USD !

Modules and Lessons

Module 0: Getting started

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

Module 1: Core replication concepts

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

Module 2: Replication styles

Snapshot replication
Transactional replication
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

Module 3: Snapshot replication

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

Module 4: Transactional 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

Module 5: Peer to peer 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

Module 6: Merge 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

Module 7: Replication agents

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

Module 8: Maintaining replication

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

Module 9: Troubleshooting 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

Module 10: Next steps

Summary and further steps

Enroll now for $295 USD !