If you can generate a file-based (JSON) model for each new version of a database, produced by a Flyway migration, then you have an easy way to run simple reports to help you search, list, and understand the structure of these databases. I'll show how to produce the models using PowerShell and then run some queries against them to generate the reports.
The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations involving subqueries.
SQL Prompt users can now share formatting style or code snippets in designated Team spaces on the Redgate Platform. Louis Davidson explains how it works.
See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
It's an oldie but a goodie: Redgate Advocate Grant Fritchey takes us through how best to manage hybrid estates. Read on to find his expert recommendations.