Black Friday prices end in 11d 04h 49m — See the sale

[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.

Office Hours After the PASS Summit

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.

Leave a comment

Email me: