Getting comfortable operating them.
WHAT MAKES PEOPLE NERVOUS
Changes that cannot be undone Not knowing what a command will affect Responsibility for data that matters
WHAT ADDRESSES EACH
Working on copies Checking with a select before an update Backups, verified
WHAT THE SINGLE MOST USEFUL HABIT IS
Running the select before the update or delete.
WHY
It shows exactly which rows will be affected.
WHAT THE SECOND IS
Wrapping changes in a transaction, checking, then committing.
WHY THAT WORKS
You can examine the result before making it permanent.
WHAT TO PRACTISE
Restoring a backup Recovering a dropped table Diagnosing a slow query end to end
WHERE
On a copy, not production.
WHAT TO LEARN TO READ
Execution plans.
WHY
It converts guessing into reasoning.
WHAT EXPERIENCED ADMINISTRATORS ACTUALLY DO
Measure before changing Change one thing Keep a way back
WHAT THEY AVOID
Certainty about systems they have not examined.
WHAT TO BUILD
Your own notes of what you looked up.
WHAT TO ACCEPT
That caution is the professional posture here, not timidity.
WHAT NEVER STOPS BEING TRUE
That a verified backup is the foundation everything else rests on.
