[Video] Office Hours: Open Q&A on Microsoft Databases
I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying.
Here’s what we covered:
- 00:00 Start
- 01:00 VegasDBA: Loved the Always-On Availability Group Episode! You mentioned how awful the dashboard is for monitoring. Can you recommend any scripts, custom alerts, or dashboards to keep a better eye on things?
- 03:26 SteveTV: Are there any tools or utilities to manage source control for SQL Agent job definitions?
- 04:21 SHA256: How do you feel about MongoDB? Is there ever a reason to use it over SQL Server?
- 05:50 JoseDBA: What metrics should I show to my boss when asking for a new dba in my team. We are 3 and manage around 180 servers with over 3000 DBs. I read your post of “how many dbas you need” but I don’t know how to properly communicate that. Thanks!!
- 08:49 JoseDBA: How to keep server level objects in sync when using availability groups. Is dbatools the best option?
- 09:46 Discussing my Anthony Bourdain painting by Cassie Ott
- 11:52 Elon: Why don’t you own an electric car?
- 14:27 MyTeaGotCold: When I’m writing a new stored procedure and make a compile-time syntax error, the error’s line number is always wrong. What’s the trick?
- 15:25 Sigurður: Should SQL VM DBA’s also be required to know how to create the underlying infrastructure (VM, cluster, disks)? Is this a unicorn trait?
- 17:15 happydba: what happened to groupby (the online conferences)? they were great 😀
- 18:57 AppleUser: How do I convince my security team not to run EDR on my SQL Server cluster?
- 20:39 Bandhu: For Azure SQL VM’s, is large memory or fast disk more of a dollar premium?
- 21:06 Ninja: I’m struggling getting my SSMS to connect my on-prem SQL Server to Azure Blob Storage. Any advice?
- 22:23 Panagiotis: Currently on SQL 2019 with log shipping HADR. Is it wise to simultaneously migrate to SQL 2022 / availability groups or should those be two separate upgrades?
- 23:45 JerseyDBA: As someone who is younger (30+ years away from retirement) what’s the most important thing you think a DBA can do to future proof their career?
- 25:38 Dopinder: What complimentary AI skills should the SQL Server and PostgreSQL DBAs be learning?
- 27:21 Simon Frazer: Hi Brent, I love reading all your posts about career progression! How much time do you have to spend writing posts to keep your blog fresh?
Related

Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Get Free SQL Stuff
"*" indicates required fields

2 Comments. Leave new
I just got a 2013 Nissan Leaf for $3800. It’s my first foray into EVs. I researched it and found that upgraded batteries can be bought for about the same price and then I will possibly get another 10 years on the car (body and motor are in good shape). I would recommend buying used and maybe upgrade the battery in a few years.
GroupBy is actually back. They’re putting something on end of October (29th).