DZone

NOVEMBER 21, 2023

With the help of exporters, Prometheus can provide insightful data and effectively monitor a variety of services, including databases, web servers, and custom-made applications. Paired with Prometheus exporters, the tool can adapt to a variety of surroundings, which is one of its strongest points.

Best Practices 291

Best Practices Scalability Monitoring Database 291

Dynatrace

MARCH 27, 2024

As teams and their structure and metadata are often maintained in a dedicated database, such as Microsoft Entra ID (formerly Azure Active Directory) or ServiceNow. A dedicated workflow allows automatic synchronization of the database information with Dynatrace and keeps the ownership team information up-to-date.

Best Practices 263

Best Practices Azure Database Code 263

Percona

MAY 9, 2024

Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […] Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records?

Best Practices 133

Best Practices Database Systems 133

Percona

MARCH 25, 2024

Anyone working with databases knows that data is the driving force behind every online activity, and data security is always a top concern.

Best Practices 122

Best Practices Database 122

Percona

APRIL 22, 2024

When data is everything, the sophistication of cybersecurity threats casts a shadow over the world of data security, including for those using PostgreSQL as their database of choice.

Best Practices 114

Best Practices Database 114

Scalegrid

FEBRUARY 1, 2024

Dive in to uncover the essentials of different backup types, command-line tools, and strategic practices for robust data protection. MySQL is a popular open-source relational database management system for online applications and data warehousing. Having MySQL backups for your database can speed up and simplify the recovery process.

Best Practices 130

Best Practices Storage Strategy Database 130

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. </p>

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

Percona

MAY 6, 2024

MongoDB offers powerful features and scalability, but like any database system, it has security challenges that must be addressed to protect sensitive data as well as comply with regulatory standards like GDPR, HIPAA, PCI DSS, and AM/ATF.

Best Practices 103

Best Practices Database Scalability Systems 103

Percona

NOVEMBER 2, 2023

MongoDB is a dynamic database system continually evolving to deliver optimized performance, robust security, and limitless scalability. Our new eBook, “ From Planning to Performance: MongoDB Upgrade Best Practices ,” guides you through the entire process to ensure your database’s long-term success.

Best Practices 111

Best Practices Hardware Tuning Scalability 111

Dynatrace

JANUARY 11, 2023

Database monitoring. This ensures the database queries are performant, while also identifying host problems. For example, uptime detection can identify database instability and help to improve mean time to restoration. Best practices to consider. Website monitoring. Cloud storage monitoring.

Cloud 295

Cloud Monitoring Best Practices Infrastructure 295

DZone

MAY 23, 2019

How do you tune the Snowflake data warehouse when there are no indexes, and few options available to tune the database itself? This article summarizes the top five best practices to maximize query performance. Snowflake was designed for simplicity, with few performance tuning options.

Best Practices 100

Best Practices Tuning Performance Database 100

Percona

JUNE 26, 2024

Is your MySQL database running at its best? One way to do that is through performance monitoring, an essential practice for identifying bottlenecks, maintaining optimal speed, and guaranteeing a seamless user experience. While MySQL is known for its reliability and ease of use, ensuring top-notch performance is crucial.

Best Practices 117

Best Practices Monitoring Performance Speed 117

DZone

JULY 6, 2023

Azure Cosmos DB is a highly scalable and globally distributed NoSQL database service offered by Microsoft. In this blog post, we will explore best practices and tips for optimizing performance in Azure Cosmos DB. Indexing Strategy As with the other databases, indexing is the first go-to option to improve query performance.

Azure 264

Azure Performance Best Practices Strategy 264

Percona

SEPTEMBER 23, 2024

When it comes to MySQL databases, performance is everything. Database indexing plays a significant role in this by providing powerful tools to optimize operations in MySQL. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial.

Best Practices 126

Best Practices Database Efficiency Performance 126

Software Testing Help

FEBRUARY 10, 2021

Learn what is Database Security and related concepts like security threats, best practices to follow, testing types, techniques, testing process, etc: In this tutorial, we will explore what is database. Read more What Is Database Security Testing – Complete Guide.

Database 124

Database Testing Best Practices Software 124

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

SQL Shack

DECEMBER 30, 2022

In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database.

Best Practices 92

Best Practices Database Efficiency Performance 92

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. At any rate, make sure to remember the best practice here!

Best Practices 108

Best Practices Servers Database Azure 108

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

Percona

JUNE 4, 2024

MongoDB’s flexibility and speed make it a popular database choice, but as your data grows, managing and querying massive datasets can become challenging. This is where partitioning, also known as sharding, comes to the rescue.Partitioning strategically divides your data collection into smaller, more manageable chunks.

Best Practices 107

Best Practices Scalability Performance Speed 107

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

The Netflix TechBlog

DECEMBER 3, 2022

See example below: - template: id: wap type: wap tables: - ${CATALOG}/${DATABASE}/${TABLE} write_jobs: - job: id: write type: Spark spark: script: $S3{./src/sparksql_write.sql} Running code against a production database can be slow, especially with the overhead required for distributed data processing systems like Apache Spark.

Best Practices 361

Best Practices Code Testing Data Engineering 361

Dynatrace

JANUARY 19, 2020

Collected metrics are analyzed in Dynatrace, using the SAP expert community’s established best-practice advice on ABAP platform health indicators, including response time breakdowns of the response times between ABAP-specific application server activities, tasks, and database interaction.

Monitoring 218

Monitoring Best Practices Infrastructure Servers 218

Percona

NOVEMBER 13, 2023

To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End of Life (EOL) – it’s crucial to upgrade your database systems from time to time. One of the most compelling reasons to choose a professional service is the reduced risk.

Database 111

Database Open Source Best Practices Strategy 111

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

Percona

APRIL 5, 2024

PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for businesses looking to upgrade or switch their database infrastructure. It is so […]

Best Practices 81

Best Practices Open Source Scalability Database 81

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

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

JULY 22, 2024

Metrics are typically aggregated and stored in time series databases for monitoring and alerting purposes. It evolves continuously through contributions from a vibrant community and support from major tech companies, which ensures that it stays aligned with the latest industry standards, technological advancements, and best practices.

Latency 264

Latency Best Practices Metrics Open Source 264

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 C++ Tuning Database 244

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. Best practices for a successful cloud migration. Migrate databases intelligently. But what does it take to migrate your existing applications to the cloud? What is cloud migration?

Cloud 241

Cloud Traffic Best Practices Strategy 241

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. What is the Recovery Time Objective? How do you know the backup succeeded?

Best Practices 81

Best Practices Storage Strategy Database 81

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

Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 111

Open Source Database Best Practices Strategy 111

Dynatrace

SEPTEMBER 30, 2021

It also ensures your team shares common fluency in cloud best practices, which improves collaboration and helps your company achieve a higher standard of performance. This certification is perfect for anyone who needs to learn cloud fundamentals and best practices. Cloud practitioner. Data analytics.

AWS 246

AWS Best Practices Cloud Analytics 246

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. Please note – there is no need to restart your database servers. If your apps are deployed in a PaaS Platform, e.g:

Engineering 270

Engineering Performance Metrics Best Practices 270

Dynatrace

MAY 31, 2019

Collected metrics are analyzed in Dynatrace, using the SAP expert community’s established best-practice advice on ABAP platform health indicators, including response time breakdowns of the response times between ABAP-specific application server activities, tasks, and database interaction.

Monitoring 203

Monitoring Best Practices Programming Infrastructure 203