Operations | Monitoring | ITSM | DevOps | Cloud

Switching branches quickly and testing Pull Request code when working on database changes is no easy thing, but fear not! Join Chris Unwin in this video to find out how you can set up SQL Clone to allow developers to preserve changes when switching branches, and how teams can review code against a live DB, rather than relying on the raw code in version control.

Do you need to mask data consistently, every single time? In this video, Chris Unwin shows us how to use Redgate Data Masker for SQL Server to deterministically mask sensitive values so they can always be used for the same purpose, each time you mask a new copy.

In this video you’ll get an overview of how Redgate’s SQL Change Automation PowerShell module can plug into Jenkins using pipeline-as-code to build and deploy your SQL Server Databases. For more information, feel free to email in, leave a comment below or visit the Redgate website!

Azure DevOps pipelines allow you to create powerful automated workflows. Combining YAML pipelines with Redgate's SQL Change Automation and SQL Clone allow you to create production-like environments on-the-fly for database code review.

In this video you’ll get an overview of how Redgate’s SQL Change Automation PowerShell module can plug into GitLab using pipeline-as-code to build and deploy your SQL Server Databases.

In this Data Masker Headscratcher, Chris shows us how to mask a Heap table by creating a temporary Unique Key constraint, enabling substitution rules to run.

From version control to continuous delivery, Redgate Deploy lets your teams automate database development processes so you can accelerate software delivery and ensure quality code.

SQL Change Automation's Drift Reports give you important insights into how your target database environment may have "drifted" -- before you deploy. In this video, we go from defining database drift into the internals of how the drift report works, then demo the three options you have to configure the drift report.

You can now easily filter the list of database changes to import in SQL Change Automation in SQL Server Management Studio.

A common but tricky issue to identify in SQL Server is when something called "parameter sniffing" goes bad. In this video, Redgate's Kendra Little shows how to identify if a query has an unstable execution plan in SQL Monitor, where to find the parameters which were "sniffed" for each query plan, and gives tips on where to start to resolve the issue.