SQL Server Transactional Replication: A Deeper Dive

Transactional replication in SQL Server is not a new, shiny technology. In fact, a lot of people will tell you it’s an old one full of nightmares. But don’t be too quick to judge; replication still offers a lot of benefits, and most of the problems you might encounter can be quickly diagnosed and fixed if you have a deeper understanding of replication internals.

In this session, we’ll discuss the transactional replication model and what it offers. You’ll see plenty of examples of how to monitor transactions as they get from your publishers to your subscribers. There will also be examples of how you can change the behavior of your transactions too, and what benefits (and potential pitfalls) these changes offer.

Finally, you’ll see examples on how to configure transactional replication in high availability scenarios.
Prerequisites: Ideally, you’ve set up publishers and subscribers before. If you haven’t, this information is still good to help you for future replication plans.

Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.