Рет қаралды 3,413
I sat down on the patio to take your top-voted questions from pollgab.com/room/brento. Here's what we covered:
00:00 Start
00:56 MyTeaGotCold: When going in to a database blind, do you worry at all about its compatibility level? I see a lot of unloved databases that are still on 2008's level, but the tiny potential for breaking changes makes me scared to touch it.
02:01 Vishnu: For boxed SQL, Is it ok for users to create SQL agent jobs that run periodic business logic and/or email end users?
02:59 Karthik: What's your opinion of live query plan viewing in SQL Sentry Plan Explorer?
03:26 Jessica : I am DBA who previously managed dozens of Azure VMs running SQL Server AGs. After a layoff and new job I'm now managing 1 prod Azure SQL db. Any tips for someone making a transition like this? Every day I'm finding features that I no longer have access to and minimal monitoring.
04:29 Hong Kong Phoey: Currently, when we see a non-clustered index on a given multi-tenant SQL table, we may or may not know why it's there, who created it, when it was created or which app needs it. What's the recommended change control process for answering these questions?
05:35 Kevin M: What's the best place to go for commercial PostgreSQL training?
06:02 NotCloseEnoughToRetirementToStopLearning : Hi Brent Inheriting a VLDB (50Tb) any recommended articles or trainings for working with something this size?
07:05 Mike: Hi Brent! When migrating from SQL Server 2017 to SQL Managed Instance, on MI databases after restore become FORCE_LAST_GOOD_PLAN = ON (On 2017, it was OFF). Do you recommend leaving it ON, or should we turn it OFF on initial stages ?
08:27 Venkat: What's the most common detrimental complacency you see with SQL dbas?
09:13 Mattia: Can a big analytical query that does many logical reads (compared to the SQL Server RAM) give SQL Server Plan cache amnesia? Or is the Buffer Pool completely separated from the Plan Cache?
09:48 Nickelton: Is it possible to forward select queries to AG secondary replica without changing application side? (connection string etc.) For example running code from SSMS or for legacy applications.
11:22 WB_DBA: My friend suggests creating all indexes on a test database since it mirrors the production database. Is this a good approach?