June 2019 ~ Technology blog by Rathish kumar

SQL Server Always On Availability Group (AG) Listener: step by step guide

June 10, 2019 / by Rathish

Availability databases hosted on SQL Server Always On Availability Group (AG) can be connected using a unique Virtual Network Name (VNN) called Availability Group Listener. When Availability Group is enabled, clients can connect to databases in both...

Step by step guide to add SSISDB to SQL Server 2016 Always On Availability Group (AG)

June 01, 2019 / by Rathish

Starting from SQL Server 2016, you can add SSISDB as Availability Database in Always On Availability Group (AG). This enables high availability and automated failover for SSISDB. This article provides step by step guide to add SSISDB to Availability...