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

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

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

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

Scalegrid

MAY 13, 2020

It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data. Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Dynatrace

NOVEMBER 20, 2019

Having released this functionality in an Early Adopter Release with OneAgent version 1.173 and Dynatrace version 1.174 back in August 2019, we’re now happy to announce the General Availability of OneAgent full-stack monitoring for Linux on the IBM Z platform, sometimes informally referred to as Z/Linux. Host-performance measures.

Availability 32

Availability Hardware Java Tuning 32

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

FEBRUARY 8, 2021

In this 41st article for SQL Server Always On Availability Groups, we will explore the session timeout configurations for AG replicas. Prerequisites You should follow articles in the series, SQL Server Always On Availability Groups and prepare the following environment.

Availability 92

Availability Servers 92

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

Scalegrid

APRIL 28, 2020

In this article, we are going to compare three of the most popular cloud providers, AWS vs. Azure vs. DigitalOcean for their database hosting costs for MongoDB® database to help you decide which cloud is best for your business. Is my database cluster still highly available? High performance. DigitalOcean Hosting FAQs. Learn more.

Azure 344

Azure AWS Database Latency 344

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

NOVEMBER 19, 2020

In this 37th article for SQL Server Always On Availability Groups, we will explore useful dynamic management views for monitoring availability replicas and databases. This article […].

Availability 90

Availability Monitoring Database Servers 90

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

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

Dynatrace

FEBRUARY 11, 2020

OneAgent knows where to connect for further runtime configuration and where to send data because the installer itself is pre-configured to connect to the exact tenant and server that it’s downloaded from. But what if your environment grows and you decide to distribute data between two Dynatrace servers?

Servers 157

Servers Tuning Systems Availability 157

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

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

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

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

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. Redis Server: 5.07, x86/64. MongoDB server: 4.4.2, BangDB server: 2.0.0, Author & founder of BangDB. About YCSB. YugabyteDB:2.5.0,

Benchmarking 308

Benchmarking Latency C++ Database 308

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

CSS Wizardry

JUNE 30, 2023

Honestly, I started writing this article, for no real reason and somewhat without context, in December 2022—over half a year ago! TTFB is a good measure of your server response times and general back-end health, and issues here may have knock-on effects later down the line (namely with Largest Contentful Paint).

Metrics 330

Metrics Google Monitoring Code 330

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. Conclusion and Other T-SQL Improvements in SQL Server 2022. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

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

Scalegrid

MAY 2, 2019

When deploying in production, it’s highly recommended to setup in a MongoDB replica set configuration so your data is geographically distributed for high availability. Check out our Getting Started with Python and MongoDB article to see how you can get up and running in just 5 easy steps. Configuring the Network Timeout Values.

Testing 55

Testing Network Database Servers 55

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

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

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

Dynatrace

APRIL 14, 2022

Further, the report lists Tomcat as the most popular Java application server. Figure 2: Spring Controller that maps the DemoObject to requests received at the server. In particular, CVE-2022-22965 affects applications running on an Apache Tomcat server as a web application archive (WAR) deployment. DIRECTORY_OF_CHOICE.

Java 228

Java Servers Code Open Source 228

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

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 6, 2020

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

AWS 85

AWS Availability Servers 85

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

JUNE 29, 2020

SQL Server Always On is a high-availability and disaster recovery solution. For on-premises infrastructure, you can follow articles here, AlwaysOn Availability Groups, and configure SQL Server always-on functionality. In the AWS cloud, the overall logic remains the […].

AWS 103

AWS Servers Availability Infrastructure 103

Dynatrace

AUGUST 8, 2019

We’re happy to announce the Early Adopter Release of OneAgent full-stack monitoring for Linux on the IBM Z platform, sometimes informally referred to as Z/Linux (available with OneAgent version 1.173 and Dynatrace version 1.174). For details on available metrics, see our help page on host performance monitoring. Dynatrace news.

Availability 26

Availability Hardware Java Tuning 26

SQL Performance

SEPTEMBER 21, 2022

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. But the available manipulation was limited and often resulted in complicated logic.

Servers 122

Servers C++ Code Cache 122