[Video] Office Hours: Open Q&A on Microsoft Databases

Videos
2 Comments

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?
Previous Post
Free Webcast: How to Think Like the Engine, Big Data Edition
Next Post
Announcing the Winners of the Biggest Database Regret Contest

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.

    Reply
  • GroupBy is actually back. They’re putting something on end of October (29th).

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.