SQL Server 2005 is coming and Conchango are heavily involved with Microsoft's SQL Server Beta program so expect plenty of posts here in the run up to release - hopefully next summer.
My first article on SQL Server 2005 (more accurately Integration Services) can be found here on SQLIS.com. I'll have more of these coming in the months to follow!
cheers
Jamie