Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 minutes!

Here’s what we discussed:

• 00:00 Start
• 01:05 JoseDBA: We just started monitoring our AlwaysOn with Datadog. Any recommendations of what to monitor that is valuable and not filling ourselves with meaningless alerts? Thanks!
• 01:43 Boutaga: Hey Brent ! Good morning from Switzerland ! As a DBA I have a lot of struggle explaining Devops guys to implement CI/CD all the way to the database… What do think would be a limitation technically for Devops ? What could Microsoft do about it ?
• 02:18 Neil: Reports are searching a varchar(max) auditlog column. Is full-text search a viable option for this? Is it difficult to support or is it just like maintaining an index? My spider sense is tingling.
• 02:52 Ozan: Hi Brent, what is your experience so far with sql server on Linux based systems like rhel (HA, performance, stability)? Thanks
• 03:31 MyTeaGotCold: Do you ever bother with dbachecks? It’s relatively new, but I reckon your First Responder Kit makes it redundant.
• 04:19 Claus: Which relational cloud DB’s have the best separation of compute and storage?
• 04:50 Laris: In what scenario would you want to create a view without schema binding option?
• 05:27 Doug Fresh: What is your opinion of tSQLt for unit testing? Is this actual unit testing with mocks and fakes or is this integration testing?
• 06:12 the crazy frog: Aren’t you doing the Live Master Classes anymore and so update the course material this year?
• 06:40 DB-Ay?: Hi Brent, it is normal to see 10k logical reads per execution (6k per execs p/hour) on an update using the primary key? E.g. UPDATE tab1 SET time = getdate() where ID = @p0 (there’s around 60 columns being updated in the query but I can’t fit them all into the q!). Thanks.
• 07:15 The Swedish Chef: Do you have an easy way to identify an SSMS query plan operator as batch mode or row mode?
• 07:35 Mr. Burns: Have you ever been burned where an end user ask you to delete a user table and said it was ok but after you dropped the table things started to break?
• 08:29 Adam Soong: What is the best way to track down which apps are querying a given view? (Need to make a breaking change to the view).
• 08:50 Cristóbal: It’s simple to see the performance impact of a new non-clustered index on a slow select query in SSMS, but how do you view the new overhead of the new index on inserts / updates / deletes to that table?
• 09:38 Biscuits: How well does the Azure PostgreSQL offering compare to the Aurora PostgreSQL offering?
• 10:27 chandwich: Hey Brent. What’s one part of your online presence you don’t like? For me, it’s thinking of blog posts.
• 11:26 Moshiko: hello brent, is there a reason why microsoft won’t release a native version to mssql server to apple’s new chips ? (M’s)
• 11:54 Firat: Hello from Netherlands 🙂 SQL Standard should be limited to 128GB. But when i give it 140 GB i see SQL use up to 140GB. I believe i even saw it on 160GB when i allow the max. Does this help in my queries like for sorting? Or is it just ignoring all the GB’s above 128GB?
• 12:34 ToffeeC: In any SDLC where does looking at how performant any new/changed database code start? In ours, using Agile, its usually after deployment when the production DBAs deal with any negative the impact lol
• 13:12 Power Paul: What is your opinion of using Copilot to write power BI reports? Has Microsoft finally perfected natural language queries?
• 14:00 Dahj Asha: What is your top 3 Microsoft abandonware for SQL Server?
• 14:55 Accidental DBA: Sometimes when running a database restore it takes over 30 minutes before seeing any percentage complete to start (using spWhoIsActive; bkup 120GB) and other times less than a minute. Can’t find any wait stats causing the difference or docs on the delay. How should I diagnose?