Topics Global fully managed databaseasaservice built on SQL

Topics

Global, fully managed database-as-a-service built on SQL with near zero administration DB DB DB § § § § Built for Saa. S and enterprise applications Elastic database model for unpredictable workloads PREVIEW 99. 99% availability with global reach Geo-replication and restore services for data protection Secure, protected, compliant Fully compatible with SQL Server 2014 databases Easy development, simple self-service management

Database Service Tiers • • • *The 99. 99% availability SLA does not apply to Web and Business editions, which continue to be supported at 99. 9% availability. • • •

Saa. S provider customer end-user

Database-percustomer model leverages SQL Database strengths

Scalable cloud service, load balanced in normal use Cloud Service Catalog database holds mapping to customer databases Catalog Customer Catalog Cust 1 Cust 2 Cust 3 Cust N Customer Databases Scale out data tier by adding additional customer databases

1. End users connect to cloud service Cloud Service 2. Cloud service looks up customer in catalog 3. Cloud service routes directly to customer database Catalog Customer Catalog Cust 1 Cust 2 Cust 3 Cust N Customer Databases

Multi-database management Elastic Database Tooling § Define the set of databases that is the data tier of your application § Map customers (tenants) to databases Data-dependent routing § Route incoming requests to the correct database § Ensure correct routing if databases move § Cache routing information Generally Available now Easily accessible download from Nu. Get

Cloud Service Catalog Customer Catalog Cust 1 Cust 2 Cust 3 Cust N Customer Databases

database throughput unit Reads DTU Writes Compute Memory 0 4 01 3 2 0

• Basic Standard Premium P 3 P 2 B S 0 S 1 S 2 S 3 P 1

T-SQL: ALTER DATABASE Jacaranda. Jazz. Cub MODIFY (edition='Standard') • Basic Standard Power. Shell: Premium Set-Azure. Sql. Database -Resource. Group. Name wtpdemo -Server. Name wtpcustomers-sc -Database. Name Jacaranda. Jazz. Club -Requested. Service. Objective. Name Standard; P 3 REST API: PUT https: //management. azure. com/subscriptions/{subscription. Id}/resource. Groups/ {resource. Group. Name}/providers/microsoft. sql/servers/{server. Name}/databases/ {database. Name}? api-version=2014 -04 -01 Request body { } P 2 "location": “<location>”, P 1 "properties": { "requested. Service. Objective. Id": “<service. Objective. ID>“ } S 3 B S 0 S 1 S 2 https: //msdn. microsoft. com/en-us/library/azure/mt 163571. aspx

Cloud Service Catalog Customer Catalog Cust 1 Cust 2 Cust 3 3 Cust N Customer Databases

Cloud Service Catalog Customer Catalog 7 Cust 1 Cust 2 Cust 3 Cust 4 Cust 5 Cust 6 Cust Cus Cust 9 Cust 1 Cust 2 Cust 3 Cust 4 Cust 5 Cust 6 Cust 7 Cust 8 Customer Databases Cust N

PREVIEW • • Elastic databases, Elastic database pools Pooled resources leveraged by many databases Standard elastic pool provides 200 -1200* e. DTUs for up to 100* databases Elastic Standard databases can burst up to 100 e. DTUs (S 3 level) Max per-database burst level *Additional pricing tiers may be introduced, and the ranges and limits may be increased during the preview

Cloud Service Catalog Customer Catalog 7 Cust 1 Cust 2 Cust 3 Cust 4 Cust 5 Cust 6 Cust Cus Cust 9 Cust 1 Cust 2 Cust 3 Cust 4 Cust 5 Cust 6 Cust 7 Cust 8 Customer Databases Cust N

Cloud Service Catalog Customer Catalog 7 Cust 1 Cust 2 Cust 3 Cust 4 Cust 5 Cust 6 Cust Cus Cust 9 Cust 2 Cust 3 Cust 4 Cust 1 Cust 2 Cust 3 Cust 4 Cust 5 Cust 6 Cust 7 Cust 8 Customer Databases Cust N

Cloud Service Power. BI Catalog Customer Catalog Elastic Query Cust 1 Cust 2 Cust 3 Cust N Customer Databases

• Connect to a single SQL DB database using familiar SQL DB connection strings Elastic Database Query • Simple setup with T-SQL DDL • Transparent querying of many databases from a single database • Familiar programming experience with T-SQL, ADO. NET Linq, EF etc. • Use familiar development and BI tools to query across many databases • Designed for interactive querying

Cloud Service Catalog Customer Catalog T-SQL Cust 1 Cust 2 Cust 3 Cust N Customer Databases

• Apply changes or administrative operations to many Elastic Database Jobs databases • Use familiar T-SQL scripts to define jobs • Built-in automatic retries in case of transient failures • Tightly integrated with elastic pools in the new Azure Portal • Designed for batch processing