[Video] Office Hours at the Black Pebble Beach

After the PASS Data Community Summit in Frankfurt, Germany, I headed back to Iceland and spent a few more days gallivanting around the country in a Tesla Model Y camper. (Well, “camper” is a glamorous word for it: CampEasy.com puts a mattress in the back. But still.)

Today, I’m at Djúpalónssandur, a marvelous black pebble beach. Not black sand, but black pebble, which means that as the waves wash in and out, they make the most delightful background noise of thousands of pebbles knocking against each other. You won’t hear it as I’m speaking because I have a microphone near my mouth as I went through your top-voted questions from https://pollgab.com/room/brento.

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.

Here’s what we covered:

• 00:00 Start
• 02:45 STLDBA: I am running a 3-server availability group. I’ve always wondered if it would be better to have fewer large databases instead of many smaller ones. By using schemas to break up application related tables, why not have 1 database instead of separate databases for each application?
• 04:50 Eric Dycus: I am using ola hallengren index optimize job. Every so often, it will deadlock with a internal stats update the server is doing. Why does they happen and how do I minimize it.
• 07:27 BobTheDeveloper: I have a database that is bigger than RAM. I would like SQL to cache it entirely in memory for read performance (my I/O sucks). If I page compress and then shrink the database when I load it from flat files, it fits comfortably. Is this reasonable? (I’m not using In-Memory OLTP).
• 09:16 Seek and Destroy: If a query uses an index scan, does that automatically mean something is wrong?
• 10:20 Quiet Q: Can you have a great database career without blogging, speaking, posting online, or building a public reputation?
• 12:05 Used-to-be-DBA: Why is it that when people start talking about data governance or medallion architecture I feel like I’m listening to someone’s personal manifesto? Should I be worried about a coup in my company?