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 seen 1. Attempt a transition from MSSQL to PostgreSQL. 2. Complete a transition from MSSQL to PostgreSQL?
- 06:37 MyTeaGotCold: Is there a shorter way to say “Microsoft SQL Server on Amazon RDS”? None of those words seem optional! There are many SQL servers on RDS that aren’t Microsoft’s and many clouds that aren’t Amazon’s!
- 07:03 Ray: When Installing Cumulative Updates for SQL Server all the previous updates for the Service Pack get installed. If there are 10 CUs and CU 5 has a bug, will that bug be an issue when I install CU10?
- 07:52 Sean: Heyo! Inspired by your consulting video. How would you get Ops/Dev buy in on performance or optimization requests? Our infrastructure DBA team has raised tickets, standups, pushed at exec prioritization meetings, handed them all-in-one fixit scripts to test, with no luck.
- 09:33 Dru: Do you ever watch any of the free Carnegie Mellon database college courses on YouTube? What is your favorite?
- 11:04 Erzsebet: Does SQL CLR compare favorably with PostgreSQL extensions? What is your favorite PostgreSQL extension?
