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

2019-07-02

19,652 reads

Blogs

Azure SQL Database – Error Logs?

By

Ok, so Azure SQL doesn’t really have its own error log based somewhere on...

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

Saving integers as varchar so that I can choose '' (empty) as content

By christoph.kauflin

I am considering saving integers as varchar. The reasons for that is: The case...

2 Way replication issue faced of records skipping/not replicating.

By dineshcred

We have a replication setup wherein data entry is done at head office and...

Stored Procedure

By Data Rat

Hi Friends, I have a stored proc with 45 tables that are used to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers