SQL Server 2016+ Query Store Blitz – This is AWESOME!

Check out: https://www.brentozar.com/archive/2017/06/introducing-sp_blitzquerystore/ Test it like this:   Here's the sp_BlitzQueryStore.sql - Thank you Erik Darling! If you have SQL Server 2017+ it gives you the top 3 wait stats per plan too. Download it here, via the link above or copy it and run it on Master db. Enjoy! Hiram

Batching SQL Scripts to Automate Deployments (with .bat/cmd)

With this technique, you don't have to buy anything or spend time installing fancy stuff. Just write some commands, copy/paste and save as .bat or cmd. [Not discrediting any other implementation, just sharing my experience with a simple method]. When you end up running the batch I recommend doing it on the target server, not your workstation…