Want Flyway to run checks on all your staging databases? Or switch migration logic based on RDBMS version? TOML-based environments and resolvers make it simpler, and more secure.
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.
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.
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.
Flyway provides a lot of flexibility for releasing database changes in a safe and repeatable manner. Earlier this year, we added the ability to automate state-based deployments. This means the structure of the database is defined in version control and Flyway handles updating a target database to match it. The Flyway comparison engine does all the hard work of identifying what’s different and creating a script that will run on the target database to alter it so it matches the latest state.
In this episode, we're remembering Andrew Pearce aka Phil Factor, and unpacking a brilliant article he wrote digging into why database deployments sometimes go bad.
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 be Canadian postal codes. Another example, and one I’m going to use, is the amateur radio band definitions within a given country.
For nearly 20 years, SQL Prompt has been a trusted companion for database professionals, helping them write cleaner code, reduce errors, and save time. From its earliest days, the focus has been on productivity while removing the repetitive, mundane tasks that slow people down. It’s been about building the reliability and performance that developers and DBAs depend on every day and that story doesn’t stop here.
Steve Jones is at Redgate’s Cambridge, UK headquarters once again, this time joined by Tom Hodgson, Innovation Lead on Redgate’s Foundry team. Tom gives an overview of The Foundry, which is Redgate’s innovation hub, offering some insight on what they do and what they’re working on (spoiler: it involves AI)! Also, hear Tom’s thoughts on AI & LLMs in general – including why sometimes just the basic version of a model is enough.
Avoid the pitfalls of cloud database migration with Redgate Flyway. Learn how automation, schema discipline, rollback strategies, and traceability reduce risk and enable fast, compliant cloud deployments, with these insights from John Q. Martin, Technology Partner Manager at Redgate Software. Cloud migrations promise faster releases and more flexible scaling, but a poorly executed database migration will stop you from exploiting them.