The AI said I had to do a database first, not code. Who am I to argue? So, with all the prompts outlining the goals of the project, I’ve gone forward with the project, and step one is creating a PostgreSQL database on Azure. This is part three of a…Read more
With just 2 weeks to go until PASS Data Community Summit 2025 kicks off in Seattle, we wanted to let you know what you can expect from Redgate who are proudly hosting the summit this year. Redgate booth This year we’ll be back in the Exhibit Hall with our eye-catching booth and…Read more
This is the next installment of the series on building a database and an application called dbRosetta using AI/LLM. Part 1 introduces the concept. THE AI PICKED DATABASE FIRST! Look, I talk databases at this thing a lot, so it probably knows my own preference, but when I asked it,…Read more
Whether it’s a stalled Log Reader Agent, a conflicting insert on the subscriber, or a failed cleanup job bloating the distribution database, Redgate Monitor now brings SQL Server replication issues to light early, before performance or reliability are affected.Read more
SQL Prompt’s November release brings new features to SQL Prompt AI, bug and performance fixes to SQL History and support for SQL Server 2025 preview. AI-powered fix and optimization using Prompt AI We’ve added two new features to SQL Prompt AI this month: fix and optimize. Fix SQL Resolve query…Read more
Like many of you, over the last couple of years, I’ve been using AI, or, well, let’s just name it appropriately, Large Language Models (LLM), as a part of my job. I’ve also used it in my hobby. With it, I’ve generated snippets of code, tested data conversions, even built…Read more
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 see both in the Query Executions view for each SQL Server instance, directly alongside server activity and alerts, so you can diagnose the…Read more
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. Advanced Table Configuration – simplifying subsetting for large databases Configure subsets on databases with thousands…Read more
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. For…Read more
Every year, thousands of data professionals share how their teams work, what’s changing, and where the biggest challenges lie. Together, their insights form the State of the Database Landscape industry report. Now, we’re inviting you to add your voice. Whether you’re a developer, DBA, architect, or data leader, your perspective…Read more