SQL Shack

AUGUST 21, 2020

This is the 12th article in the series of SQL Server Always On Availability Groups. Introduction SQL Server 2016 provides a new feature Distributed Availability Group for disaster recovery purposes. It is a particular type of availability group that helps access the multiple failover clusters.

Availability 104

Availability Servers 104

DZone

JANUARY 8, 2024

As organizations increasingly migrate their applications to the cloud, efficient and scalable load balancing becomes pivotal for ensuring optimal performance and high availability.

Azure 275

Azure Scalability Traffic Performance 275

SQL Shack

AUGUST 26, 2020

In this 14th article of SQL Server Always On Availability Group series, we monitor and failover a distributed AG. Introduction We can implement a distributed availability group between multiple independent failover cluster nodes. In this article, we will […].

Availability 102

Availability Servers Monitoring 102

SQL Shack

AUGUST 28, 2020

In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases. Introduction In the previous articles of SQL Server Always On series, we explored the following topics so far.

Availability 94

Availability Servers Virtualization Database 94

SQL Shack

FEBRUARY 28, 2020

In 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.

Availability 98

Availability Servers Database 98

SQL Shack

SEPTEMBER 23, 2020

In this 26th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.

Availability 104

Availability Servers Network Processing 104

SQL Shack

AUGUST 25, 2020

In 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.

Availability 76

Availability Servers 76

SQL Shack

JULY 15, 2020

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. You should go through the following articles and build the infrastructure before proceeding with this article.

Servers 69

Servers Availability Virtualization Infrastructure 69

SQL Shack

JANUARY 21, 2021

In this 40th article on SQL Server Always On Availability Group series, we will discuss logins synchronization between replicas. Introduction SQL Server Always On Availability Groups provides high availability and disaster recovery solution for SQL databases.

Availability 67

Availability Servers Database Monitoring 67

SQL Shack

OCTOBER 14, 2020

In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances. A brief overview of SQL Server Patches It is a recommended practice to apply the regular update to the SQL Server with the service pack (SP) […].

Servers 86

Servers Availability Processing 86

SQL Shack

SEPTEMBER 16, 2020

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database. It uses the […].

Database 104

Database Availability Servers 104

SQL Shack

JULY 30, 2020

This is the 8th article in the series for SQL Server Always On Availability Groups. Introduction SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable. By default, SQL Server […]. By default, SQL Server […].

Availability 88

Availability Database Servers 88

SQL Shack

NOVEMBER 10, 2020

In this 35th article in SQL Server Always On Availability Groups, we will implement a custom policy for monitoring AG groups.

Availability 95

Availability Servers Monitoring 95

SQL Shack

DECEMBER 10, 2020

In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it. Usually, we use SQL Server Management Studio to perform administrative tasks using the interactive windows.

Availability 87

Availability Servers Database Performance 87

SQL Shack

MARCH 8, 2021

In the 42nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks. Introduction SQL Server Always On Availability Groups provides resilience for high availability and disaster recovery solution in a multi-node architecture.

Availability 75

Availability Servers Architecture Monitoring 75

SQL Shack

JULY 23, 2020

This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups. Introduction In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group. Build three Virtual Servers with Windows Server […].

Availability 87

Availability Servers Virtualization Performance 87

SQL Shack

OCTOBER 13, 2020

In this 31st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads. Introduction In a SQL Server Always On Availability Group, we configure two or more instances for high availability and disaster recovery.

Availability 93

Availability Servers Database 93

SQL Shack

SEPTEMBER 29, 2020

In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases. Introduction In the earlier articles, we saw that the SQL Server Always On Availability Group provides high availability and disaster recovery solution in SQL Server.

Availability 71

Availability Servers Database 71

SQL Shack

AUGUST 13, 2020

This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.

Availability 98

Availability Servers 98

SQL Shack

SEPTEMBER 22, 2020

This is the 25th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases.

Servers 65

Servers Availability Database Mobile 65

SQL Shack

SEPTEMBER 11, 2020

In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes. As you configure SQL Server Always On Availability Group for the […]. You can identify potential issues, rectify them proactively.

Availability 80

Availability Servers Monitoring Database 80

SQL Shack

JULY 13, 2020

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases.

Servers 69

Servers Availability Database 69

SQL Shack

OCTOBER 6, 2020

In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances. Introduction SQL Server 2017 & 2019 works on the cross-platform operating system: Windows and Linux. You […].

Servers 52

Servers Availability Operating System Systems 52

SQL Shack

JULY 13, 2020

In 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 this article, we […].

Availability 77

Availability Servers Virtualization Network 77

SQL Shack

NOVEMBER 9, 2020

In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s. Introduction to policy-based management Policy-Based Management feature allows database professional in defining the best practices, standards for SQL Server and database related configurations.

Availability 89

Availability Servers Best Practices Database 89

SQL Shack

AUGUST 31, 2020

This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs. Introduction Recently, I received a requirement to configure the SQL Replication for the availability group database. The specific requirements were as below.

Servers 67

Servers Availability Database 67

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. In this article, I focus on the distinct predicate and the approximate percentile functions. The DATETRUNC function. So far so good.

Servers 142

Servers Testing C++ Code 142

SQL Shack

SEPTEMBER 17, 2020

This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23rd article in the SQL Server Always On Availability Group.

Availability 87

Availability Servers Database 87

SQL Shack

SEPTEMBER 1, 2020

In 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.

Servers 57

Servers Availability Database 57

SQL Shack

JULY 24, 2020

This article is a 6th article in the series for SQL Server Always On Availability Groups. Usually, we should use a separate service account for an individual server SQL Services. […]. It covers the configuration of the group managed service account (gMSA) for SQL Services.

Availability 67

Availability Servers 67

SQL Shack

JULY 14, 2020

This article explores the configuration of Windows failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups. Prerequisites In this series of articles, we will configure the SQL Server always on availability groups from end to end for your learning purpose.

Storage 75

Storage Availability Servers 75

SQL Shack

JULY 29, 2020

This is the 7th article in the series of SQL Server Always on Availability Groups. Introduction In this series of articles, we configured the SQL Server Always On Availability Group from the beginning of building virtual machines. We covered the following topics so far in this series.

Availability 80

Availability Servers Virtualization 80

SQL Shack

SEPTEMBER 8, 2020

In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database. Requirement Suppose we have multiple database environments for a critical application. These environments can be development, stage, UAT (user acceptance testing).

Availability 52

Availability Database Servers Testing 52

Percona

AUGUST 22, 2023

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 79

Availability Hardware Open Source Database 79

SQL Shack

AUGUST 5, 2020

This is the 9th article in the series of SQL Server Always On Availability Groups. Introduction SQL Server Always On is a disaster and high availability feature. In the previous articles, we explored the following features.

Availability 52

Availability Servers Database 52

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 114

Servers Best Practices Database Open Source 114

SQL Shack

SEPTEMBER 7, 2020

In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group.

Availability 58

Availability Servers Database 58