This article was linked to from a recent Brent Ozar PLC newsletter. It contains a bunch of tips about how to be a programmer(Not how to program, but how to be a programmer – the distinction is important). I think it was absolutely brilliant and has huge areas of crossover to other technical roles…such as DBA’s.
(Dead Link)http://samizdat.mines.edu/howto/HowToBeAProgrammer.html?x#id2855381(Dead Link)
I particularly liked the sections on how to deal with difficult people, how to provide estimates, and perhaps best was knowing when to go home:)