Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Compactor: A Hidden Engine of Database Performance

This article was originally published in InfoWorld and is reposted here with permission. The compactor handles critical post-ingestion and pre-query workloads in the background on a separate server, enabling low latency for data ingestion and high performance for queries. The demand for high volumes of data has increased the need for databases that can handle both data ingestion and querying with the lowest possible latency (aka high performance).

Redis Monitoring with OpenTelemetry and SigNoz

In this post, we will show you how to set up Redis monitoring with SigNoz - an open-source full-stack APM. SigNoz captures data using OpenTelemetry, which is becoming the world standard for instrumenting cloud-native applications. Apart from capturing metrics from your Redis server, you can also capture logs and traces with OpenTelemetry.

Monitor your AlwaysOn availability groups with Datadog Database Monitoring

SQL Server AlwaysOn availability groups provide database clusters that streamline automatic failovers and disaster recovery. With AlwaysOn clusters, you can leverage reliable, high-availability support for your services. However, AlwaysOn groups can be problematically complex, spread over servers and regions with multiple points of failure in each cluster. This makes it difficult to understand what’s happening in your groups at any given time and troubleshoot when issues occur.

How to Get the Current Date and Time in SQL

SQL databases have several functions that reduce the complexity of working with date and time. Using these functions and a date and time type column, you can depend on SQL for the logic to write and read data with date and time. In this post, you’ll learn how to use the SQL date and time functions to get the current date and time.

How DevOps is shaping Financial Services #1: The role of governance

In this series of blog posts, we speak with database professionals from Financial Services organizations around the world to better understand how DevOps is shaping the sector. On the way, we dig into key current factors including the rise of technology upstarts in fintech and insurtech, the speed of digital transformation and the ever-increasing threat of cyberattacks. First up, we speak with Hamish Watson, DevOps Alchemist and Managing Director at Morph IT Consulting.

The High Cost of Poor Database Performance (It's Not Just Monetary)

What is the cost of database performance for businesses today? The very shocking reality is most owners have absolutely no idea. In fact, I would even go so far as to say most business owners can’t even begin to understand everything this question might encompass.

Oracle Database monitoring: An administrator's guide

Oracle Database is known for its reliability, scalability, and outstanding performance. An enterprise-friendly feature catalogue makes it a go-to for companies that need data to be available across their disparate IT infrastructure. Large-scale enterprises relying on huge database systems like Oracle need to make sure that data transactions are hassle-free and demand is met with the resources available.

Deploy PostgreSQL services to multiple clouds and regions using Terraform

In this video, you will learn how to deploy PostgreSQL services across different cloud providers and across geographies using Aiven Terraform Provider. You will also learn the benefits of using termination protection functionality to prevent accidental deletion of your cloud resources.