How to open .ccproj in VS2010?
The link above is good but points to a specific version of the SDK. As such, it is subject to obsolescence. The following seems to be a generic page for the Azure SDK, which should not be bind to a specific version:
http://www.microsoft.com/windowsazure/sdk/
You can get from there a link to the latest download (button "Get the SDK").