Database development

Posts Categorized in Database development

As more and more software development moves towards devops processes, it’s important to bring the database along too. At Redgate, we’re making it possible with a suite of database development tools that plug into and integrate with the software used in application development. The result? DevOps for the database has become a reality.

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... Read more

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... Read more

SQL Prompt Product Updates – December 2025

SQL Prompt’s December release brings support for SSMS 22 and SQL Server 2025. SSMS 22 support SQL Prompt v11.2 now supports SSMS 22 on both ARM64 and x64 architectures (ARM64 support was re-introduced as one of the key new features in the SSMS 22 release.) If you’re installing SSMS 22 alongside an existing version... Read more

Building dbRosetta Using AI: Part 3, Creating a Database

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 multi-part set of articles.... Read more

Building dbRosetta Using AI: Part 2, Defining the Project & Prompt Templates

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, it chose to build... Read more

SQL Prompt Product Updates – November 2025

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 errors using the Fix... Read more

Building dbRosetta Using AI: Part 1 of Many

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 a small database for... Read more

Finish the year strong: make SQL Server development faster, more reliable, and more consistent

As the final quarter ramps up, development teams are juggling tight deadlines, last-minute requests, and the pressure to deliver reliable releases before the holiday season. But when SQL Server development is slowed down by manual tasks, inconsistent processes, and deployment errors, even the best teams can struggle to keep up. That’s why many teams... Read more

Introducing PostgreSQL Static Data in Flyway

One kind of data in most relational databases is what we call static data. This is also referred to as lookup data, code data, domain data or even list data. Whatever you like to call it, it’s usually smaller data sets consisting of data that never changes, or changes very slowly. One example might... Read more

Redgate Blog