It’s time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento:
Here’s what we discussed:
00:00 Start 00:17 SteveTV: Hi Brent! Are there solutions for managing SQL Agent jobs that obviate the need for manual updates and write access to Job definitions in SSMS? We need to remove write access to agent jobs, and create a deployment strategy that includes approval, change history and testing. 00:36 MyTeaGotCold: I have Query Store enabled on every database and it is overwhelming. Any advice for AUTOMATICALLY monitoring Query Store data across multiple databases? Both sp_BlitzQueryStore