SQL Server 2005 Resources
There are some great SQL Server 2005 webcasts appearing on http://www.microsoft.com/events/series/technetsqlserver2005.mspx which can be downloaded for offline viewing (always good when you're on the road etc.). I also like the SSIS MSDN resource http://msdn.microsoft.com/SQL/sqlwarehouse/SSIS/default.aspx and the new MSDN SQL Server Forums http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19 which covers pretty much every feature. And finally...there are some good whitepapers / articles appearing on the TechNet site http://www.microsoft.com/technet/prodtechnol/sql/2005/default.mspx. I won't mention SQL-related blogs because there are so many but I do have a few favourites which I mentioned in a previous post.
I'd also like to quickly mention the new NUMA (Non Uniform Memory Access) architecture support in SQL Server 2005, in particular the ability to configure Soft NUMA - I'm half-way through a good article at the moment so I'll post some info here later - Thanks to Ken England and Slava Oks.