The Transactional Replication (TR) is still one of my favourite parts of SQL Server, and provides some distinctive advantages over Always On Availability Group (AG) Read Only secondaries. The TR advantages include : You don’t have to replicate everything when using TR, you can select tables, columns or even data subsets. You can also eliminate … Continue reading Transactional Replication VS Availability Groups for Read Only Workloads