Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

lumigo

From Chaos to Clarity Troubleshooting Postgres

Feb 21, 2024 By DeveloperSteve In Lumigo
I have always had a special fondness for Postgres, particularly captivated by its JSONB capabilities, which is at the core of what I love as it stands as a testament to its adaptability. This functionality exemplifies Postgres’s ability to adapt to modern apps’ rapidly changing needs to support structured and unstructured data to coexist seamlessly within the same database environment. The capabilities of PostgreSQL are not limited to its ability to manage relational and non-relational data.
Read Post

The Data Table Webcast Series with Kevin Kline

Feb 21, 2024 By SolarWinds In SolarWinds
The Data Table is a webcast series tailored for data and database professionals like you, hosted by SolarWinds own tech evangelist, Kevin Kline. Each session gives database professionals a seat at the table to discuss the latest news, best practices, and strategies in the Data and Analytics (D&A) space. It's not just about theory, it's an opportunity to connect with and learn from Kevin and other IT industry experts about the topics IT pros really care about.
View Video
influxdata

How Time Series Databases and Data Lakes Work Together

Feb 19, 2024 By Jason Myers In InfluxData
In the fast-paced world of software engineering, efficient data management is a cornerstone of success. Imagine you’re working with streams of data that not only require rapid analysis but also need to store that data for long-term insights. This is where the powerful duo of time series databases (TSDBs) and data lakes can help.
Read Post

How to speed up MySQL and PostgreSQL queries for FREE

Feb 19, 2024 By Aiven In Aiven
How can I speed up a SQL query? This video showcases how to optimize a SQL query on MySQL or PostgreSQL for free using AI and a tool called EverSQL by Aiven. In the example shown, the query performance on a MySQL database went from 20 seconds to 0.5 seconds only by pasting the SQL and additional metadata in the EverSQL by Aiven UI and applying the indexes and SQL rewrite suggestions. Check out these resources to learn more:(links to any tools or resources you used in the video, our docs/trial if appropriate)
View Video
pandora fms

NOSQL vs SQL. Key differences and when to choose each

Feb 19, 2024 By Ahinóam Rodríguez In Pandora FMS
Until recently, the default model for application development was SQL. However, in recent years NoSQL has become a popular alternative. The wide variety of data that is stored today and the workload that servers must support force developers to consider other more flexible and scalable options. NoSQL databases provide agile development and ease of adapting to changes. Even so, they cannot be considered as a replacement for SQL nor are they the most successful choice for all types of projects.
Read Post
site24x7

Navigate memory management challenges in MongoDB with Site24x7

Feb 15, 2024 By Sinjan Ballav In Site24x7
Effective memory management is crucial for optimal MongoDB performance and helps ensure seamless database operations and user experience. Allocating enough memory lets the database store frequently used data and indexes in RAM and cut down on disk I/O operations. This boosts query response times and system responsiveness. Poor memory management can cause delays in retrieving data from disk, leading to performance degradation.
Read Post
lumigo

Debugging and Decoding MongoDB with OpenTelemetry

Feb 14, 2024 By DeveloperSteve In Lumigo
MongoDB’s flexibility and document-oriented nature have always stood out to me as its most compelling features, setting it apart from the strict schema constraints of traditional relational databases. This adaptability is a boon for application development, allowing for more dynamic data interactions that mirror real-world information complexities and freeing table schemas’ constraints.
Read Post

Cloud Migration Challenges: Overcoming Obstacles - TJay Belt | Redgate

Feb 14, 2024 By Redgate In Redgate
TJay Belt, Director of Data at Nerd United, shares his thoughts on the obstacles you face when migrating to the cloud. Cloud adoption has been steadily on the rise for a number of years, driven by benefits such as scalability, accessibility and flexibility, security and cost.
View Video

Copyright © 2024 OpsMatters™. All rights reserved.