Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Building dbRosetta Part 5: We Need an API

Because I don’t want to have to fight with our support team (they’re awesome, but busy) I decided that, initially, I’m going to host dbRosetta at ScaryDBA.com. I have full control of the web site, and I won’t be breaking Redgate Software entirely if I accidently do something silly. Before starting the process of developing our next prompt, or set of prompts, I discussed the project with CoPilot. We agreed to break the next part into two pieces.

DBA vs Developer Dynamics: Bridging the Gap with Database DevOps

Developer velocity and DBA caution are not opposing forces, they reflect two essential priorities that historically lacked a shared process. Database DevOps eliminates tension by introducing automated validation, approvals, and visibility that allow developers to move fast while DBAs safeguard performance and reliability. With platforms like Harness, database change becomes a collaborative workflow instead of a conflict, turning release cycles into a partnership built on trust and predictability.

AI-Driven Database Monitoring for Modern IT Teams | Site24x7

Databases power every business, but keeping them fast, reliable, and scalable is a daily challenge for IT teams. Discover how intelligent database monitoring helps you uncover performance bottlenecks, optimize queries, and maintain database health effortlessly. Whether you manage SQL or NoSQL systems, gain actionable insights across your infrastructure before issues affect your applications or users.

Use Database Monitoring in Splunk Observability Cloud to Identify and Resolve Slow Queries

In this video, I introduce Database Monitoring in Splunk Observability Cloud. I'll demonstrate how to spot and resolve slow queries by leveraging rich metrics and correlating database performance directly with traces in Splunk Observability Cloud APM. TOC.

Building dbRosetta Part 4: Automating a CI Database Build

Since I’m starting development with the dbRosetta database, and since I’m way more comfortable with databases than with code, I’m going to continue within the database sphere for a bit as we build out dbRosetta. My next step is to work with the AI to get a pipeline in place to take our database code and deploy it to Azure Flex Server.

Database DevOps vs. Database Migration Systems and Why You Need Both

Database DevOps and migration systems solve different parts of the same workflow - one enables collaboration, governance, and automation while the other delivers structured, versioned schema execution. Using both eliminates release friction by aligning developers, DBAs, and CI/CD pipelines with full auditability and rollback safety. Harness converges these capabilities to make database changes seamless, compliant, and production-ready by design. Every developer knows this story.

Different ways to Search Text in PostgreSQL

When it comes to text search, PostgreSQL offers a surprisingly rich set of tools. Initially, text search capabilities were quite basic, often relying on the LIKE operator. This is inefficient for large amounts of text and lacks the nuance that comes with language. A major breakthrough came with the introduction of the built-in tsquery and tsvector data types, along with the associated functions, as part of PostgreSQL's core distribution. But tsquery is not the only option.

Our latest updates across the VictoriaMetrics Observability ecosystem

We’re excited to announce a set of updates across the entire VictoriaMetrics open source products suite — including VictoriaMetrics, VictoriaLogs, VictoriaTraces, the VictoriaMetrics Kubernetes Operator. These improvements bring better performance, stronger security, enhanced metadata visibility, and a smoother experience when running observability at scale.

Replacing cron jobs and dbt pipelines with ClickHouse Refreshable Materialized Views

For ClickHouse to achieve the speed it's known for, it has historically relied on a trigger-based and incremental architecture for materialized views. This architecture is known to be very efficient but lacks flexibility, such as when working with data that needs to be backfilled rather than append-only.