Replication: For Those Who Dare!

Are you tired of the requirements and limitations of Availability Group Readable Secondaries? Is your company looking to move to the cloud, and you have a requirement to synchronize data from on premises database to the cloud for hybrid environments? Have you considered using SQL Server Replication, but find it difficult to administer? This full day training session will step through the inner workings of SQL Server Replication, starting with basic configuration and core components, then diving deeper into how the different agents function, the distribution database tables, and explaining how to prevent problems that stop replication in its tracks. We will discuss how to configure replication subscribers on premises and in the cloud using Azure SQL Database or Managed Instances to offload read-only workloads without having to replicate the entire database. We will look at the tools natively available that allow you to fix problems and avoid a full reinitialization of the subscribers, how to rapidly deploy additional subscribers for scalable reads, and what is and is not possible with Replication in SQL Server. Come learn why this old technology is still capable of solving new business problems in both legacy and modern environments. .