Availability Group (AG)

SQLServerCentral Article

A Step by Step Guide to the Availability Group (AG) Listener

  • Article

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]

5 (3)

2019-07-02

78,897 reads

Blogs

Daily Coping 18 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

By

I’ve added a new parameter to my permissions scripts (well, just the main two...

Creating TAIL on Windows for Text Files

By

UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...

Read the latest Blogs

Forums

How to use PowerShell to set secure SA passwords for bulk servers

By Vincent92

Comments posted to this topic are about the item How to use PowerShell to...

INSERT EXEC statement cannot be nested, the Simple Solution

By Daniel Brink

Comments posted to this topic are about the item INSERT EXEC statement cannot be...

Cleaning Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Tables

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers