I think SQLsister has a fairly complete list and was happy to see she included a good manager back his/her employees.
A good manager should also insulate his/her employees. Others in a company should not be comming to an employee and either demand they do something nor should they chastize for not doing something, that they were never informed of.
A good manager is also an understanding person. The type of person who remembers what it was like when they were in that persons place.
So many managers have forgotten what it is like to be the little guy who is new to the company or the young person who is fighting everyday life battles.
I have worked for one manager in my career who I can actually say Impressed me. My wife was pregnant and had issues during her pregnancy that required numerous and frequent doctor vists, many of which I missed. I had requested a couple weeks in advance for some personal time and take short days leaving an hour or 2 early or leaving to go to an appointment then come back, for a particular week where she had 3 fairly important appointments. He said there was no problem at all and I could leave when needed. Well needless to say I missed the first 2 because I refused to give up on some issues that arose. The day of the third appointment he came to me first thing and asked what time the appointment was and how far was the drive. I told him it would take about an hour toget there. Well 2.5 hours before the appointment he reminded me and 1.5 hours before the appointment he had people hunt me down and walk me to my car.
"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck