[Video] Office Hours in a Lava Field
On a 12-hour layover in Keflavik, I pulled over my Suzuki Jimny (love these little things, and we can’t buy them in the US) in some of the freshest real estate in the world and took your top-voted questions from https://pollgab.com/room/brento. This is a 360-degree video, so you can move the camera angle around with your mouse.
Here’s what we covered:
- 00:00 Start
- 02:29 No Lying: Be real — has anyone actually gotten meaningful value out of In-Memory OLTP
- 04:08 Idaho: When is it responsible to use a query hint instead of trying to make the optimizer choose the “right” plan on its own?
- 05:59 Senior or Junior: At what point is someone actually a “Senior DBA” — years of experience, outage scars, mentoring others, or something else?
- 07:48 Casey: Does consulting make you sharper because you see more environments, or shallower because you rarely live with the long-term consequences?
- 09:05 Justin Case: Is it finally time to admit that stored procedures are an outdated way to manage business logic, and we should be moving it all to the application layer?
- 10:44 RoJo: Can SQL be used to store application secrets instead of Azure keyvault securely? Seems like a great place and much cleaner than reading from vault. Any drawbacks?
- 11:28 Faint Smell of Greggs: I’m splitting up a 20 TB database across at two servers, but the split is such that a foreign key relationship will have to go across the servers. If I can’t get rid of the foreign key, what options remain?
