As databases grow larger in both size and usage scaling out becomes a natural design evolution to improve performance and availability. This presentation will make the case for using transactional replication as one good way to do this. We'll look at how transactional replication is both a high performance and high availability technology, explain the fundamentals of how transactional replication works, demonstrate different ways that it can deployed, and then walk through how to set up a simple publication and subscription.
Kendal began working with SQL Server 7.0 as a VB developer 10 years ago. He has spent the last 8 years as a production DBA working on systems that process hundreds of millions of transactions per day. He is currently Senior DBA at Channel Intelligence in Celebration, FL where he is responsible for the management, monitoring, and performance of 40+ SQL Servers.
To access materials please fill out the form below.