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?
Watch video Office Hours: Ask Me Anything About Databases online without registration, duration hours minute second in high quality. This video was added by user Brent Ozar Unlimited 27 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,199 once and liked it 161 people.