Office Hours: Database Q&A on the Mountaintop

Well, maybe mountain is a bit of a strong word, but it's one of the highest elevation home sites in Las Vegas, with beautiful views over the valley, the Strip, the airport, and the surrounding mountains. Let's go through your top-voted questions from https://pollgab.com/room/brento while taking in the view - and you can move the camera around, since this is an Insta360 video. Here's what we covered: 00:00 Start 00:33 Sun Ra: Who is your favorite musician? 01:27 Dopinder: What is your opinion of the query hint tool in SSMS22? Who is the target audience? Will end users misuse it? 02:30 Trushit: I need medallion architecture for BI initiative. What would be your thought process? Largest table today is about 3M rows. 03:42 I Graduated MIT: In the MIT class, you say developers just need clustered indexes on each table (and FK) as a starting point, and DBAs take over later once it's in production. Does AI change that? Should devs use AI to predict indexes earlier? 05:15 Bandhu: SQL log shipping performance can be bad over cloud provider SMB storage options. What's your opinion of swapping out the default log shipping transport (SMB file copy) to using something more network efficient (Blob storage for Azure or S3 for Amazon)? 06:54 racheld933: Do you have a specific industry/sector of clients that you prefer over others? Like healthcare, finance, education, etc. Are there any specific challenges or trends that show up within each group? 08:21 RoJo: Can you comment on the use of BitLocker on a SQL server host? I'm concerned on speed, and another layer to add when patching or updating. Is it really needed if the Host is physically locked in a rack and room. 10:09 Alice: AI sent me down a powershell rabbit hole of try this, oh wait, sorry try that only to tell me many attempts later that what I was asking for is no longer supported. What is the worst AI rabbit hole you've experienced? 11:30 Mister Robot: At what point does “AI-assisted DBA” turn into “why do we still have DBAs?” 12:58 NicTheDataGuy: Hi Brent, you made a comment in a previous post that " I actually put serious thought into deciding which tool I was going to learn next because I’d have so much free time", curious what you would have done and why? is there a tool/language you think is going to be in demand?