This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
5,549 reads
2022-01-19
339 reads
2022-01-12
335 reads
This guide helps you get started on troubleshooting some of the common issues in AlwaysOn Availability Groups and monitoring AlwaysOn Availability Groups. It is intended to provide original content as well as a landing page of useful information that is already published elsewhere.
2021-08-25
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 […]
2021-05-17
2,269 reads
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
2020-08-25
2,191 reads
This script can be used to generate Dashboard report for Always-on AG databases. Script can be placed in SQL Agent to generate report.
2020-05-22 (first published: 2020-05-12)
1,643 reads
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 […]
2019-07-02
81,271 reads
Last month (I ran just a little bit late writing this, it was meant...
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Hi All, I have a requirement that if there is no weekend data then...
Description: Alight Motion edits application that allows you to edit videos in the Android smartphone....
Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...
Ask SSC