[Video] Office Hours at Atlantis, Bahamas
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
Related

Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Get Free SQL Stuff
"*" indicates required fields
