Have You Deployed an Availability Group?
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
2020-04-03
217 reads
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
2020-04-03
217 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
78,897 reads
In this case, the cause of the long failover time was enabling Query Store after upgrading, for a database with a large workload of ad hoc queries, meaning there was 100GB of Query Store data to load.
2019-05-31
2018-11-15
697 reads
2018-07-16
691 reads
2018-06-11
770 reads
In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.
2018-03-27
1,307 reads
Transparent Data Encryption on an Availability Group and Automatic Database Seeding
2018-03-08
1,676 reads
In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.
2018-02-05
2,385 reads
Set up and use the automatic databases seeding feature for Availability Groups.
2018-01-22
5,595 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I’ve added a new parameter to my permissions scripts (well, just the main two...
By Steve Jones
UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...
Comments posted to this topic are about the item How to use PowerShell to...
Comments posted to this topic are about the item INSERT EXEC statement cannot be...
Comments posted to this topic are about the item Cleaning Tables