SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

SQL Shack

NOVEMBER 16, 2020

In this 36th article for SQL Server Always On series, we will explore various dynamic management views (DMV’s) for monitoring the AG replicas. Introduction SQL Server Always On Availability Groups gives you the ability to safeguard the SQL databases and implements a solution for high-availability and disaster recovery.

Availability 122

Availability Servers Monitoring Database 122

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 Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. Previously, to access data from […].

Servers 99

Servers Availability Virtualization Database 99

SQL Shack

OCTOBER 20, 2020

In this 33rd article of SQL Server Always On Availability Group series, we will use extended events to monitor the availability group. Introduction Database professionals’ primary role is to do proactive monitoring for ensuring system availability. You can use […].

Availability 107

Availability Monitoring Servers Database 107

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

DZone

FEBRUARY 15, 2023

In this article, I’m going to demonstrate how you can migrate a comprehensive web application from MySQL to YugabyteDB using the open-source data migration engine YugabyteDB Voyager. Nowadays, many people migrate their applications from traditional, single-server relational databases to distributed database clusters.

Open Source 286

Open Source Scalability Database Servers 286

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

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

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.

Availability 52

Availability Database Servers Testing 52

SQL Shack

SEPTEMBER 21, 2020

In the 20th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. In this article, we will use the DBATools commands for this purpose.

Availability 52

Availability Database Servers Processing 52

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

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. 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.

Availability 83

Availability Hardware Open Source Database 83

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. Introduction Windows PowerShell is a scripting language that offers useful modules for database professionals (Developer and DBA).

Availability 87

Availability Servers Database 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 4, 2020

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.

Availability 56

Availability Database Servers 56

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

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 116

Servers Best Practices Database Open Source 116

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. Introduction Monitoring is an essential and critical aspect of database professionals. As you configure SQL Server Always On Availability Group for the […].

Availability 80

Availability Servers Monitoring Database 80

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

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

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

DECEMBER 14, 2020

In this 39th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups. Introduction The SSIDB is the repository for all your packages and their configurations for integration service projects.

Availability 60

Availability Servers Database Testing 60

SQL Shack

DECEMBER 12, 2023

This article explains some of the popular SQL Server monitoring tools and techniques. Database monitoring: a quick reminder Database monitoring is a set of tools and techniques used to create and maintain an application infrastructure that is highly available and performs at high speed.

Monitoring 52

Monitoring Servers Speed Database 52

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. A set of bit manipulation functions.

Servers 142

Servers Testing C++ Code 142

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. Data transfer technology.

Cache 130

Cache Storage Scalability Architecture 130

SQL Shack

JULY 26, 2019

This article gives an overview of the Max Worker Threads for the SQL Server Always On Availability Group databases. SQL Server Always On Availability Group is a widely accepted feature to implement high availability and disaster recovery solution (HADR). It is available from SQL Server 2012 onwards.

Availability 42

Availability Database Servers 42

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

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. In this article I focus on windowing and NULL-related improvements. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

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

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Three distinct modes are available within MySQL when setting up your binary logs’ format.

Database 162

Database Strategy Servers Best Practices 162

Percona

MARCH 16, 2023

Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS). With the MyDBaaS tool, you can choose from three operators available.

Infrastructure 96

Infrastructure Database AWS Monitoring 96

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. Once node3 becomes available again, the virtual IP should come back to node3.

Servers 91

Servers Virtualization Open Source Scalability 91

SQL Shack

JUNE 29, 2020

SQL 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. In the AWS cloud, the overall logic remains the […].

AWS 103

AWS Servers Infrastructure Availability 103

SQL Shack

JULY 8, 2019

In this article, we will review how to setup SQL replication with publisher database in Always On availability groups so that replication continuous to sync even after failover to the secondary server in the availability group.

Availability 43

Availability Database Servers 43

SQL Shack

MARCH 21, 2019

In the previous article of this series on the SQL Server transaction log, we discuss the SQL Server database recovery models, Full, Simple and Bulk-Logged, and the how the recovery model option of the database affects the way the SQL Server Engine works with the transaction logs.

Servers 53

Servers Availability Database Engineering 53

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions.

Benchmarking 308

Benchmarking Latency C++ Database 308