Operations | Monitoring | ITSM | DevOps | Cloud

Redgate Monitor now surfaces two common SQL Server query issues that usually take manual work to uncover: cancelled or aborted queries and high memory-grant queries. You can now see both in the Query Executions view for each SQL Server instance, directly alongside server activity and alerts, so you can diagnose the cause much faster. Recently, Redgate Monitor introduced the Query Executions feature for SQL Server instances, using Extended Events to capture execution details for individual queries.

Do you like working with time in your code? If yes, you’re likely one of the lucky ones who are blissfully unaware of how deep the rabbit hole goes. If you don’t like it, I have good news for you! Postgres can make working with time more enjoyable! The newly released temporal constraints let you easily maintain referential integrity across temporal relationships. That might seem simple, but it's kind of a big deal. Let’s explore it through an example.

Redgate Test Data Manager’s November’s release brings advanced table configuration for large databases and the ability to save connection strings. Two features that make setting up subsets and managing database connections smoother, easier, and faster.

With increasing security threats and stringent compliance requirements, database code quality isn’t just a best practice; it’s a business imperative. Yet many organizations struggle to enforce their database development standards consistently across teams, leading to security vulnerabilities, potential data loss, and lengthy review cycles that slow down software delivery.

Harness Database DevOps now supports CockroachDB, bringing CI/CD automation to distributed SQL databases. Teams can manage schema changes through Git-driven workflows for consistency, traceability, and rollback safety. This integration simplifies multi-environment deployments, reduces human error, and accelerates database delivery.

There’s growing unease in the database world regarding delivering at speed, raising the question – just how do we keep up with the pace of change without losing control of the things that matter most? AI is rapidly transforming the mechanics of how code is written, reviewed, and optimized which in-turn, increases the risk of destabilization.

In 2025, the database ecosystem is more diverse and interconnected than ever before. From AI-assisted natural language queries that analyze your data to open table formats that make it easy to bridge systems, data infrastructure is moving towards openness, intelligence, and composability. Modern databases are no longer isolated systems; they are part of a broader ecosystem where interoperability is as important as performance.

Generated columns have existed in PostgreSQL since version 12. The idea was to allow people to make calculations based on other columns in the table and store them. It makes your life easier by ensuring data accuracy and preventing unauthorized manual modifications. But why, after 6 versions, is PostgreSQL making generated columns virtual and also making this new way the default? This is an example of the types of questions we had when exploring and playing around with this new feature.

The latest release of Redgate Monitor visualizes Oracle wait classes and events across single-instance, multitenant (CDB/PDB), and Data Guard environments. It gives DBAs a clear, high-level view of where database time is spent and makes diagnosing and resolving performance issues in Oracle much simpler.

Are you currently preparing for a technical role involving databases? MySQL interview questions and answers are a must-know. MySQL is one of the most popular relational database management systems, powering everything from small web applications to enterprise-level solutions. Whether you are looking to work as a database developer, data analyst, DBA, or in a related position, a solid understanding of MySQL is crucial.

Testing database-driven applications is notoriously painful. If your app depends on MySQL, you’ve probably spent hours setting up local databases, running migrations, loading data, and then cleaning everything up just to rerun your tests. This repetitive cycle slows development, breaks pipelines, and introduces inconsistency between local and production environments.

Should you use UUIDs as the primary key in your database? You might have heard they are terrible for performance, which is often true for traditional UUIDv4. However, the introduction of UUIDv7 fixes many of the previous issues of UUIDv4. Let’s therefore explore what they are and why it might be a good idea to use them.

The third quarter of 2025 has been a busy one for VictoriaMetrics Cloud! We expanded globally, polished the user experience, introduced new enterprise debugging tools, and delivered smarter alerts to help users make the most of their observability data. If you missed our Quarterly Live Update, don’t worry! You can watch the full recording here: Let’s recap what’s new in VictoriaMetrics Cloud this quarter.

This is part 2 of a 3-part series on SQL performance improvements. A few weeks ago, we massively improved the performance of the dashboard & website by optimizing some of our SQL queries. In this post, we'll dive deeper into the optimisations of queries with indexes.

Learn how Redgate’s Foundry drives AI innovation in database management - from intelligent monitoring and ML-based automation, to smarter SQL optimization. In today’s rapidly evolving database landscape, innovation is essential. With the rise of artificial intelligence (AI), machine learning (ML), and automation, database management is undergoing one of its most significant transformations in decades.

NHibernate vs ADO.NET is the classic clash in.NET development: raw SQL muscle on one side, high-level abstraction on the other. One promises speed and precision, the other productivity and cleaner code. For most.NET teams, the real challenge here is determining which approach best suits their project’s scale, timeline, and goals. That choice directly influences database efficiency, developer productivity, and long-term stability.

For any growing business, there comes a point where the tools that once worked perfectly begin to show their limits. This is especially true for monitoring infrastructure. As your user base, services, and data volumes expand, the pressure on your monitoring stack intensifies. For web hosting leader DreamHost, with over 1.5 million websites to manage, their existing open-source solutions simply couldn’t keep up.

Data integrity in a database is the backbone of accurate decision-making, regulatory compliance, and organizational security. Without it, even the most advanced analytics or AI models are built on shaky ground. Imagine going through your database and noticing that the numbers in your sales report are inconsistent, financial data tells three different stories, and some customer records are missing. This mismatch can compromise business decisions and lead to missed opportunities.