Why these picks
Ever feel like a complex execution plan is just a big puzzle with too many pieces? This week, I found some great reads that show how experts in other fields handle the same kind of stress. Whether they are digging into the earth or looking for clues in a mystery, they all have to find the best path through a mess of info.
Seeing how others filter out the noise helps us do the same. Sometimes the best way to understand a database is to step away from the screen for a minute. These stories are a great way to reset your brain.
Stories worth your time
Finding the Path: The New Math of Deep-Earth Exploration
Mapping out where to drill deep in the earth isn't that different from picking the right join order. You have to use the data you have to predict what's going to happen before you start the heavy work. This story from seeknexushub.com shows how they find the right way through tough layers of rock.Read more here.
Finding the Clues We Usually Ignore
When a query runs slow, the answer is often hiding in a tiny detail we overlooked. This piece from themidnightfile.com is about how detectives spot things others miss. It's a good reminder to check those small stats and index hits that we usually take for granted.Read more here.
Tiny Shakes and Hidden Clues: Our Weekly Digest
A running database has a rhythm, just like a mechanical watch. This digest from chasepulses.com looks at how tiny vibrations tell a story about how well a machine is working. It might give you some ideas on how to listen to the pulse of your own systems when they aren't behaving.Read more here.
