Office Hours: Ask Me Anything About Databases
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones on TikTok. 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?