(SQL) Tip of the Day: Elastic Scale in Public Preview

Today’s (SQL) Tip…

Elastic Scale for Azure SQL Database allows developers to establish a “contract” that defines where different slices of data reside across a collection of database instances.  This enables applications to easily and automatically direct transactions to the appropriate database (shard) and perform queries that cross many or all shards using simple extensions to the ADO.NET programming model. Elastic Scale also enables coordinated data movement between shards to split or merge ranges of data among different databases and satisfy common scenarios such as pulling a busy tenant into its own shard. 

This will act as the replacement for Federations in SQL Azure. As such there is also a Federations Migration Utility being released during the preview that will allow you to move from Federations to Elastic Scale.