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 175: Migrating to the Cloud
Episode NULL: Summer Break
Episode 174: Power BI Report Server
Episode 173: New Data Certifications
Episode 172: Power BI Monitoring
Episode 171: SQL Server Encryption
Episode 170: Devops with Power BI
Episode 169: Should you learn to code?
Episode 168: Data Privacy Settings
Episode 167: Azure SQL Data Sync
Episode 166: Custom Visuals
Episode 165: Artificial Intelligence
Episode 164: The DAX Episode
Episode 163: Very Large Databases
Episode 162: Power Query vs DAX
Episode 161: Migrating/Upgrading 8000 databases
Episode 160: Power BI Embedded
Episode 159: Power BI Dataflows
Episode 158: Gateways
Episode 157: Windows Server Core
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
Acquired