Database source control using Flyway, a summary - Scott Sauber
Scott Sauber, Director of Engineering at Lean TECHniques Inc., recaps his experience of how organizations use Flyway to source control the database in different scenarios.
Operations | Monitoring | ITSM | DevOps | Cloud
The Place Where Modern Operations & Technology Come Together
DBAle 29: Guess the State of Database DevOps in 2021
Our guest host, and the fountain of knowledge that is, Grant Fritchey, gets into the spirit early enjoying a Beer Can with Chris. Going head-to-head in the ultimate DBAle showdown, Grant pits Chris v Chris as they battle it out to correctly guess insights from the brand new 2021 State of Database DevOps Report.
DBAle 30: If it ain't DevSecOps...what is it?
With both hosts back on the beer to celebrate a momentous milestone, we talk Kiwis and Shoop (ba doop ba doop), sparking inspiration for a future episode. Chris and Chris break it down with DevSecOps. Fear not, there’s no rapping, just a lyrical breakdown of the place and role of security within DevOps. Something the organizations featured in our bumper News segment could do with learning about. So, grab yourself a beer and cheers to DBAle turning 30.
DBAle 31: Monitoring matters for modern data management
Is it a beer, is it a muffin or is it a Panda Pop? Who knows but at 9% strength, producer Louise joins our Chris duo as plan B, to monitor proceedings. Very fitting as our discussion focuses on monitoring for the modern data age. We talk busyness, hybrid estates, tooling, Multi-RDBMS, and a surprising amount about car mechanics. In The News we debate scrape or breach, and the potential maximum fines for the latest Facebook scandal. So, grab yourself a beer and tune in – cheers.
How we used Flyway to source control the database - Scott Sauber
Scott Sauber, Director of Engineering at Lean TECHniques Inc., covers the challenges and benefits of source controlling database changes, including a demo of Flyway.
Flyway demo: database source control and repeatable migrations - Scott Sauber
A short demo with Scott Sauber, covering of how to setup Flyway and use it to source control database changes, as well as take advantage of Flyway's capability to run repeatable migrations - ideal for objects like stored procedures.
Compliance in your Database DevOps pipeline - continuous classification with SQL Data Catalog
Keeping classifications up to date across a constantly evolving structured data landscape is a difficult task, however it can become part of your DevOps process instead of simply offering further red tape to your development teams. Join Chris Unwin, a solution engineer at Redgate Software, to see how you can include SQL Data Catalog within your upstream DevOps process so that nothing in your Production environments is ever without classification.
Environment preparation with Clone Templates & Image Scripts
Join Andrew Pierce, a Redgate Solution Engineer, as he takes you through how to use SQL Clone to prepare environments with subtle changes and requirements as part of the non-Prod provisioning process.
Introduction to Code Analysis in the Redgate solutions
How do you ensure best coding practices are being adopted and reinforce this approach in your entire pipeline? In this video we show you how the same best practices are unified in the Code Analysis functionality offered by SQL Prompt, SQL Change Automation and SQL Monitor to ensure your team are making the best possible changes.
Fixing It Yourself: Troubleshooting Failing Masking Sets
Data Masker for SQL Server is an incredibly powerful solution for de-identifying any sensitive PII that exists within your SQL Server Databases, but with great power, comes great configuration & customizability (and responsibility, of course). Join Chris, a Redgate Solution Engineer as they walk you through some of the common issues people can face when running masking sets, and how to easily start troubleshooting any failed runs yourself.