Scott Sauber, Director of Engineering at Lean TECHniques Inc., covers the challenges and benefits of source controlling database changes, including a demo of Flyway.
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.
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.
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.
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.
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.
We are frequently asked about how to incorporate Test Driven Development Practices to current deployment processes. On this video I'll guide you on a step-by-step journey of how to create a new test project and align it with your existing SQL Change Automation database code pipeline.
It's hard to know where to start with Database Classification and many choose to go column-by-column. In this video join Chris as they show you how to get AdventureWorks classified in under 20 minutes using clever rules, bulk filters and a logical approach with Redgate SQL Data Catalog.
Is it possible to set up an end-to-end deployment pipeline from Dev through to Production in Azure DevOps, with SQL Change Automation and Azure SQL DB in just 10 minutes? Join Chris Unwin, a Redgate Solution Engineer, as they try to break the record for setting up a migrations-first pipeline with SQL Change Automation from Dev to Continuous Integration and finally, deployment.
Spawn let's you quickly spin up database instances in containers. This is great for dev environments, testing, continuous integration, training, and more. There's also a new extension for Azure Data Studio that makes connecting to the container super easy.