High Availability (HA)

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)

2021-05-17

318 reads

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 […]

5 (1)

2020-12-07

15,133 reads

Blogs

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Azure Arc

By

Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Read the latest Blogs

Forums

Log shipping performing log backups despite its backup jobs being disabled

By alexhdavies

Hi Came across an odd issue this evening. Running a migration over the weekend...

Granting Schema Permissions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Granting Schema Permissions

Lots of Data and AI Helping Firefighters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lots of Data and AI...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers