Speaking of SQL Profiler brought this to mind. The number one feature that brings a smile to every DBA's face:
GRANT ALTER TRACE TO [somedev]
No longer do you have to listen to developers ask “make me SA so I can run the trace”. Actually, brings a smile to devs too, no longer do they have to beg for it. Just brings the gate over to a more granular permission level. You still do have to ask for ALTER TRACE now…