Gordon Mangione showed off a lot of features for Yukon in the key note this morning. DTS has been completeley rewriten and integrated into the Workbench (SQL Ent Manager) No more modal windows in the work bench. All tasks in the workbench are scriptable. Lots of other features were demod as well.
I attended the session hosted by Graz on SQL Profiler. I need to use this tool more help me solve problems.
The folks from SQL Litespeed have a really awesome product to help solve backup issues. I will be trying this out when I get back into the office.