Comments on OnPreInit, Where IT Starts!: SQL Azure 10GB Limit: Implications & Workarounds

50GB Size Limit for SQL Azure. While this is an o...

2011-04-15T02:25:21.347-04:00

50GB Size Limit for SQL Azure.

While this is an old post, a reminder to all that SQL Azure has a 50GB limit for a single RDBMS database now, not 10GB anymore. This will grow over time. However, I also now from conversations, that some people confuse SQL Azure DB size with Windows Azure storage account sizes (storage is equivalent to AWS S3). Storage on Windows Azure is essentially unlimited. And, to put in perspective for SQL Azure, <50GB of a SQL Azure database describes likely about 95% of all SQL Server exising on-premise databases in the world.

-Greg Leake
Microsoft Corporation

Please see latest info on msdn.microsoft.com for VM sizes, storage account sizes, SQL Azure sizes, rates, etc.

The following posts cover the limited options you ...

2009-08-17T15:12:59.500-04:00

The following posts cover the limited options you have for importing database content into SQL Azure:

On Using SSIS and ST.EXE:
http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/dd375420-bd55-425f-b400-d8dad734a13c

On importing into Table Storage:
http://social.msdn.microsoft.com/Forums/en-US/windowsazure/thread/7969f6c5-c74d-4b5d-a572-8a1052adf176

Some background on TDS:
http://www.azurejournal.com/2009/05/sql-data-services-your-database-in-the-cloud/

EC2 offers more attractive options around physically shipping data; expect to see advancements along these lines when the size limitations around SDS are eased.

Any word or insights on how to migrate data to SQL...

2009-08-17T14:02:53.325-04:00

Any word or insights on how to migrate data to SQL Azure?

A great summary of what people are doing with Azur...

2009-08-13T10:26:47.886-04:00

A great summary of what people are doing with Azure (in the UK) was just recently posted:
http://blogs.msdn.com/ukisvdev/archive/2009/08/12/people-are-doing-some-interesting-things-with-windows-azure-in-the-uk.aspx

Hey Nariman... Do you have any success stories to ...

2009-08-03T12:35:14.853-04:00

Hey Nariman... Do you have any success stories to share?? Any sites worth showcasing that have used either Azure or EC2 to deliver the on-demand-scalability-at-pennies-gb vision?