This chapter from Keith Brown's book may fall into the required-reading-for-developers category. 

Terminal services, Run As..., modifying the background and title bar of windows running as a different user, enabling debugging as a non-admin, a discussion on where the difficulties lie with building code that can execute in non-privileged environments, etc.

Thanks to Bliz and the founder of the Paul-tini...