I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers.

Here’s what we covered:

• 00:00 Start
• 00:52 chandwich: If SSMS had a dark mode option that was equally as good as the existing light mode, would you use it? Any idea why it doesn’t exist yet? RE: The on-call DBA that doesn’t like being blinded at 2:00 AM by SSMS.
• 06:06 DBA JR: Hi, Brent what do you think about DP-300 Exam Certification or other certification? do you think is effective for finding a DBA job in the US or Europe? Is it important for companies?
• 09:01 MyTeaGotCold: What are the biggest disadvantages of using RDS Microsoft SQL Server instead of an EC2?
• 11:01 Yukio: What are the top skill gaps you see in SQL Server DBAs?
• 14:20 DataGuy: Assuming a table does not have range scans nor ORDER BYs, why should a clustered index be added? HEAPs get a lot of hate, but maintaining them nightly with enterprise edition isn’t that big of deal. Blindly adding CX to the PK field(s) means worse performance for the NC indexes?
• 16:36 Ozan: Hi Brent, when a SQL Server Patch gets released it makes sense to wait a while before deploying because it might be buggy or might have other unexpected surprises. Do you know a reliable source or community where one can check if a patch is „safe“? Thanks
• 18:02 Meg Thomas: Does drive block size matter when using NVME SSD in SQL cloud vms ?
• 19:35 Wiron: When should you use a stored procedure?
• 20:24 zxta: How does a database like Redis work?
• 21:17 Ross: When I’m developing an application, what indicators would trigger me to use SQL Server over Postgres?
• 22:53 User: Do you have any plans for Postgres training?
• 23:20 Tadim: What about storing JSON in MongoDB versus Postgres?
• 23:58 Ailos: I use SQL Server clusters on physical devices. What IO values should I look for?
• 25:25 Tim: How do you land a SQL job?
• 28:03 Tadim: Do you have any experience with SingleStore?
• 28:51 Raphra: If ChatGPT or Gemini used your online blogs to train models, would you be ok?
• 30:55 Yoichi Asakawa: What is your opinion of NetApp files for Azure SQL VM?
• 32:10 ThreeDaysGrace: How do I avoid losing connectivity between databases and applications on failover?
• 33:58 User: What’s the difference between leaderless and multi-leader replication for databases?
• 34:42 User: Why should I limit the connection pooling on my server?
• 35:25 Clip: Can you talk about indexing?
• 36:43 Steve Harrington: Is it recommended to use allocation unit size of 64kb on temp db drive for Azure SQL VM? How do you do this if the drive is ephemeral?
• 38:00 OMGTiko: You should talk about why the best data warehouse is a lakehouse.
• 39:29 A discussion about TikTok’s algorithm
• 40:04 Ristos: I’m getting an error in MySQL, how do I fix it?
• 40:27 UnderTheC: How do I use Redis to cache data effectively?
• 41:40 Aidos: When I have different plans for the same query, do you have videos for that?
• 42:35 Fioma: Can you talk about partitions?
• 43:42 Leolog: Any recommendations on how to learn architecture, like data warehouses and lakehouses?
• 44:06 ThreeDaysGrace: Wow, Brent, how are you not losing such inspiration for new technology?
• 46:09 Gambit: How do you determine the correct amount of TempDB files and their sizes?
• 47:08 JChandra: It’s been a while since I looked into SQL Server internals. Can you scale it out horizontally these days?