In the 18th part of the SQL Server Always On Availability Group series, we will discuss the cross-database MSDTC support in an availability group.
Read more »
Always On Availability Groups
Configuring SQL Server replication for distribution databases in SQL Server Always On Availability Groups
September 1, 2020In this 17h article of the SQL Server Always On Availability Group series, we are going to explore the SQL Server replication for the distribution database in the availability group.
Read more »
Configure SQL Server replication for a database in SQL Server Always On Availability Groups
August 31, 2020This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs.
Read more »
Transparent Data Encryption for SQL Server Always On Availability Groups
August 28, 2020In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases.
Read more »
Monitor and failover a Distributed SQL Server Always On Availability Group
August 26, 2020In this 14th article of SQL Server Always On Availability Group series, we monitor and failover a distributed AG.
Read more »
Deploy a distributed SQL Server Always On Availability Group
August 25, 2020In the previous article, An overview of distributed SQL Server Always On Availability Groups, we explored the concept of the distributed availability groups in SQL Server Always On Availability Group. It is available from Windows Server 2016 and SQL Server 2017.
Read more »
An overview of distributed SQL Server Always On Availability Groups
August 21, 2020This is the 12th article in the series of SQL Server Always On Availability Groups.
Read more »
Configure a SQL Server Always On Availability Group on the domain-independent Failover Cluster
August 13, 2020This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.
Read more »
Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups
August 12, 2020This is the 10th article in the series for SQL Server Always On Availability Groups.
Read more »
Automatic Page Repair in SQL Server Always On Availability Groups
August 5, 2020This is the 9th article in the series of SQL Server Always On Availability Groups.
Read more »
Database-level health detection in SQL Server Always On Availability Groups
July 30, 2020This is the 8th article in the series for SQL Server Always On Availability Groups.
Read more »
Add or remove a node from SQL Server Always On Availability Groups using T-SQL scripts
July 29, 2020This is the 7th article in the series of SQL Server Always on Availability Groups.
Read more »
Configure Managed Service Accounts for SQL Server Always On Availability Groups
July 24, 2020This article is a 6th article in the series for SQL Server Always On Availability Groups. It covers the configuration of the group managed service account (gMSA) for SQL Services.
Read more »
Add a new node into existing SQL Server Always On Availability Groups
July 23, 2020This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups.
Read more »
Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups
July 15, 2020In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations.
Read more »
Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups
July 14, 2020This article explores the configuration of Windows failover clusters, storage controllers, and quorum configurations for SQL Server Always On Availability Groups.
Read more »
Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups
July 13, 2020In this series for SQL Server Always On Availability Groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In the article, A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016, we configured three virtual machines with their networking configurations.
Read more »
A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016
July 13, 2020In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration.
Read more »
Configuring SQL Server Always On Availability Groups on AWS EC2
July 6, 2020In this article, we will review how to set up multi-subnet Always On Availability groups using AWS EC2 instances and AWS FSx as file share witness.
Read more »
AWS Launch Wizard for quick SQL Server Always On deployments
June 29, 2020SQL Server Always On is a high-availability and disaster recovery solution. We can use multiple secondary replicas for configuring database backups, redirect read requests to offload primary instance load.
Read more »
SQL Server Always On Availability Groups Interview Questions & Answers
February 28, 2020In this article, we will discuss a number of interview questions that you could be asked about the SQL Server Always On Availability Groups feature when attending an interview for the SQL Server database administrator role.
Windows Failover Cluster Quorum Modes in SQL Server Always On Availability Groups
August 8, 2019This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups.
Read more »
Max Worker Threads for SQL Server Always on Availability Group databases
July 26, 2019This article gives an overview of the Max Worker Threads for the SQL Server Always On Availability Group databases.
Read more »
Azure SQL Server auto-failover groups
July 18, 2019In this article, we will review how to set up auto-failover groups in Azure SQL Server and how failover group is different from active geo-replication in Azure. Auto-failover group is an Azure SQL database feature that replicates one or a group of databases to the secondary Azure SQL server in the cross-region. We cannot have a secondary server in the same region. This feature is used to failover all the databases in the failover group in case of disaster and the failover is automatic.
Read more »
Azure SQL database Geo-Replication
July 15, 2019In this article, we will review how to set up Geo-Replication on Azure SQL databases. Geo-Replication is an Azure SQL database feature that allows you to create a readable secondary database in the same region or cross-region. We can failover to the secondary database in case of an outage for a long time on the primary database server. We can also use this feature to migrate a database from one server to another server in the same or cross region with minimal downtime. Geo-replication uses the Always-on feature to replicate committed transactions to the secondary database asynchronously.
Read more »