This might be one of the best articles for developers that I have come across in a long time. As soon as I started reading I knew it would be something that everyone could derive some benefit from. I think you will find this most interesting and will encourage you as you look forward to working consistently with SQLServer 2005. So rather than listen to me babble on here is Sureshkumar Ramakrishnan's article on what is new for T-SQL in 2005.
Note: you do need to sign up to have access to this site, but as I have mentioned a couple of times in this blog, it is well worth it.
Enjoy your day,