All of these are doable with scripts, tools, and/or elbow grease, mind you – they’re just not as easy as they sound at first glance until you know about the existence of those scripts, tools, and/or free people waiting around with spare elbow grease.
- “Go through the log and find out who ran this query.”
- “Apps sometimes time out when connecting to database server. Why?”
- “Build a new server with the same configuration as the old server.”
- “I just ran an UPDATE without a WHERE clause. Undo just that one query.”
- “Show me everyone who can read from this table, including groups and app users.”
- “Run a load test on these two servers and compare them.”
- “The reports server needs a synced copy of the accounting server’s customer table.”
- “What were the slowest running queries yesterday?”
- “Why is this query slow in production, but fast in development?”
- “Apply the latest updates for the cluster.”
As you read through that list and say to yourself, “Hey, I know how to do some of those really easily,” stop and congratulate yourself. You’ve learned things over the years, and you’re better at databases than when you started.