[Video] Office Hours: Back from the PASS Summit
I’m back from the annual PASS Data Community Summit, so let’s talk industry news before we dive into your 3 top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
- 00:00 Start
- 00:05 News: the vibe at the PASS Summit in Seattle this week
- 03:27 News: Microsoft’s open Q&A about competing with PostgreSQL
- 07:13 News: Microsoft demoing GPU usage in SQL Server query plans
- 09:04 News: Patch Tuesday and bugs in SQL Server
- 11:29 News: Microsoft Purview deprecated
- 13:11 DBA_ReflectingHisCareerChoice: Microsoft retired Database Watchers. If your company used only Azure SQL DBs (incl. elastic pools), what would be your go-to monitoring tool? The open-source tools I know seem focused on on-prem SQL Server, not Azure SQL DB.
- 14:51 MyTeaGotCold: How frequently do you need to go beyond what is shown in an actual execution plan? The only such methods I know of are sys.dm_exec_session_wait_stats, Windows Performance Recorder, and Trace Flag 2363. I don’t recall seeing them in Mastering Query Tuning but it has been a while.
- 16:03 DataBarbieAdministrator: In your opinion, why is the Failover Cluster Instance feature so rarely used in SQL Server? What do you think about that technology?
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.