DZone

APRIL 25, 2025

Index maintenance is a critical component of database administration as it helps ensure the ongoing efficiency and performance of a Structured Query Language (SQL) Server environment. This is especially important for large, mission-critical databases, where any degradation in performance can have a significant business impact.

Best Practices 130

Best Practices Strategy Servers Database 130

DZone

JUNE 4, 2025

As SQL Server databases become increasingly targeted by cybercriminals, it's crucial to adopt proactive security measures. Traditional database security mechanisms, such as access controls, role-based permissions, and firewalls, are important but may not be sufficient to detect advanced threats or malicious insider activities.

Servers 113

Servers Database Processing Systems 113

DZone

APRIL 19, 2023

As you know, the SQL Server on Linux is becoming mature and easy to use. Still, it does not support MMC consoles in Linux which makes the administration of the SQL Server a little bit complicated. In this article, I will explain how we can move the system databases to different locations in Ubuntu Linux.

Servers 246

Servers Database Systems Operating System 246

DZone

APRIL 22, 2025

Restoring a transaction log backup in SQL Server is a crucial step in database recovery. In this article, we will learn the key steps, common errors, and best practices to restore transaction log backups in SQL Server successfully. It allows us to roll forward changes to a specific point in time.

Servers 130

Servers Best Practices Database Testing 130

DZone

MAY 30, 2025

For years, database administrators and developers working with SQL Server faced a persistent performance issue known as parameter sniffing. This problem arises because SQL Servers traditional query plan caching mechanism generates only a single execution plan for a parameterized query.

Servers 130

Servers Cache Efficiency Database 130

The Netflix TechBlog

JULY 10, 2025

With the goal of building a flexible, configuration-driven system, we looked to server-driven UI (SDUI) as an appealing solution. SDUI is a design approach where the server dictates the structure and content of the UI, allowing for dynamic updates and customization without requiring changes to the client application.

Architecture 177

Architecture Cache Latency Database 177

Dynatrace

APRIL 21, 2022

While applications are built using a variety of technologies and frameworks, there is one thing they usually have in common: the data they work with must be stored in databases. Now, Dynatrace has gone a step further and expanded its coverage and intelligent observability into the next layer: database infrastructure.

Database 246

Database DevOps Analytics Servers 246

Dynatrace

SEPTEMBER 5, 2023

Running Databases efficiently is crucial for business success Monitoring databases is essential in large IT environments to prevent potential issues from becoming major problems that result in data loss or downtime. However, horizontal scaling of these databases can take time and effort.

Database 246

Database Metrics Monitoring Servers 246

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. A classic solution for this problem is to deploy a binlog server – an intermediate proxy server that sits between the master and its slaves. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers 262

Servers Transportation Database Availability 262

Scalegrid

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 299

Azure Benchmarking Database Latency 299

Dynatrace

FEBRUARY 1, 2024

Maintaining optimal application performance is crucial for businesses, and fast databases are vital in achieving this goal. For an effective approach to database performance, it’s crucial to have a comprehensive overview of all databases, including server-side DBs.

Database 246

Database Monitoring Games Metrics 246

DZone

SEPTEMBER 16, 2024

As applications grow in complexity and user base, the demands on their underlying databases increase significantly. Efficient database scaling becomes crucial to maintain performance, ensure reliability, and manage large volumes of data. This cheatsheet provides an overview of essential techniques for database scaling.

Strategy 263

Strategy Database Scalability Performance 263

DZone

JUNE 28, 2023

Database sharding is a powerful technique employed to manage large databases more effectively. It involves partitioning a large database into smaller, more manageable parts, known as shards. The above diagram presents a visual representation of a sharded database.

Database 232

Database Scalability Servers Performance 232

DZone

FEBRUARY 25, 2023

We will show you exactly how to deploy a Nodejs app to the server using Docker containers, RDS Amazon Aurora, Nginx with HTTPS, and access it using the Domain Name. These APIs will be used to check the status of the app, insert data in the database and fetch and display the data from the database.

AWS 274

AWS Servers Internet Internet 274

Dynatrace

SEPTEMBER 8, 2023

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database 290

Database Artificial Intelligence Metrics Monitoring 290

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 246

Infrastructure Database Monitoring Metrics 246

DZone

OCTOBER 9, 2022

Witness Server and Witness Directory are the most critical components of the Database Availability Group (DAG). DAG requires Witness Server or File Share Witness (FSW) and Directory to maintain the Quorum. In case of Witness Server failure, the Quorum is no longer maintained, leading to inconsistent DAG.

Servers 242

Servers Database Availability 242

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

Dynatrace

APRIL 22, 2025

An attacker has gained access through security misconfigurations in an API server, escalated privileges, and deployed cryptocurrency mining pods that consume massive resources. API server The API server is the gateway to your Kubernetes kingdom. An unprotected kubelet is like giving attackers direct access to your servers.

Network 157

Network Servers Best Practices Strategy 157

DZone

OCTOBER 26, 2021

Database Availability Group (DAG) is a built-in framework in Microsoft Exchange Server that uses continuous replication and failover clustering to ensure high availability and site resilience. In DAG, there is one active server and a copy of the database on the active server is replicated across all passive servers.

Servers 188

Servers Database Availability Performance 188

Scalegrid

APRIL 28, 2025

Monitoring MySQL databases is essential for maintaining performance, detecting issues early, and ensuring efficient resource use by tracking critical metrics. With MySQL supporting various applications, its important to have the right tools in place to monitor database health and performance.

Monitoring 147

Monitoring Open Source Analytics Metrics 147

Dynatrace

MAY 13, 2025

Powered by LLMs, vector databases, retrieval augmented generation (RAG) pipelines, and additional tools, these AI agents are expanding extensively, giving rise to multi-agent systems, cross-agent protocols, and context-sharing standards. Dynatrace MCP server reference architecture.

Artificial Intelligence 295

Artificial Intelligence Monitoring Google Strategy 295

Scalegrid

OCTOBER 18, 2024

Due to its versatility for storing information in both structured and unstructured formats, PostgreSQL is the fourth most used standard in modern database management systems (DBMS) worldwide 1. Facilitating remote access to other computers or servers with easier navigation.

Open Source 147

Open Source Database Cloud Operating System 147

Scalegrid

MARCH 10, 2025

A graphical user interface (GUI) helps simplify how you interact with your MySQL databases. Whether youre a developer, database administrator, or data analyst, a good GUI can make everyday tasks faster, clearer, and less error-prone. If youre working with MySQL on a web server and want a browser-based tool, this ones hard to beat.

Open Source 162

Open Source Database Design Cloud 162

Dynatrace

APRIL 22, 2025

Initial access An attacker discovers an exposed Kubernetes API server during a routine scan. Misconfiguration : Exposed API server + overly permissive RBAC settings Attacker technique : The attacker uses automated tools to authenticate as the default service account and begins reconnaissance of the cluster resources. Misconfiguration.

Strategy 144

Strategy Azure Best Practices Network 144

Scalegrid

FEBRUARY 27, 2025

Incremental Backups: Speeds up recovery and makes data management more efficient for active databases. Improved JSON Handling & Security: Improved logical replication and the new MAINTAIN privilege give database administrators more control and flexibility. Start your free trial today!

Speed 130

Speed Database Storage Efficiency 130

DZone

FEBRUARY 9, 2024

SQL Server Always on availability group is a great addition to SQL Server for providing high availability and disaster recovery. Always-on availability group support failover the environment for a discrete set of user databases, known as availability databases, that failover together.

Availability 288

Availability Database Servers 288

The Netflix TechBlog

MAY 9, 2025

Initially, the system was designed to be simple, secure, and efficient, with an underlying ethos of device-originated and server-proxied operations. The system consisted of three main components: the Microsoft Ad Server, Netflix Ads Manager, and Ad Event Handler.

Processing 184

Processing Metrics Servers Engineering 184

Dynatrace

MAY 21, 2025

Also, their legacy monitoring system ingested monitoring events into a SQL database , from which our customer had to tail/parse the recent log records. With OneAgent observing their SQL server, they have entered the next level of database observability. Creating correlation and context between these wasnt easy.

Retail 184

Retail Airlines Healthcare Transportation 184

DZone

SEPTEMBER 25, 2023

The error is like this one: Msg 26019, Level 16, State 1, Line 1 BACKUP detected corruption in the database log. This error usually happens when you are doing a backup of the transaction log. Check the errorlog for more information. BACKUP LOG is terminating abnormally.

Database 147

Database Servers 147

Scalegrid

SEPTEMBER 5, 2024

Managing High Availability (HA) in your PostgreSQL hosting is very important to ensuring your database deployment clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. The primary server is responsible for handling all write operations and maintaining data accuracy.

Availability 257

Availability Servers Database Open Source 257

DZone

FEBRUARY 10, 2025

Although traditional CMS solutions are versatile, they involve the burden of taking care of databases and server-side rendering. The use of digital platforms has made it crucial for people and companies to build their brands online.

Website 147

Website Scalability Efficiency Database 147

Scalegrid

JANUARY 10, 2025

Heading into 2024, SQL databases will remain essential in data management, increasingly using distributed systems to meet growing needs for scalability and reliability. According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry.

Database 130

Database Best Practices Scalability Blockchain 130

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? pgAdmin uses too many resources.

Open Source 262

Open Source Database Azure Servers 262

High Scalability

SEPTEMBER 3, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.

Open Source 55

Open Source Cache C++ Database 55

DZone

JANUARY 2, 2024

Sharding, a database architecture pattern, involves partitioning a database into smaller, faster, more manageable parts called shards. Each shard is a distinct database, and collectively, these shards make up the entire database. What Is Sharding?

Architecture 270

Architecture Database Scalability Servers 270

Scalegrid

AUGUST 22, 2019

On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. All of these tests were performed while the application was running and inserting data to the PostgreSQL database. Standby Server Tests. Reboot the server. Master/Primary Server Tests.

Availability 277

Availability Servers Network Testing 277