Operations | Monitoring | ITSM | DevOps | Cloud

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!

You can install tSQLt and SQLCop, two open source testing tools that provide you with code testing and code coverage testing respectively. However, you can also automate code coverage through the Azure DevOps Pipeline. This video outlines how this works and results you get.

Next up in our 'Data Masker Headscratchers' series; Redgates Chris Unwin takes us through how we can create an anonymised dataset that still retains the distribution of the data throughout.