GETTING STARTED WITH AZURE SQL DB

Warner Chaves

SQL MCM / MVP

SQLTurbo.com

Pythian.com

Bio• SQL Server DBA for 10 years.

• Previously an L3 DBA at HP, now a Principal Consultant at Pythian in

Ottawa Ontario.

• SQL Server MCM and MVP.

• Twitter: @warchav

• Email: warner@sqlturbo.com

• Blog: sqlturbo.com

• Company site: pythian.com

Agenda

• GOAL: provide an introduction and overview of the Azure

SQL Database service.

• We’ll cover:

How to sign up.

Navigating the portal.

The different service levels.

New features coming cloud first.

Signing up!• Go here:• http://azure.microsoft.com/en-us/pricing/free-trial/

• You’ll need to put in your info but you won’t get charged until after the trial month if you don’t cancel.

What is it?

• The SQL database as a service offering on Azure (OLTP).

• Fully managed by MS as part of Azure.

• It’s not a full instance. Many features that you’re used to

don’t exist because it’s fully managed.

• Used to be 2 size based tiers, now it’s 3 Service Level

based tiers.

Before and After

BASIC

S0 S1 S2 S3

P1 P2 P3

• Before: Web and Business. Based purely on size.• Now: 3 service tiers and sub tiers.

Basic• Size Limit: 2GB.• Point-in-time Restore: 7 days.• DR: Geo-Restore to another Azure region.• Auditing allowed.• Performance: 5 DTU.

Standard• Size Limit: 250GB.• Point-in-time Restore: 14 days.• DR: Geo-Restore, Standard

Geo-replication.• Auditing allowed.• Performance: 10-20-50-100

DTU.

S0 10 DTU

S1 20 DTU

S2 50 DTU

S3 100 DTU

Premium• Size Limit: 500GB.• Point-in-time Restore: 35 days.• DR: Geo-Restore, Standard or

Active Geo-replication.• Partitioning.• Columnstores.• Auditing allowed.• Performance: 100-200-1000 DTU.

P1 100 DTU

P2 200 DTU

P3 1000 DTU

Standard vs Active Geo-Replication• Standard

• RTO < 2h• RPO < 30m

• Active• RTO < 1h• RPO < 5m

• Active provides failover control.• Active provides up to 4 read-only replicas.

Official Pricing List• For the official published price please check:• http://azure.microsoft.com/en-us/pricing/details/sql-databa

se/

• The price can change depending on your specific agreements with Microsoft.

Demo: Walkthrough Azure Portal and SSMS experience

Demo: Point-in-Time Restore

DTU?

• Database throughput unit.

• A comparison unit of integrated database performance.

• Blend of CPU + Data IO + Log IO + Memory.

• Based on an internal OLTP benchmark from the Azure

team.

Tier DTUsTier DTU Max Threads Max

SessionsBenchmark Throughput

Basic 5 30 300 16600 trx/hour

S0 10 60 600 521 trx/min

S1 20 90 900 934 trx/min

S2 50 120 1200 2570 trx/min

P1 100 200 2400 105 trx/sec

P2 200 400 4800 228 trx/sec

P3 1000 1600 19200 735 trx/sec

Demo: Basic vs S1 comparison

Cloud-first

• MS is now deploying features on Azure SQL that are NOT

in the “box” version of SQL Server:

Dynamic Data Masking.

Row-Level Security.

ALTER COLUMN ONLINE.

TRUNCATE PARTITION.

Upcoming: SQL Query Store.

Demo: Dynamic Data Masking

QA?