Elastic Scale for Azure SQL Database – Overview

Abstract: Now in Preview, Elastic Scale for Azure DB offers a set of features that make it easier to build and manage a sharded data tier for cloud applications that can grow and shrink database capacity on demand. Delivering on this the key promises of cloud computing used to be challenging in particular for the database tier. Over the last few years, the industry has converged on sharding as a well-established design pattern for cloud applications. Elastic Scale adopts the general sharding pattern and significantly simplifies building and managing sharded applications for Azure SQL DB.

In this session, we are going to explore workloads that are a natural fit for sharding and Azure SQL DB Elastic Scale. Workloads discussed in depth include multi-tenancy as well as telemetry and sensor data processing. We will use capabilities from the Elastic Scale preview to make developing, scaling and managing sharded applications on Azure SQL DB much easier. The capabilities discussed in the session include shard management, data dependent routing, querying across shards and elastic capacity at the data tier in Azure SQL DB.

Objectives: 1. Identify workloads that will benefit from Elastic Scale. 2. Guide you on how to apply sharding to your data tiers.

Bill Emmert

William Emmert, Technical Director/Technology Architect, Microsoft Technology Center, Microsoft Corporation
Technical Director and SQL\BI Architect in the Philadelphia Microsoft Technology Center (MTC) in Malvern, PA. He started his career at Microsoft in 1998 in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, Bill worked on the SQL Server product group for 1 year as a member of the SQL Server Customer Advisory Team (SQLCAT) returning back to consulting in 2008. In 2010 he joined the New York MTC as a SQL Architect before taking on his current roles in the Philadelphia MTC in 2011.

Bill has worked in the computer industry for 28 years with experiences in mainframe software support & development, network architecture and administration, client server application development, project management, consulting, IT management and database administration, development and architecture.

He has a bachelor’s of Business Administration in Marketing from Adelphi University (NY) and a Master’s of Science in Information Systems from Penn State University (PA).