[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?
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
Regarding the question of Justin Case. Erik Darling recently said: “I have never seen a valid argument against business logic in databases or stored procedures that didn’t also express what would seem like wilfull ignorance of the capablities of SQL as a language. (For context, https://www.youtube.com/watch?v=99L0pUf9jOs, question 5)
(Hope I am not out of line referring to another website. If so, my apologies)
I think that’s a little extreme (which surprises me because I usually agree with Erik.) For example, I have one client that only has 3 developers, and they have zero T-SQL experience – they just use Entity Framework for everything. I can’t tell them to move business logic to the database unless I put them through T-SQL training, which will take some time, and it would take a developer (or more) out of commission for a while to do the training.
Blame Consumer Reports rollover testing for destroying the US market for the Suzuki Samurai / Jimny.
PS – Check out the Roadkill Samurai episode.