Office Hours: 16 Questions
Вставка
- Опубліковано 8 чер 2024
- Like Sixteen Candles, but different: I go through your top-voted questions from pollgab.com/room/brento about databases. Here's what we covered today:
00:00 Start
01:26 GuaroSql: Hey Brent! How are you? It is necessary to enable ADR in sql 2019 in order to row versioning work better? Or it is optional? I just realized it is turned off in my sql 2019 databases. Thanks!
02:42 RoJo: If I'm upgrading a major version (e.g. 2016 to 2019) and build a brand new install. Can I simply Detach the old DB and attach to the new one? or is there file structure changes that Backup / Restore handle (or any other reason). Goal to save time on big DB.
03:54 Nestrus: Why are views sometimes much slower than the same query executed directly in the stored procedure and what can be done to make them equally fast? The only difference I can see is, that the query directly in the SP gets parallelized and the view is not.
04:58 MyTeaGotCold: Do you know any good mailing lists for peer reviewing large writings about SQL Server?
05:52 Bonnie Tyler: Did you experience a total eclipse?
06:00 Jökull: What are your thoughts on remoting into the production SQL Server to run SSMS? We have several power users that like to do this. What's the best way to deal with this?
07:09 CreditToMyTL: Recently, a table with wrong data caused the business to go down for a few hours. We planned to create a trigger to check who was behind these. My TL prefers creating dynamic triggers so that new tables automatically have audit logs. Is a dynamic trigger the best option here?
08:13 Garreth: How do change the culture so that production dba role is less of reactive role and more of a proactive role?
09:00 Jökull: Many users have permissions on the production boxed SQL Server to create SQL agent jobs. How should you track down who to contact when one of these jobs starts to fail?
10:29 Ignacio: In the DBA field, is deep or wide knowledge more valuable as a job seeker?
11:19 DemandingBrentsAttention: Knowing your opinion on linked servers (go fetch the data directly), what are some uses cases that you begrudgingly tolerate, or enthusiastically support?
12:17 Miles: Hi Brent, Could you please give some advice (especially when it comes to introverts) on how to network with people so that, people can genuinely help in one's career instead of having 1000's of LinkedIn connects?
13:03 Jökull: PostgreSQL now supports MySQL wire protocol. Is it inevitable PostgreSQL will do something similar for Oracle?
13:52 Gabbpoll: To fabric or not to fabric. Is it worth exploring?
14:34 PAul: I always put DECLAREs at the head of my code, because in VFP they were not evaluated in-line in the code flow, say in a loop or IF statement. Does SQL server do the same thing?
15:23 Nostradamus: Does parameter sniffing ever happen with smaller tables or just larger tables? - Наука та технологія
The old interplay PC Fallout games from the 90s are amazing CRPGs and all turned based. Might be more your speed.
Great episode Brent. By the way - what are you thoughts on dBase? 😅
When you gonna get rid of the granny lights, BrentO?
I did today, actually!
I saw the reaction to VFP and died a little.
Listen, if you're still using VFP in the year 2024, there's not much left of you to die...
@@BrentOzarUnlimited I'm not, but I remember my early times with it fondly, is all.
Visual Fox Pro ... bruhhh
have you tried goat simulator?
I have! I played it years ago when it first came out.
Fallout? Really??? I thought you were kidding. Couldn't get past the first 30 minutes of that total piece of dog dung.
I'll make you a deal: you don't talk that way about TV shows I like, and I won't do a public code review of your T-SQL. Fair? ;-)