Operations | Monitoring | ITSM | DevOps | Cloud

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.

Blocking is like a traffic pileup: when it occurs, it's helpful to find the "lead blocker" and then step through the chain of who blocked who. In this video we step through an example blocking chain and give tips on how to find useful information in SQL Monitor.

SQL Monitor now shows you insights on what's using up space in tempdb. Is it the version store? Internal objects like hash joins or sorts? User objects like temp tables? Which sessions are involved, and how are your tempdb files being used? Join Kendra to look over an example workload.

In this cracker of a DBAle episode, you can not only hear, but see our Chris-tmas duo as they embark on an end-to-end database journey where even the beers are getting Festiv-O. There’s no gold, frankincense, and myrrh, instead our two (not so) wise men build and incrementally deliver NuGet presents down your pipeline chimney. So, grab yourself a beer and tune in for the last DBAle of 2020 - cheers!