Availability Group Listener

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

19,545 reads

Blogs

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Convert date value

By pwalter83

Hi, I have a requirement to convert a date value like '7th March 2020' ...

Partitioning table techniques which one is best way?

By Saravanan_tvr

Hello All, I am about to do partitioning for my DW tables based on...

MAXDOP and cost threshold for parallelism settings

By vsamantha35

Hi All, On one of our newly migrated sup-prod azure vm which is running...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers