Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Tracking Aborted Queries and Memory Grants in Redgate Monitor

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.

Exploring how PostgreSQL 18 conquered time with temporal constraints

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 Flyway Enterprise's code analysis: Enforce compliance, reduce risk, deploy with confidence

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.

Activating free trial in dbForge add-ins for SSMS

In this video, you’ll learn how to activate a dbForge add-in for Microsoft SQL Server Management Studio. We’ll use dbForge SQL Complete as an example, but the activation steps apply to all dbForge add-ins. We’ll show where to find your activation key, how to activate online or offline, and even via the command line. Activation is quick, secure, and free — so you can start your trial right away!

Automate CockroachDB Schema Changes with Harness Database DevOps

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.

Simple Talk Podcast - Coffee Chat with Lee Brownhill

Steve sits down with Lee Brownhill, who by day helps clients optimize their SQL workloads in Azure and AWS at Cloud Rede, but is also a Redgate Ambassador, blogger and aspiring speaker. Lee talks about his interest in giving back to the SQL Server community through writing and speaking, having taken inspiration from others online and in-person at events, and naturally the conversation also touches upon AI, the cloud, and more.

Progress Without Control in the Age of AI and Compliance

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.