22-25 April 2026 
SQLBits 2017
SQL Server Replication-What, How and Why
SQL Server Replication: What is it? How does it work? Why would you want to use it in your environment?
In an AlwaysOn world we focus on entire databases being highly available. However, replication offers another, arguably more powerful, way to make data available on multiple servers/locations that steps outside of "normal" High Availabilty scenarios. This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. You will leave the session with an understanding of how you can leverage this feature to achieve solutions that are not possible using other High Availabilty features. The content will be valid for all versions of SQL Server from 2005 onward.
Speakers
William Durkin's previous sessions
Query Store without SQL 2016 = Open Query Store
Query Store was the cool new feature in SQL 2016, but what about those of us stuck on older versions of SQL Server? Introducing: Open Query Store! This session will explain what OQS is and how it can help you take control of your query plans.
SQL Server Replication-What, How and Why
SQL Server Replication: What is it? How does it work? Why would you want to use it in your environment?