High Availability (HA)

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 (1)

You rated this post out of 5. Change rating

2021-05-17

9,116 reads

SQLServerCentral Article

Steps for Installing AlwaysOn Availability Groups - SQL 2019

  • Article

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]

4.5 (2)

You rated this post out of 5. Change rating

2020-12-07

148,956 reads

Blogs

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

By

There was a time when the Chief Data Officer lived in the shadows of...

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

By Site Owners

Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...

T-SQL Fundamentals

By Site Owners

Comments posted to this topic are about the item T-SQL Fundamentals

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers