Let’s hang out, listen to the peaceful waterfall, and go through your top-voted questions from https://pollgab.com/room/brento. This is kinda the calm before the storm: in another week, I’ll be on the road again for a while, hopefully bringing you some fresh Office Hours locations from the Caribbean and Alaska!

Here’s what we covered:

• 00:00 Start
• 01:30 Simon Frazer: I’m curious to know if partitioned views are still used much. How often do you see these out in the wild?
• 02:37 ConfinedLake41: Do you have any words of wisdom when moving from SQL Server-On-Premise to SQL Azure? A client wants to move all services to the cloud (imposed by the group). Also any tips, tricks, hints and or material would be really helpful! Thanks!
• 03:00 Ess Tea DBA: I once heard about using the Resource Governor as a monitoring tool only. Have you ever seen this done in practice?
• 03:45 Craig: I am running sp_BlitzFirst every 15 min to collect metrics as suggested in your “Running SQL Server in AWS & Azure” course. My problem is that sometimes it runs for over 10 min and I do not want this to affect the other processes. Does sp_BlitzFirst have an impact on the server?
• 04:54 chris: When I was younger I had more time on my hands than ideas to use it. Now I find I’ve far more I want to do than I’ve time for. Did you have a hard time deciding to move away from production DBA work? Do you have any advice for making difficult decisions to give something up?
• 09:09 Evan C: Besides using more disk space are there any gotchas with increasing the retention period for CDC?
• 10:02 Northwind: Hi Brent, is there a way to automatically trigger a stored procedure or SQL script right after a database is restored? We have a vendor database which allows engineers to restore prod backups to test. Due to org policy, we can’t mirror prod security in test
• 10:50 Adrian: Are there any plans for future videos regarding working with people (especially in development environments)? I find your talks about working with customers and/or colleagues really reach the same issues or challenges I sometimes find myself in. Would really like to hear more.
• 12:24 neil: What will RCSI actually break in production for a third-party app? Test environment doesnt seem like enough of a test, if I beef up TempDB and turn on RCSI in Prod how do I know if its acceptable to the company? What tests/how do you decide if it’s working? Data errors? Downtime?
• 13:34 Craig: How can I measure busyness by database. I am looking for something like batch requests per second — but, by database.
• 14:17 Craig: At the moment, our webpages call multiple store procedures (one for dropdown, one for list etc). We are considering making each webpage call a single stored procedure that returns multiple sets of data. What would you use to test if this is an improvement (or not)?
• 15:29 VegasHeatIsNoJoke: Brent what’s the sweet spot for free space in Azure SQL DBs? The problem my bosses are trying to solve: price of storage is now our pain point. Few of our large databases have free space over a TB while the % free is in the 15-20% range. I worry about performance.
• 17:01 MyTeaGotCold: Do you often find that Basic Availability Groups meet the HA/DR needs of your clients? I struggle to picture picking them instead of FCI or log shipping.
• 18:02 Dfens: Hi Brent, I need to prevert that 1 Sp of a DB takes all the recources of my full sql instance. Is there a way in Standart Edition to limit cpu, ram or disk usage somehow? This is one main reason that we do not put all DBs on one server but we have several sql servers.
• 19:02 neil: Are storage snapshot backups available for SQL VMs in Azure ?