Many times I am asked “When I reach the allocated level (1 GB or 10 GB) in SQL Azure, what happens?”

The answer: only SELECTs and DELETEs will be supported. UPDATEs and INSERTs will throw an error.

Any workaround? yes.

Because of above size constraints, one of the recommendations is to partition the data across databases. Creating multiple databases will allow you take maximum advantage of the computing power of multiple nodes. The biggest value in the Azure model is the elasticity of being able to create as many databases as you need, when your demand peaks and delete/drop the databases as your demand subsides.

Similar Posts:

• Windows Azure 12/12/11 Announcement
• Register For BUILD Conference
• Improved Developer Experience, Interoperability, and Scalability on Windows Azure
• SQL Azure Announcements In PDC10
• ASP.NET 2.0 – Web Site vs Web Application project

Tags: SQL Azure