If you have ever been responsible for a replication environment, you know what a pain that can be. Many of the guests of the show will point out their frustration with replication and many are loathe to use it--myself included; however, there are a few brave souls out in the world who do use replication regularly--and even use it well. Chuck Lathrope is our guest today and he talks us through some of the components of replication and why we might not need to be so skittish about this long time feature.
We cover all the basics including an overview of Transactional Replication, Merge Replication, Peer-to-Peer replication and Snapshot Replication, the concept of publisher, distributor and subscriber in relation to replication. The most important piece is Chuck gives us some good business cases for why we might use replication and I think you will find the discussion interesting. Thanks for joining us on the SQL trail!
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/05/24/episode-97-sql-server-replication/ and have fun on the SQL trail.
Episode 16 SQL Server Agent
Episode 15 Working at a University
Episode 14: SQL Server Clustering
Episode 13 Apply Yourself
Episode 12: Database Corruption
Episode 11: SQL Server Statistics
Episode 10: Test Anxiety and Test Preparation
Episode 09: Database Automation
Episode 08: Database Design
Episode 07: SQL Server Security
SQL Data Partners Podcast: Episode 06 Build Your Personal Brand
SQL Data Partners Episode 05: Principal of Least Privilege
SQL Data Partners Podcast Episode 04: Advanced Backup Options
SQL Data Partners Podcast Episode 03: Backup and Recovery
SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About
SQL Data Partners Podcast Episode 02: Extended Events
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast