The CTP 1 for SQL Server Denali is now available to download at the below link:
Link to Download: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Things that excite me about this upcoming release is:
Download the CTP try it out and provide feedback on http://connect.microsoft.com