Several folks on our team have done a great job in blogging about features in SQL Server 2008 "Katmai" betas as they explore this exciting new release, but sometimes you find a gem, a diamond in the rough.  For me that diamond in the myriad of the internet "rough" is Ravi S.Maniam's Blog which provides some sample scripts with great depth in explaining many upcoming features of SQL Server 2008.  You can download a copy of the SQL Server 2008 July CTP here to try out his samples.