A short while ago, a great whitepaper was published, that explains the differences between Windows Azure SQL Database service and SQL Server. The whitepaper can be obtained here and it drills into the architecture and performance evaluation techniques for both platforms… it also outlines core scenarios associated with different deployments. A good read!