[Video] Office Hours at Atlantis, Bahamas

Videos

It’s an overcast afternoon at Atlantis Paradise Island in the Bahamas, so since I can’t go into the water, might as well go through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

  • 00:00 Start
  • 00:48 jrl: What makes a good Office Hours question?
  • 01:22 Nils: Do you have any experience with Babelfish or similar tools to migrate from SQL Server to PostgreSQL or another DMBS.
  • 02:22 TeaEarlGrayHot: Why does it seem that when SQL escalates locks from row level locking, that it so seldom escalates to page locks and instead usually escalates to object level locks? Are there specific requirements to achieve page locks?
  • 03:48 Big Blue Couch: Hey Brent, What are you seeing your clients use for ETL Tools? Still SSIS? Or are there other good 3rd party tools seeing mass adoption?
  • 04:46 Margaret: Hi Brent – I know you have a version of WhoIsActive in the First Responder kit, but have you added any code to get the SQL behind API Cursors? This is the one place that WhoIsActive needs improvement. It’s not at all helpful to just have APICursor9251 in the sql_text field.
  • 05:37 NO: I wonder if you see SQL Server on Linux often in the wild or have some experience with it. SQL Server is the only thing that keeps us holding Windows machines that we would like to get rid of it. However, our DBA`s are saying that they dont know what effects this will cause
  • 06:09 StoicDBA: Uou mentioned that you are a Stoic. As a practicing Stoic myself, would you care to explain a few things about Stoicism means to you, which books you would recommend the most, and how Stoicism has helped you become a better DBA.
  • 12:10 Captain Calamity: For the CU22-23 DBmail debacle, should those shops always stay one CU behind the latest CU rather than always installing latest CU? What other CU calamities do you remember?
  • 13:18 Nolb: If you were about to start a new green field project, what would be your main reason(s) to stick with SQL server compared to something less costy like PostgreSQL
Previous Post
Updated First Responder Kit and Consultant Toolkit for February 2026

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.