[Video] Office Hours from Iceland’s Glacier Lagoon
Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are sold.
One of my most favorite spots on earth is Jökulsárlón and Diamond Beach. The glacier Vatnajokull is slowly melting into the sea, and pieces break off into the lagoon. The pieces are pinned in the lagoon by the inrushing tide, and as the tides go back out, the baby glaciers float out to sea, then wash up on the black sand beach, sparkling like diamonds in the sun.
This is a 360 video taken first thing in the quiet morning, before the tourists arrive, so it’s fun to spin around and take in the sights while I take your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
- 00:00 Start
- 02:38 MissingIndexMia: How would you improve the missing index suggestions?
- 04:39 PatchMeIfYouCan: With all the AIs spoon-feeding people information (of varying quality) are MSSQL blogs still relevant? If yes, any blog recommendations besides the classics?
- 07:02 Mastering CBT: When blocking isn’t the root cause, how do I tell the difference between a threadpool disaster and an SOS_SCHEDULER_YIELD disaster?
- 07:55 NH: We are having a gameday with practice scenarios at work. I am having a great time figuring about how to mess up SQL server for my colleagues. I think I got the idea from you some time ago, do you have any quick ideas for scenarios? I am planing Corruption, sid mismatch for AGs
- 09:04 Finally patching: Any advice for making good reports of SQL Server bugs to Microsoft? I’ve never done it before, but I know for sure that I have an easy to replicate incorrect results bug.
- 10:58 Used-to-be-DBA: June 2nd office hours vid you mention, DBAs practicing for outages. Should I create test HA, DR SQL tech in a Lab, break it, and task DBAs with fixing? should I include perf issues caused by code? We support various HA and DR SQL tech. What does this training look like?
- 12:53 Lck_Tess_Monster: You talk a lot in the courses about sp_blitzcache, but how does that advice change when you’re in a system with high RAM churn (a few hours from dynamic SQL and ORMs) and frequent reboots (Azure)? I feel like I have to get lucky to catch the things actually worth focusing on.
- 14:06 KP: Is being on call just part of the deal for database professionals
- 17:10 Bandhu: What was your first cruise like? Did you get sea sick? How was the internet speed?
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.
Your comment on your last several postings about a 360 camera do not appear to be valid. This morning I could not move the camera at all to see the Iceland landscape.
Sorry about that – you might be using a browser that doesn’t support it in embedded mode. Click on the YouTube link in the video to watch it on YouTube and see if it happens there.
I was an Oracle dba for a top telecomm co in the late 90’s and on-call was VERY stressful as ANY perf issues or outages was considered by mgmt as crit 1 due to potential revenue loss and wanted the db vendor to treat it as such.
Replying to KP. Not all DBAs are on-call. I work for a state Court system for a county and we are a 8a.m.-5p.m. We have very few after hours work. Usually when we are updating the CMS application and servers. That happens once a year. This is the first DBA position I have worked with no on-call expected in my 40 year career.
Yeah, another example of that is global companies with multiple teams on different continents. One company I worked with had DBA teams in the US, Europe, and Asia, and there was no such thing as being on-call – calls were simply routed to whatever continent was open for business at that time, and they were staffed 7 days a week.