From what I have read T-SQL in SS 2012 has greatly improved programmability and debugging features. When the DVD arrives from my MSDN subscription I am looking forward to trying them out. Debugging T-SQL has always been kind of a PITA.

I also read that there are some nice new integration features with Visual Studio.