"or the dodgy fibre switch that runs one of the database back ends"
Or in our case the switch which has ended up becoming a core switch just because important things were plugged into it willynilly. Which now has degraded to the point where the only way to connect to it is by manually putting it's MAC into your ARP cache.
Of course the things plugged into it don't have redundant connections and can't possibly be unplugged for any reason, or so I'm told at least.
(I might 'accidentally' depower it at some point just to force the issue)