My cruise ship took a detour to Honduras to avoid the hurricane. Let’s hang out on the beach and go through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

• 00:00 Start
• 00:58 Dopinder: What is your opinion of the Github copilot support in SSMS 22? Is this more beneficial for the DBA or Data Engineer?
• 03:45 RunningOutofArguments: My company is planning an application that processes incoming emails and wants to store the emails and possibly attachments in SQL Server. You used to argue against that and using the file system instead. Has your opinion changed?
• 05:26 Harold Bright: When MSSQL Server Services takes up a memory say about 80% when it gets busy, why is that it does not go down (like other apps) even when the application traffic is brought down to nothing? Can something be done to bring the memory down when its not in use?
• 06:18 Mr. SqlSeeks: What was the rough employee count of the smallest company that has hired you in the past 5 years? I am curious if you are mostly hired by large organizations or if smaller orgs, even startups, bring you in for assistance.
• 08:47 Scooter: When passing array type data to a TSQL sp, what are your pros / cons of passing the array as csv string value, table variable, or user defined table type? This sp will be called by c#.
• 10:09 Big Blue Couch: Hey Brent, My T-sql skills are mid-level at best. In recent months, I’ve finished reading T-sql fundamentals and t-sql window functions. Do you have recommendations of blogs to read that go into more advanced T-sql usage? I just started reading Erik Darling and Gail shaw.
• 13:48 chris: I can physically leave my workplace; however, how do I mentally disengage from work so I can be mentally present for my loved ones? I find disengaging very difficult when I’m neck deep in a difficult problem. How do you close out of work mode when you’ve so many “open loops”?
• 16:25 AI_is_my_DBA: Setting up SQL Servers with 6 local SSDs. Referenced your setup checklist. Need to balance RAID level, drive separation, and SQL preference for 64K block size. Leaning towards a RAID1 for OS/SQL, a RAID10 for data/logs. I am a novice trying to avoid select pain from poor_choice.
• 19:09 MyTeaGotCold: How fearful should I be of hinting indexes? Sometimes, they’re the only easy solution to my problem but I worry about them being brittle.
• 19:45 Q-Ent: Hello Brent, do you think Oracle invests more in its certified professionals than Microsoft does? The new certifications feel quite shallow, both in prestige and technical depth.