Below is a collection of a number of white papers on cloud-related to the Windows Azure Services:
For more whitepapers, see the Windows Azure Home at http://www.microsoft.com/windowsazure/whitepapers/default.aspx
If your considering the use of the cloud then there is nothing better to help develop your ideas or possibilities, case studies and scenarios are a great way to bring together a problem and a solution in context, while pulling together all the relevant guidance.
Here’s a quick tour of the scenarios that Microsoft Technet have so far …
See the Public Cloud Scenarios Hub.
See the Private Cloud Scenarios Hub.
I've got some use-cases here as well: blogs.msdn.com/.../windows-azure-and-sql-azure-use-cases.aspx