Office Hours in My Vegas Backyard

Video Description

I went through your top-voted questions from https://pollgab.com/room/brento and here's what we covered: 00:00 Start 00:29 Nick H: I'm a new starter at an organisation who have lots of rules, one of which is that the use of Intellisense is forbidden. I asked why and was told that this was a decision taken "a long time ago" and is due to some apparent negative impact on servers. Is there any truth in this? 01:28 Adrian: Hi Brent, have you ever recommended Capture Data Change or Change Tracking to your customers? If yes, what for? What is your opinion about these features? I have an internal team pushing for this to replicate the data to a different system and I am not sure it is a good idea. 02:18 Frozt: What can you say about SQL 2025? do you recommend upgrading from 2016 to 2025 or you recommend 2022 for stability? Any SQL 2025 gotchas we should think about and are you excited with something for SQL 2025? Thank you 03:43 Snowman: I recently learned that you can only take copy-only backups on AG secondaries. What is the use case for this? I don't see how it reduces my need to backup the primary. 04:14 Dopinder: Is it worth it to be a dual stack DBA (MSSQL / Postgres)? How do you keep them separate in your brain? 05:18 sqlpadawan: Came here after your post about your sexuality. It takes guts to bring that subject publicly and receive the virtual stones. Q: How was "that" conversation with your ex-partner? Are you still close/friends? Have you lost clients/followers/friends after sharing that in public? 06:12 NikTrs: When corruption happens on non clustered indexes or non important tables which can be restored from backups, is it safe to drop the objects and recreating them to remove corruption instead of restoring the database from backup 07:29 Sysadmim: Is there a way to remove cached statistics on temp tables?Trying to solve an issue with skewed row-count on temp table by 1 odd-out execution resulting in massive scans, I'm not able to change the stored procedure to add an option recompile or update stats on the said temp table. 07:46 Trapped in the cloud: Do you still distribute "SQL Server Performance Tuning in Google Compute Engine"? It's not in the First Responder Kit, your website, or Google's. 08:33 Uncle: In terms of SQL DB Backups, is it better to rely on Enterprise Backup solution like Networker or Veritas (knowing it requires sysadmin, and the DBA does not have access to it) or have conventional (Ola's script) backups to a network share and enterprise backup the shared drive? 09:40 MyTeaGotCold: I've never seen anyone talk about Contained Availability Groups since they were announced. Were they any good? 10:37 RoJo: Can you discuss your current guidelines for Antivirus on the SQL server. Some say don't do it at all and harden access to it so nothing gets in. Agents can make SQL slow. Where is your balance. Trying to solve security vs performance. (remembering CloudStrike-shudder) 11:39 Mr. Zbd409: Is there any reason to keep data forever? With cheap storage (archive tier azure) , I feel like this is a consideration for businesses. is there any reason to delete data? Is it cheaper to store archive data in json rather than proprietary sql server backup file? 12:30 Bandhu: What are your pros / cons for implementing multi - tenancy at the server level (each tenant has their own database server)? Do you see this much in the field? 13:00 30-years-till-retirement: I'm about 10 years into my data career. I've heard some SQL MVPs on a podcast say it takes 3-6 months to find a new job. I'd assume it was 6 weeks at most. Is this a case of me having low standards for future employers? In case it wasn't clear, I'm not a SQL MVP! 14:45 Ricardo: We use chromebooks instead of windows laptops. Whats the best way to administer cloud based (mostly azure) sql servers? 15:02 What's the Problem You're Trying to Solve?: "My friend" recently ran sp_BlitzIndex on a table with 1.5 M rows, result: 450 indexes, mostly "IN-MEMORY/HYPOTHETICAL" with no usage. Also 5,200 Statistics, mostly Last Updated 5 years ago. Both indexes and stats are named with "_dta" prefix. Should he be worried? 16:32 Mike: How do you treat people who do not use "sp_" prefix when creating their stored procedures ? Is it OK for you, or you kind of strict and think everything should be with a prefix ?