[Video] Office Hours: 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.
I had to cut the first ~60 seconds of the intro, so it seems to start in an odd place:
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?
4 Comments. Leave new
Hi Brent, Love your blogs and training! A lot of people like me can’t run the .exe files for training you’re thinking of making while at work. A PowerShell script would be much better as I can see what it is “really” connecting to and doing. Yeah, it will be less idiot proof, but if you’re looking for a wider audience it might be something to consider. Also, it won’t be blocked by Mordac the Preventer of Information Services. Keep up the good work. Cheers!
The training classes have always used exes, like SQLQueryStress. The only difference is that these would be new exes.
Re: bitlocker
The argument I have made with that in the past was to use bitlocker on the OS disk, put at least the master db on the OS disk (though I ususally do master, msdb and model) then use TDE on all user databases and then create an automated report for security to list all databases in the instance and the TDE state of the database to audit their encrypted state. It mitigates offline attacks against the OS where someone could change the service account to system, create a sysadmin login then remove TDE encryption.
Thanks Brent. Oh and also thanks for the “Paste Your Plan” tool