Rathish kumar B

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

2019-07-02

13,224 reads

Blogs

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Read the latest Blogs

Forums

OLE DB 0x80004005 connection error trying to run SQL HA Maintenance Plans

By sg_twinmaple

Hi, I'm getting a connection error when I try to run even the most...

Update parent row from child row that has partial data.

By pcq0125

On the same table I have table rows that are broken from the import...

Space issue on a table

By SQLAddict01

All,   I am working on implementing table partitioning on a existing table. The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers