Operations | Monitoring | ITSM | DevOps | Cloud

redgate

Redgate Monitor Adds Support for Oracle Multitenant

Aug 29, 2025 By Ricky Eaton In Redgate
Redgate Monitor now gives you full visibility into activity across Oracle Multitenant environments. With metrics and alerts at both the Container Database (CDB) and Pluggable Database (PDB) level, you can quickly pinpoint performance issues and ensure compliance. With the introduction of Oracle multitenant architecture in Oracle 12c, many teams began consolidating databases into a single Container database (CDB). This helped them to optimize resource usage and simplify patching.
Read Post
Aiven

Using PostgreSQL Anonymizer to Generate Synthetic Data

Aug 29, 2025 By Jay Miller In Aiven
Set aside the data masking features of PostgreSQL Anonymizer. This plugin can save the day during development by simplifying your workflow and generating schema-accurate, privacy-compliant test data. In a previous post, we discussed using static and dynamic masking to anonymize data. I spent the last two weeks trying to write followups for the anonymization posts. It's time to confess... I'm an over-engineerer.
Read Post

NHibernate Tutorial: Database-First & Model-First Using Visual ORM Designer

Aug 29, 2025 By Devart In Devart
Learn how to create and configure an NHibernate model with Entity Developer — Devart’s powerful visual ORM designer for.NET. In this step-by-step tutorial, we’ll cover both Database-First and Model-First approaches, show how to update models, generate mappings and classes, and even produce SQL scripts directly from your model. Whether you’re using Visual Studio or working in VS Code, Entity Developer makes NHibernate development faster, easier, and more reliable.
View Video

dotConnect for SQLite: Fast .NET data access with ORM and encryption support

Aug 29, 2025 By Devart In Devart
Supercharge your.NET applications with dotConnect for SQLite — the high-performance data provider trusted by thousands of developers. Whether you're building lightweight apps or enterprise-scale solutions, dotConnect delivers secure, encrypted access to SQLite with seamless Visual Studio integration, powerful ADO.NET architecture, and full ORM support, including Entity Framework Core. Chapters: Try it free for 30 days and see why thousands of developers trust dotConnect for SQLite in mission-critical environments.
View Video
last9

What is Database Monitoring

Aug 28, 2025 By Anjali Udasi In Last9
Database monitoring transforms from a reactive troubleshooting exercise into a proactive optimization strategy when you have the right tools and approaches in place. This blog shares practical ways to choose monitoring solutions, set up observability for different database platforms, and design workflows that scale in modern distributed systems.
Read Post
devart

What is Dynamic SQL in SQL Server?

Aug 26, 2025 By Rosemary Asufi In Devart
Dynamic SQL in SQL Server is built for scenarios where queries can’t be fully defined in advance. It’s the method of choice when structure depends on user input, variable schemas, or runtime conditions, cases where static SQL falls short. However, without proper structure, this flexibility introduces security and maintenance challenges. To make it work at scale, you need a disciplined approach.
Read Post
devart

What is Database Change Management (DCM)?

Aug 22, 2025 By Victoria Lazarus In Devart
Database change management is the foundation for building a stable, secure, and high-performing application. In today’s fast-paced technological landscape, where agile and DevOps are the go-to for developing database application, rapid releases and continuous iteration are the norms. But with frequent deployments comes the risk of untracked database changes.
Read Post
VictoriaMetrics

Alerting Best Practices

Aug 22, 2025 By Roman Khavronenko In VictoriaMetrics
A firing alert is like someone ringing your doorbell - it demands your immediate attention, interrupting whatever else you’re doing. It requires focus and a quick response. But imagine trying to live in an apartment where the doorbell never stops ringing. You could put in earplugs to block the noise, but that only masks the problem - it doesn’t solve it. On the other hand, disconnecting the doorbell entirely isn’t a solution either.
Read Post
grafana

Grafana Mimir: 3 reasons to run the TSDB for Prometheus on bare metal

Aug 22, 2025 By Wilfried Roset In Grafana
Wilfried Roset is an engineering manager who leads an SRE team and he is a Grafana Champion. Wilfried currently works at OVHcloud where he focuses on prioritizing sustainability, resilience, and industrialization to guarantee customers satisfaction. Whether it’s for efficient resource allocation, flexibility, high availability, or scalability, it makes a lot of sense to run Grafana Mimir on Kubernetes—but it’s not the only way to deploy Mimir.
Read Post
devart

Vector Database Explained: Architecture, Use Cases & Examples

Aug 21, 2025 By Victoria Lazarus In Devart
Vector databases are rapidly becoming the cornerstone of modern AI applications—and for good reasons. If you are very familiar with AI technologies like ChatGPT, you have already seen what vectors can do. When you ask ChatGPT a question, such as, “What’s the weather like today?” to provide an accurate answer, the AI would first convert your question into a vector, which implies a series of numbers that capture the intent and context of your sentence. The cool part?
Read Post

Simple Talks Podcast | S3, Episode 1 - Coffee chat with Mike Bowers

Aug 21, 2025 By Redgate Software In Redgate
To kick off Season 3, host Steve Jones is joined by Mike Bowers, Chief Architect at data technology company FairCom. The conversation includes an overview of Mike’s background, the work he does at FairCom, plenty of SQL talk, and advice on getting into the industry.
View Video

dotConnect for PostgreSQL: Advanced .NET Data Access with Full ORM Support

Aug 21, 2025 By Devart In Devart
Supercharge your.NET applications with dotConnect for PostgreSQL — a fast, feature-rich ADO.NET data provider tailored for modern PostgreSQL development. In this video, explore how dotConnect for PostgreSQL simplifies data connectivity, enhances developer workflows, and empowers scalable, high-performance applications within the.NET ecosystem. What you’ll see: From SaaS platforms to data-driven enterprise systems, dotConnect for PostgreSQL offers the speed, reliability, and flexibility your applications need.
View Video
VictoriaMetrics

vmanomaly Deep Dive: Smarter Alerting with AI (Tech Talk Companion)

Aug 20, 2025 By Marc Sherwood In VictoriaMetrics
I was thrilled to host our latest tech talk, where we got to do a deep dive into vmanomaly with the best possible guests: Fred Navruzov, the actual team lead for the product, and Co-Host, Matthias Palmersheim. We covered a ton of ground, from high-level concepts to the nitty-gritty of configuration. For everyone who couldn’t make it, I wanted to share my personal recap of the most important technical takeaways from our conversation.
Read Post
influxdata

The Real Cost of Choosing the Wrong Database

Aug 20, 2025 By Allyson Boate In InfluxData
Data is more than a record of what happened—it shapes what happens next. Across industries, connected devices continuously stream time-stamped data that reflects the current state of machines, environments, and systems. This steady flow gives organizations a live view of operations and the ability to catch issues early, adjust quickly, and operate more efficiently. However, capturing data alone does not create value.
Read Post
redgate

Built for simplicity and scalability: why organizations choose Redgate Flyway

Aug 18, 2025 By Claire Matthews In Redgate
Redgate Flyway is renowned for its low-friction, SQL-first approach. Our customer stories share the wins seen in organizations worldwide for Redgate Flyway. And when it comes to community endorsement for Flyway OSS, the GitHub and Docker statistics prove it, with 9k+ GitHub stars and 50M Docker downloads advocating for its appreciation.
Read Post
metricfire

Visualize Logs Alongside Metrics: A Complete Guide for Monitoring Slow MySQL Queries

Aug 15, 2025 By Benjamin Pitts In MetricFire
When a service slows down, metrics will tell you that it’s happening but logs tell you why. For MySQL, slow queries can be a silent performance killer, gradually chewing through resources until users start complaining. By enabling MySQL’s slow query log and forwarding it to Loki (via Promtail), you can visualize query-level details right alongside your metrics on Grafana dashboards. This makes it easy to correlate what is slow (metrics) with what is causing the slowdown (logs).
Read Post
devart

What Is ANSI SQL and Why You Should Use It

Aug 11, 2025 By Dereck Mushingairi In Devart
Every major RDBMS insists it’s SQL-compliant, but under the hood, proprietary quirks break portability and slow down development. That’s where ANSI SQL steps in—not just as a standard, but as a survival strategy for teams juggling multiple platforms. By adopting ANSI SQL, you’re not just writing cleaner, more portable code—you’re unlocking freedom.
Read Post
grafana

How to use SQL to learn more about your Grafana usage

Aug 8, 2025 By Wilfried Roset In Grafana
Wilfried Roset is an engineering manager who leads an SRE team, and he is also a Grafana Champion. Wilfried currently works at OVHcloud, where he focuses on prioritizing sustainability, resilience, and industrialization to guarantee customers satisfaction. Grafana needs a database to store all its objects, such as users, dashboards, or even data sources. Each time a user creates a dashboard, it results in a new row created in the database.
Read Post
VictoriaMetrics

VictoriaLogs Practical Ingestion Guide for Message, Time and Streams

Aug 8, 2025 By Phuong Le In VictoriaMetrics
VictoriaLogs Practical Ingestion Guide for Message, Time and Streams This VictoriaLogs article serves as a quick way to grasp the core concepts of VictoriaLogs. It covers only the most important information from the documentation, along with common cases identified after troubleshooting many real-world scenarios. If you’re just getting started with VictoriaLogs, this is a great place to begin. For more in-depth or advanced details, refer to the official documentation.
Read Post
icinga

Icinga DB Web Automation

Aug 7, 2025 By Sukhwinder Dhillon In Icinga
Icinga DB Web Automation allows you to automate monitoring tasks and integrate them directly into your systems and workflows. It is possible to issue command actions without a browser. To do so, a form needs to be submitted by a tool such as cUrl. Every request you send follows the same permission rules and access restrictions defined in the web interface, so security and user roles still apply. Want to target specific hosts or services? Simply add filter parameters to the URL.
Read Post
redgate

Flyway and Optimized Partition Management for Oracle Databases

Aug 7, 2025 By Kellyn Gorman In Redgate
I’m pleased to announce that Flyway continues to improve its support for Oracle databases with every release, focusing on performance, reliability, and developer efficiency. The most recent updates to Flyway Desktop and Flyway CLI specifically target a long-standing challenge for Oracle users: unnecessary table rebuilds when migrating to partitions or when managing partitions.
Read Post
redgate

A local fix just spreads the problem

Aug 7, 2025 By Peter Kruis In Redgate
“You fixed a bug in QA — great! But did that fix go into version control and get tested and deployed everywhere? If not, you just created drift, and more problems down the line.” Peter Kruis, Microsoft SQL Engineer at Monin Fixing a bug in the environment where it appears feels like progress, but without a proper process, it creates fragility everywhere else.
Read Post
redgate

Break it early to ship it safely

Aug 7, 2025 By Naga Santhosh Reddy Vootukuri In Redgate
“We want developers to break things – just not for the customers. If all our tests are green, I get nervous that we’re not testing deep enough.” Naga Santhosh Reddy Vootukuri, Principal Software Eng. Manager, Microsoft Azure SQL Naga Santhosh, Sunny to most, leads a team that ships changes to Azure SQL databases worldwide. Those deployments must be fast, frequent, and invisible to customers. That kind of reliability doesn’t come from playing it safe during development.
Read Post
last9

PostgreSQL Performance: Faster Queries and Better Throughput

Aug 5, 2025 By Faiz Shaikh In Last9
A PostgreSQL setup that performed well with 10,000 users starts to show strain at 100,000. Queries that once returned in under 50ms now take over 2 seconds. The connection pool regularly hits its limit during peak usage, leading to timeouts and degraded performance. This blog focuses on practical ways to reduce query latency by 50–80% and increase throughput for high-concurrency environments.
Read Post
squared up

Getting started with MongoDB dashboards

Aug 5, 2025 By Blog In Squared Up
MongoDB is a popular NoSQL database used by many modern web applications. Once your web application is up and running, you might find you need to monitor the application data for operational purposes. For example, you may need to report on user sign-ups, or monitor for problems like invalid data. SquaredUp is an easy-to-use dashboard that plugs directly into your MongoDB database to visualize and monitor your data.
Read Post
devart

Top Tools to Connect Your Analytics and Data Visualization Platforms with Zoho CRM

Aug 4, 2025 By Victoria Lazarus In Devart
Zoho CRM integration is a game-changer for businesses that want to convert raw customer data into powerful, crystal-clear insights. In an era where every click, call, and customer interaction generates valuable data, the ability to instantly connect your CRM with analytics and data visualization platforms can make the difference between thriving and merely surviving. Imagine having a live, visual pulse on your sales pipeline, customer behaviors, and revenue forecast all in one place.
Read Post
devart

SQL Server Transaction Log Analysis

Aug 4, 2025 By Julia Lutsenko In Devart
Transaction logs play a crucial role in database management, especially in SQL Server databases. These logs meticulously record every transaction and the corresponding changes made to the database. Such detailed tracking is indispensable for identifying issues and restoring the database to a specific state and time if any failures occur. In SQL Server, every database includes a transaction log, a feature that is always enabled and cannot be turned off.
Read Post

Explore the NiCE MariaDB Management Pack in Action2025Q3

Aug 1, 2025 By NiCE IT Management Solutions In NiCE IT Mgmt
If you’re running critical MariaDB workloads and need reliable, performance-focused monitoring, this session is for you. You’ll get a live walkthrough of the Management Pack, learn how it integrates seamlessly into SCOM, and explore real-world use cases to improve your database monitoring strategy.
View Video

Copyright © 2026 OpsMatters™. All rights reserved.