When I travel, I try to take y’all with me to really pretty or at least interesting locations. On my Tokyo visit last year, I did Office Hours in Akihabara, the electronics & anime shopping hub. Even though I’m not into anime at all and I don’t collect that kind of gear, I wanted to see it because it’s famous among geeks.

Well, this time around, I’m in Tokyo again, but, uh… we’re just hanging out outside my hotel, because I ran out of time to take y’all somewhere cool before I came home. Let’s go through your top-voted questions from https://pollgab.com/room/brento anyway.

Here’s what we covered:

• 00:00 Start
• 02:08 Rumi: How does the best PostgreSQL DB management app compare to SSMS 22?
• 03:09 Mango: Hi brent, we are running on-prem SQL Server 2019 and Azure SQL. I am trying to get my boss (CIO) to purchase a monitoring tool but he insists that I use Azure Database Watcher (DW). DW can’t monitor on-prem databases. What are your thoughts regarding a monitoring tool. vs. DW?
• 04:00 Feeling Turquoise: How worried should I be if sp_BlitzFirst takes 20 seconds to run?
• 04:31 Chicago_Dav: How disruptive do you forsee the imminent AI bubble burst being?
• 08:29 Radek: Hi Brent, I believe I heard you saying that it is a good idea to work with the most expensive thing in the room, so your salary looks small… I wonder why you decided to work with SQL Server, not Oracle?
• 08:52 MyTeaGotCold: Do you see any value in enabling Accelerated Database Recovery for the sole purpose of making it easy to recover from accidental long-running transactions?
• 10:07 View master: In SQL views, what is your take on naming convention? Use one? Don’t use one?
• 11:03 Dopinder: What was your experience like with The Great Firewall of China? Does VPN work with it?
• 12:42 Dopinder: Our company has no data retention so the SQL multi tenant database is massive. What are the cons / risks of no data retention? Do you run into this much? How do you convince management to apply data retention policies?
• 12:44 Dopinder: Our company has no data retention so the SQL multi tenant database is massive. What are the cons / risks of no data retention? Do you run into this much? How do you convince management to apply data retention policies?
• 14:16 Jan C. de Graaf – Blijleven: Hello Brent. You’ve recommended Itzik Ben-Gan’s books several times. Do you know of any good material, preferably books, for targeting EF on Sql Server? We’re specifically looking for in-depth guidance on todo’s and don’t’s with regard to a relatively busy OLTP system.
• 15:03 DTech: Hi Brent My friend is going to work on a new client where client is asking which SQL version(2019 or 2022) . Which version he can recommend
• 15:31 Elwood Blues: What are your thoughts on running a 8 core, 128 GB RAM SQL server for reporting on Azure Local infrastructure? Should I skip azure local and just aim to deploy in an Azure VM? There could be some cost savings with Azure local deployment.
• 17:14 jrl: The coding models and tools have made rapid progress in recent months. Please talk about your approach to LLM-assisted coding. Can you quantify the productivity gain you and Richie are seeing with LLM-assisted coding, and how much autonomy are you giving these tools?