Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 138

Database Servers Testing Programming 138

Scalegrid

JANUARY 11, 2024

This article strips away the complexities, walking you through best practices, top tools, and strategies you’ll need for a well-defended cloud infrastructure. Get ready for actionable insights that balance technical depth with practical advice. This includes servers, applications, software platforms, and websites.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

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 Scalability Best Practices Blockchain 130

DZone

SEPTEMBER 26, 2023

Since you need to access multiple components (servers, databases, network infrastructure, applications, etc.) We'll talk about best practices and habits and use some of the Log Analytics tools from Sumo Logic as examples. Let’s blast off and turn that cosmic trash into treasure!

Best Practices 255

Best Practices Analytics Network Infrastructure 255

Dynatrace

JANUARY 19, 2020

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 218

Monitoring Best Practices Infrastructure Servers 218

SQL Performance

AUGUST 14, 2019

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In my examples I'll use a sample database called TSQLV5. Previously I covered determinism , subqueries and joins.

Best Practices 108

Best Practices Servers Database Azure 108

Dynatrace

MAY 31, 2019

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 203

Monitoring Best Practices Programming Infrastructure 203

Dynatrace

MAY 28, 2020

If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers.

Engineering 270

Engineering Performance Metrics Best Practices 270

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 132

Availability Database Open Source Hardware 132

Dynatrace

JANUARY 31, 2024

SAP Basis teams have established best practices for managing their SAP systems. Teams benefit from a boost in aligning SAP operations practices with the operation of all surrounding systems that SAP depends on and those that depend on SAP. SAP HANA server infrastructure monitored with OneAgent.

Java 246

Java Analytics Best Practices Monitoring 246

SQL Performance

SEPTEMBER 12, 2019

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. In the meanwhile, there's a best practice that can help you avoid the bug.

Best Practices 103

Best Practices C++ Code Design 103

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Dynatrace

AUGUST 8, 2024

Possible scenarios A Distributed Denial of Service (DDoS) attack overwhelms servers with traffic, making a website or service unavailable. Employee training in cybersecurity best practices and maintaining up-to-date software and systems are also crucial. Human error Human error remains one of the leading causes of tech outages.

Software 290

Software Software Infrastructure Network 290

Dynatrace

MAY 19, 2022

To ensure their global service levels, they fully embraced the best practices outlined in Google’s SRE handbook , called the “Four Golden Signals,” to standardize what they show on their SRE dashboards. This refers to the load on your network and servers. The “Four Golden Signals” include the following: Latency. Saturation.

Automotive 290

Automotive Latency Architecture Azure 290

Dynatrace

SEPTEMBER 30, 2021

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. Cloud providers manage all the underlying hardware, server maintenance, and security practices, allowing you to spend less on expensive IT operations and maintenance. Reduced cost.

Cloud 241

Cloud Traffic Best Practices Strategy 241

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Impacting Server-Side Requests: Dynatrace allows you to drill into your server-side requests to understand why your business logic is executing slow or fails. Too much data requested from a database, e.g. Request all and filter in memory.

Cache 214

Cache Database Architecture Government 214

Percona

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance.

Best Practices 98

Best Practices Traffic Database Servers 98

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 128

Servers Best Practices Database Open Source 128

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 81

Best Practices Storage Strategy Database 81

Dynatrace

JULY 29, 2020

Rich Lane : In the digital age where so much of an enterprise’s revenue and customer engagement comes from digital interaction, IT needs to shift from measuring success in terms of server up-time or number of incidents to business outcomes (e.g. Did our latest marketing push achieve a greater number of sales conversions?

Best Practices 263

Best Practices Mobile Architecture Monitoring 263

The Netflix TechBlog

DECEMBER 11, 2020

For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database. We engaged with them to determine graph schema best practices to best suit the needs of Studio Engineering. The schema registry is developed in-house, also in Kotlin.

Architecture 255

Architecture Best Practices Engineering Open Source 255

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For this, best practices would be to segregate commands from data, use parameterized SQL queries, and eliminate the interpreter by using a safe application program interface, if possible.

Open Source 246

Open Source Artificial Intelligence Internet Internet 246

SQL Performance

JUNE 14, 2019

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. In my examples I’ll use a sample database called TSQLV5. Previously I covered determinism and subqueries.

Best Practices 93

Best Practices C++ Database Processing 93

DZone

OCTOBER 14, 2020

call to database or service) with artificial functionality that has the same return type. There are different approaches to this practice. Here, I explain best practices and why you better avoid mocking practice in order to have real code quality. Mocking Test Methodology.

Testing 191

Testing Best Practices Database Code 191

Dynatrace

OCTOBER 5, 2020

The same default behavior is also true for Dynatrace when installing the OneAgent on your servers that host your ASP.NET services. Once you have Dynatrace capturing data from your apps and services simple follow these best practices shared by our friends from triscon so you can get even more out of Dynatrace.

Performance 207

Performance Best Practices Architecture Monitoring 207

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. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

JULY 7, 2022

Microservices development is intrinsically optimized for continuous integration/continuous deployment ( CI/CD ) processes that apply agile development best practices for the rapid delivery of reliable code. Additionally, typical SOA models use larger relational databases. They also make it easier to manage containers at scale.

Architecture 246

Architecture Serverless Azure Programming 246

Dynatrace

NOVEMBER 23, 2020

After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes. Traces represent causally related distributed events on a distributed system, showing, for example, how a request flows from the user to the database.

Virtualization 237

Virtualization Infrastructure Monitoring Cloud 237

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. minutes of downtime in one year.

Azure 187

Azure AWS Database Latency 187

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 107

Database Hardware Open Source Strategy 107

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 111

Open Source Database Hardware Strategy 111

Dynatrace

APRIL 16, 2019

Many of our customers also run their.NET, ASP.NET,NET Core, SQL Server, CRM, SharePoint … applications on AWS and have reached out to us in the past to ask about best practices around optimizing these workloads in order to run more efficiently and more cost effective. Are they receiving traffic? #3:

AWS 186

AWS Database Best Practices Traffic 186

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. you can now use an external VictoriaMetrics database for monitoring in PMM. Take a look.

Servers 109

Servers Monitoring Open Source Scalability 109

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

Dynatrace

SEPTEMBER 20, 2019

Within minutes you can download and deploy a single Dynatrace node, (or cluster of nodes) that contains all the key components needed to run Dynatrace (no requirement for separate databases). But once downloaded, the update process is as simple as uploading the update package to the Dynatrace server and the server will handle the rest!

Software 180

Software Software Government Logistics 180

SQL Performance

MAY 8, 2019

This article is the second in a series about T-SQL bugs, pitfalls and best practices. Since the reference to custid in the inner query is unqualified, SQL Server has to resolve which table the column is coming from. As for best practices that can help you avoid such bugs, there are two main ones. custid FROM dbo.

Best Practices 68

Best Practices C++ Code Servers 68