Rathish kumar B

Software Engineer, I share my technical experiments and learnings. Visit my blog: https://www.rathishkumar.com/

SQLServerCentral Article

A Step by Step Guide to the Availability Group (AG) Listener

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

7,732 reads

SQLServerCentral Article

A Step by Step Guide to the Availability Group (AG) Listener

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

You rated this post out of 5. Change rating

2019-07-02

129,710 reads

Blogs

Using SQLFluff

By

I thought I didn’t care about linting, and lately, I haven’t written a lot...

Marketing Analyst: The Data-Driven Superhero Your Company Needs

By

Want to blend your love of marketing with the power of data? Becoming a...

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Azure SQL database import permissions

By Jo Pattyn

What the required permissions are for "Database import" on an Azure SQL database  ...

Migrating MDS model individually using MDS UI

By jaango123

Hi All,   Is there a way i can create package for an individual...

Visit the forum

Question of the Day

Column Adds and Drops

I run this batch on SQL Server 2022. What happens?

ALTER TABLE dbo.Accounts
 ADD AccountAccessType INT
GO
ALTER TABLE dbo.Accounts
 DROP AccountAccessType
GO

See possible answers