Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Why we generate & collect logs: About the usability & cost of modern logging systems

Logs and log management have been around far longer than monitoring and it is easy to forget just how useful and essential they can be for modern observability. Most of you will know us for VictoriaMetrics, our open source time series database and monitoring solution. Metrics are our “thing”; but as engineers, we’ve had our fair share of frustrations in the past caused by modern logging systems that tend to create further complexity, rather than removing it.

What is Graphite?

What is Graphite? Simply put, Graphite is an open-source enterprise-ready time-series database. So what is a time-series database? Well, a time series is a series of data points indexed (or listed or graphed) in time order. Time Series databases have excellent benefits over traditional databases in terms of high performance, higher writes, improved scalability, better reliability, and many more.

Why monitoring server estates from a single pane of glass is key

The last few years have seen a big change in the size, make-up, and nature of database estates. Data is growing both in volume and complexity, it is now normal to have workloads as well as data in multiple public clouds, and organizations are increasingly using different kinds of databases for different use cases.

Top PostgreSQL Monitoring Tools in 2023

Armed with the right PostgreSQL monitoring tools, database administrators and developers can identify potential bottlenecks, troubleshoot problems and make informed decisions to optimize their database environments. Monitoring PostgreSQL databases provides invaluable insight into their performance, health and overall efficiency.

Getting Started with SQL Queries

Welcome to our tutorial on executing basic queries on pgAdmin, the intuitive GUI tool for managing PostgreSQL databases. In this video, we'll cover essential SQL commands such as SELECT, UPDATE, DELETE, and INSERT, and demonstrate how to utilize them effectively on pgAdmin. Whether you're a beginner or looking to refresh your SQL skills, this tutorial provides valuable insights and practical examples. Additionally, we'll share helpful resources like SQL cheatsheets and codecademy's SQL commands article to further enhance your understanding.

How Worldline uses Grafana Enterprise and Grafana Mimir to run its platform-as-a-service at a global scale

According to the World Bank, two-thirds of adults around the globe currently make or receive digital payments. Businesses have come to expect quick, reliable processing, and one company at the forefront of that is Worldline. The global payment service provider (PSP) is a leading payment processor and payment provider in Europe, with about 3.4 billion e-commerce transactions made in 2022.

Relational Databases: Exploring Indexes and Transactions

Indexes serve as the key to unlocking the immense potential of relational databases, enabling swift and optimized data access. They act as a roadmap, allowing the database engine to locate specific data quickly, ultimately enhancing query performance. Understanding the nuances of indexes and employing the appropriate indexing techniques can significantly impact the efficiency of a database system.

Managing the challenge of migrating to the cloud

Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud. As many have discovered, it’s not simply a case of ‘lift and shift’.