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.

A customer recently asked if Redgate's comparison engine is able to generate code to split partitions when a partitioned table is modified. Yes, it can! In this video we demonstrate this in SQL Compare, but the same functionality is also available for automated deployments from SQL Source Control and SQL Change Automation, which use the SQL Compare Engine.

There's a quick and easy way to filter the list of database changes to import in SQL Change Automation in Visual Studio -- just start typing the text of what you'd like to filter by! Redgate's Kendra Little shows how it works in this short video.

At times you may wish to initialize a new Git repo on your client machine. Redgate's Kendra Little shares some tips for doing this in VSCode.