SQL Server in the Cloud

SQW02 Near Unlimited Scalability with SQL Azure Federations


9:15am - 10:30am

Level: Intermediate

Arie Jones

Arie Jones

Director of Emerging Technologies

Perpetual Technologies, Inc.

Putting large database workloads and multi-tenant environments in the cloud is not without its complications. SQL Azure size, configuration, and performance restrictions still require you to hedge your bets when looking at moving to the cloud. With the release of SQL Azure Federations, Microsoft offers you a native SQL Azure based option to possibly unlimited elastic scalability of your cloud based solutions. In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, what developers need to know, and show you real world solutions using SQL Azure Federations to overcome difficult scenarios.

You will learn:

  • How to use Azure Federations to overcome unique challenges of performance, scalability, and security in a cloud based environment.
  • How to structure your Azure SQL Database solutions in order to take full advantage of the Federations platform
  • The underlying mechanics of the Azure Federations platform so you can intelligently determine whether it is a possible fit for your cloud based solutions