SQL Server 2005 TSQL Enhancements - time for me to learn them!

An area of SQL Server 2005 I have pretty much avoided so far is the enhancements we have made to TSQL. Now - my history is that before joining Microsoft many years back I was a Sybase TSQL developer - so in theory this should be fine. The reality is I have pretty much managed to avoid TSQL development (with a lot of whiteboarding) for the last 3 or 4 years so it fell low on my list of things to look at with the betas. Well - I am presenting this topic start of September to folks who will be MUCH more current on TSQL than I am.So - now is my time to learn this stuff! In looking around for a good place to start (other than the docs which are fine) I came across this article https://msdn.microsoft.com/sql/default.aspx?pull=/msdnmag/issues/04/02/tsqlinyukon/toc.asp. I would highly recommend it as your first read in this area.