Operations | Monitoring | ITSM | DevOps | Cloud

Ever spent hours digging through a pile of Flyway migration files, trying to figure out when a table, view, or procedure changed, and how? In this episode, Tony and Tonie explore Phil Factor’s time-saving PowerShell solution that scans the files for you in version order and pulls out the relevant DDL changes.

If your development team delivers the desired end state of a database, but you then struggle to deploy the required changes safely and consistently, Flyway’s new state-based deployments can help. Tony and Tonie discuss how it works and why it helps bring unreliable deployments under control.

Unexpected changes to a database, known as drift, can cause inconsistencies between environments and break deployments. Tony and Tonie discuss how we can prevent it using drift detection techniques built into Flyway Enterprise.

Carlos Chacon of Marathon Consulting joins Louis for a lively chat about topics far and wide, from the community and podcasts to security and laundromats. Carlos has his own longstanding podcast and, as they came to the end of the interview, he turned the tables on Louis and made him answer some of his own questions too!

The ability to run PowerShell, Bash or Java callbacks adds a lot of power and flexibility to Flyway automation. But how do we ensure these scripts are trusted, don't contain any 'dangerous' commands, and are immutable once signed?

Getting realistic test data from large production databases can be a challenge, especially when you're trying to keep dev environments lightweight and secure. Tony and Tonie discuss how subsetting CLI in Redgate Test Data Manager will help you quickly generate smaller, fully representative subsets automatically.

In this video Redgate Solution Specialist Ryan Springett showcases Redgate Test Data Manager Standard, the software companies latest solution offering in the test data space. Walk through how to define different database treatments via the user interface including.

Steve Jones, Grant Fritchey and Ryan Booz discuss moving your code from one database platform to another, highlighting some of the real benefits and concerns that you need to be aware of.

In this special solo episode, host Louis Davidson stays ‘full screen’ for the entire show and answers the very questions he asks of others! Where it all started, what tech he loves, the one obvious thing he loves to do outside of working with databases (which has been mentioned before)...it’s all covered here!

The Redgate Advocates (Kellyn Gorman, Ryan Booz, Steve Jones, and Grant Fritchey) sat down at the PASS Summit last year and spent some time telling how they went from working directly in tech, to helping others work with tech - both inside and outside of Redgate and their products. Connect with the hosts.