Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Connecting PostgreSQL to pgAdmin

In this tutorial, we'll guide you through the process of connecting PostgreSQL to pgAdmin, a popular GUI tool for managing PostgreSQL databases. Whether you're a beginner or an experienced user, this video will provide you with step-by-step instructions on establishing a seamless connection between PostgreSQL and pgAdmin. Additionally, we'll showcase how Aiven's PostgreSQL service seamlessly integrates with pgAdmin, enabling you to efficiently administer your database.

How to visualize time series from SQL databases with Grafana

Relational databases like MySQL, PostgreSQL, Oracle, and others have a wealth of time series data locked inside of them. Often this data can be used to enhance observability dashboards, or keep track of important application factors, like how many users have signed up for a service. In this article, we’re going to show you how to visualize any time series from any SQL database in Grafana using the time series visualization.

Breaking the memory barrier: How Grafana Mimir's store-gateway overcame out-of-memory errors

Grafana Mimir is an open source distributed time series database. Publicly launched in March 2022, Mimir has been designed for storing and querying metrics at any scale. Highly available, highly performant, and cost-effective, Mimir is the underlying system powering Grafana Cloud Metrics, and it’s used by a growing open source community that includes individual users, small start-up companies, and large enterprises like OVHcloud.

Monitoring Microsoft SQL Server login audit events in Graylog

One of the most important events you should be monitoring on your network is failed and successful logon events. What comes to most people’s minds when they think of authentication auditing is OS level login events, but you should be logging all authentication events regardless of application or platform. Not only should we monitor these events across our network, but we should also normalize this data so that we can correlate events between these platforms.

7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide

Are you looking to modernize and migrate your data but have questions about the complex organizational challenges? We recently hosted the webinar: Overcoming Organizational Challenges in Data Modernization and Cloud Migration: A Guide for Senior IT Leaders.

How to get the best of lexical and AI-powered search with Elastic's vector database

Maybe you came across the term “vector database” and are wondering whether it’s the new kid on the block of data retrieval systems. Maybe you are confused by conflicting claims about vector databases. The truth is, the approach used by vector databases has been around for a few years.

Getting Started with PostgreSQL: Setup Postgres Service

Welcome to our introductory video where we focus on setting up the PostgreSQL service on Aiven. In this tutorial, we'll guide you through the initial steps of creating and configuring your PostgreSQL database on the Aiven platform. While this video primarily covers the setup process, we have exciting plans for future videos where we'll dive into connecting with a client and exploring advanced functionalities. Stay tuned for upcoming episodes that will help you make the most out of PostgreSQL on Aiven. Subscribe now and join us on this journey as we unlock the full potential of PostgreSQL in conjunction with Aiven's managed services!

Graphite Metrics Delay: Why it Happens and What to Do

To understand why Graphite metrics delay occurs, we must first know what Graphite is. Graphite is an open-source tool used to track the performance of websites, applications, and network servers. It makes it simple to monitor, store, retrieve, and visualize numeric time-series data. While Graphite does make it easier to render graphs on-demand, the struggle of dealing with large amounts of data with minimum delay is real.

Database Sharding: What is it, and How it Works?

Today’s world runs on data. We are constantly improving our solutions thanks to the plethora of data available to us in the public domain. Our society has seen a behavioral change when it comes to formulating remedies. We are increasingly adopting data-driven decisions, and rightly so. Now, talking about this whole data logic, where do you think this enormous amount of data gets stored? Well, the answer is a database!