I took a break from unpacking my SQL Saturday San Diego bags and re-packing for a Boston wedding long enough to take your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
01:55 Deadlockinator: Hi Brent, Why does sp_BlitzWho return NULL in the query_text for some SPID, even when I’m running it as sysadmin? It also seems like it’s not capturing all the sessions, but SQL Profiler gets all the statements, especially the ones running with sp_executesql. Thanks! 03:46 Bruce: How prevalent is SQL Server on Linux in production environments? 04:32 Bandu: How many companies have you