I routinely get requests from management like "I need a list of the urls and the sizes of databases for our <product_name> sites!" This, I can tell you, is NOT something I want to figure out by hand (not with 300 production databases and a slew of training, demo, test, etc... databases as well). No, there is a better, more relaxed way...a way that includes plenty of time for me to check my e-mail, go get a cup of coffee, and chat with my co-workers...

A bit of architectural...

My last blogpost on Python/SSH seemed to be popular, so here I am again with a more in-depth look at what can be accomplished with this pairing.

To recap, I manage 300 databases, some M$ SQL Server, some PostgreSQL. There are a ton of Apache/Linux machines on our network and quite a few "traffic cops" based on Linux and BSD (as well as a few Cisco machines) for routing external traffic to internal machines. Pretty standard stuff. The IT department has a director, a network...