Log Reader Agent Fail on Always On availability Groups configured on Multi-subnet

Recently I was working with one of Microsoft Partner on following issue wherein customer was migrating to SQL SERVER 2016 and during testing they have found Log Reader Agent was failing. I would like to share my learning from this issue and let me know if it is helpful or if you have any question. Consider… Read more

SQL SERVER Transactional and Merge Replication internal and work flow explained

Recently Sravani and I delivered session on SQL SERVER Transactional and Merge Replication and covered following topics: Different types of Replication in SQL Server Transaction replication work flow and troubleshooting latency – tips Merge replication workflow and troubleshooting agent failures Understanding Merge replication metadata Replication with SQL Server Availability groups Demos for replication issues You can… Read more