BT

SQL Azure To Get Higher DB Size Limit, Federation

by Roopesh Shenoy on Oct 21, 2011 |

 At SQL PASS Summit 2011, Microsoft announced a number of upcoming improvements to SQL Azure including larger databases, Federation, improved management portal, better collation support and more; all to be available by the end of 2011.

The new features that were announced are -

  • Higher database size limit for individual databases - 150 GB instead of the current limit of 50 GB
  • Federation – to allow easy scale out of data to multiple databases using the sharding pattern
  • Improved management portal with new features for easy monitoring of databases, drill-down into schemas, query plans, spatial data, indexes/keys and query performance statistics
  • Expanded support for user-controlled collations (SQL Azure Database currently does not allow setting the collation at the server or database level)

Some of these features, such as Federation, are already available in CTP currently. Microsoft also announced new CTP releases for SQL Azure Reporting and SQL Azure Data Sync. You can read more details about the features introduced in these CTPs on InfoQ and in this blog post.

SQL Azure is Microsoft’s relational database-as-a-service offering and a part of the Windows Azure platform. Although there are a lot of similarities between SQL Server and SQL Azure, the latter has been written ground up to work in the cloud and has features such as high availability and fault tolerance along with triple replication of data.

Professional Association for SQL Server (PASS) Summit is a conference presented for the SQL Server Community. This year’s summit saw a lot of interesting tracks especially about SQL Azure, which can be accessed here and here.  

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT