AlwaysOn

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

15,182 reads

Blogs

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

SQL Undercover TV – Instant File Initialisation

By

Adrian has a look at the performance benefits of instant file initialisation Below is...

Read the latest Blogs

Forums

In-memory database

By LLSQL42

Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database,...

Replication CDC -- Cannot Truncate Table

By GonnaCatchIT

Dear All, We just enabled Replication services (CDC) on few of the databases. Now...

Verify Server online status using sql server query

By Rock

Team I have populated list of ServerName from the sql server query. I would...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers