article thumbnail

Stop Being Afraid of Databases

DZone

Ensuring database reliability can be difficult. We want developers to be able to work efficiently while taking ownership of their databases. Achieving this becomes much simpler when robust database observability is in place. Our goal is to speed up development and minimize rollbacks. Lets explore how.

Database 223
article thumbnail

Optimizing SQL Server Performance With AI: Automating Query Optimization and Predictive Maintenance

DZone

SQL Server is a powerful relational database management system (RDBMS), but as datasets grow in size and complexity, optimizing their performance becomes critical. Leveraging AI can revolutionize query optimization and predictive maintenance, ensuring the database remains efficient, secure, and responsive.

Servers 278
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Optimizing Performance in Azure Cosmos DB: Best Practices and Tips

DZone

When we are working with a database, optimization is crucial and key in terms of application performance and efficiency. Below are some of the best practices with coding examples to optimize performance in Azure Cosmos DB. Below are some of the best practices with coding examples to optimize performance in Azure Cosmos DB.

article thumbnail

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

Scalegrid

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Polyglot Persistence Trends : Number of Databases Used & Top Combinations.

article thumbnail

PostgreSQL 17: A Major Step Forward in Performance, Logical Replication, and More

DZone

PostgreSQL has grown remarkably over the years, and with each major release, it has become a more robust, reliable, and responsive database for both mission-critical and non-mission-critical enterprise applications.

article thumbnail

Understanding the Database Connection Pool (DBCP) Properties

DZone

Recently, I faced an issue related to a very high load on the database layer. The database was having too many connections in parallel. I had to review my application’s database connection pool (DBCP) properties very closely. However, I wasn’t able to immediately map each property to the scenario where it will be used.

Database 245
article thumbnail

Intelligent observability for Oracle and SQL databases

Dynatrace

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