• I'll also add that being both a Developer and a DBA sounds nice on paper but, as you're finding out, it can be a real bugger. I gave up the "front end" a dozen years ago and have never been happier. I've also given up being a manager (have been a Director of MIS, a Dev Manager, etc) with the same result. Being a bit of a "Hybrid" DBA (System Admin, Database Developer, Mentor, and 100% code reviewer) has provided me with rich, full, rewarding days (and, sometimes nights, it goes with the territory) and very good working relationships with all of the Front End/Web Developers.

    And, to be honest, you're in IT. If you want to be "left alone", IT isn't the right business for you. Even Monks get interrupted in what they're doing. Do the absolute best you can but learn when to ask for help or at least tell people that you can't take on more unless you drop something else. No one needs to do all-nighters on a regular basis.

    My favorite parable is to remember the difference between being loyal and being dedicated. It's easy to remember. Just think of "Ham and Eggs".... the chicken was loyal... the pig was dedicated (which is sometimes spelled "dead-icated").

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)