Toptal published and illustrated a lengthy article I wrote on what I call Adminimisation, that is, automating away the boring and routine tasks involved in running a web service. Useful if you program admin dashboards which you or your staff regularly grapple with.).
Adminimisation: Tips for Building Great Admin Dashboards
How to build a robust administrative area that'll help you automate away the boring and routine tasks involved in running a web site
The original piece is part of my Confessions of an Unintentional CTO book, which is currently available to read for free online.
More Articles: Click here for full archive
Tips, shortcuts and revisions to the original method
Data Validity Spot Checks, No-Delete Policies, Database Constraints, and Care with NULLs vs. FALSEs etc.
Presented in the form of 10 axioms