• Depends on their caffeine intake

    Seriously though, there are so many factors that determine how much administrative work needs to be done that it is difficult to give a meaningful figure to this.

    If find that as I go on I automate more and more tasks so that the admin gets less and less.  I also document these tasks so the key information is not just locked up in my head.

    If you want to protect your knowledge then fine, but you will end up shackled to your past achievements.

    The big jump forward for me was finally getting our sys admin to let me switch SQL to using a domain account rather than LOCALSYSTEM.  This enabled me to set up SQL Mail so now any important server messages get e-mailed to a generic internal support e-mail address.

    It also means that the SQL QA Debugger now works correctly and I can set up various automated fail-over facilities to a standby server.

    As ever it is a case of working smarter not just harder.