Have Availability Groups Gotten Easier Lately? - Brent Ozar ...
Dec 3, 2018 ... The secondaries are not meant to ever become primary, they're only there as readable secondaries and they receive reporting / some async read- ...
Search results for "availability+groups"
Your search for "availability+groups" returned 100 results:
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,834 reads
Steps for Installing AlwaysOn Availability Groups - SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
2020-12-07
120,180 reads
Expanding AlwaysOn Availability Groups with Replication ...
Jan 14, 2013 ... Configure all AG Replicas as Publishers. Each of those replicas that are participating in an AG and will have a published database needs to be ...
TDE with Automatic Database Seeding
Transparent Data Encryption on an Availability Group and Automatic Database Seeding
2018-03-08
2,309 reads
SQL Server Contained Availability Groups Configuration
Jan 10, 2023 ... Configuring Contained Availability Groups · Select the Create an availability group listener option · Type the Listener DNS name and Port number ...
2020-07-06
9,145 reads
Configuring Availability Groups in Ubuntu
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
3,101 reads
AlwaysOn Availability Groups in SQL Server 2012
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
2012-08-28
9,661 reads
Ensure that SSRS is Working while Using Availability Groups
This article explains how to get around one of the issues when the SSRS databases are part of an Availability Group.
2020-11-17
4,665 reads
Blogs
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
Forums
Degraded Performance in 2017 vs 2008 R2 with inserts
We're finally upgrading from SQL Server 2008 R2 Enterprise to SQL Server 2017 Standard...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Question of the Day
Restoring the Resource Database
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers