azure sql database for the earthed dba

Grant Fritchey | www.ScaryDBA.com

www.ScaryDBA.com

Azure SQL Database for the Earthed DBA

Grant Fritchey – Red Gate Software


Goal

Understand the infrastructure and offerings available within Azure SQL Database

Learn how to migrate and manage a database within Azure SQL Database

Understand the trade-offs and shortcomings of Azure SQL Database

2


Get in touch

scarydba.com

[email protected]

@gfritchey

Grant Fritchey


Agenda» Purpose of Azure SQL Database» Infrastructure in Support of the Purpose» Things it does» What it Doesn’t Do» Managing databases through the Portal» Putting Management Studio to Work» Migrate a Database» Backup & Restore» Monitoring & Tuning» Maintenance» Powershell All The Things» Recommendations

4

Grant Fritchey | www.ScaryDBA.com 5


ResourcePooling

Elastic Databases

HighAvailability

Disaster Recovery

KnownPlatform

Near-zero Maintenance


Relational

Database

Management


ResourceGroup

8

“Server”

3 ReplicaDatabases

“Database(s)”

Elastic Database Pools

Geo-Location

SQLDataWarehouse

“Replication”


SLA http://bit.ly/1TnZwOn

Connection99.99%

Credit<99.99%: 10%

<99%: 25%


Single DB

Max Size: 2gb – 1tb

DTU: 5 - 1750

Concurrent Requests: 30 – 2,400

Concurrent Logins:

30 – 2,400

Max Sessions:

300 –32,000


Elastic Pools (eDTU)

Max Size: 2gb –500gb

DTU: 5 - 1000

Concurrent Requests:

200 – 2,400

Max Sessions:

2,400 –32,000

eDTURange Per

Pool: 100 – 1,500


T-SQL RDBMS SSMS

VS PowerShellMost things

database related


Partial Support (Dec 2014)

CREATE DATABASE

CREATE FUNCTION

KILL

CREATE LOGIN

CREATE PROCEDURE

CREATE TABLE

CREATE USER

CREATE VIEW

13


Unsupported Features

Server level ANYTHING

Cross database ANYTHING

Database Mail

Distributed Transactions

HA/DR Processes

SQL Agent

Linked Servers

Trace/Profiler

Traceflags

14

Complete list available at: http://bit.ly/1OX3Kss


AZURE PORTAL

15


Azure Portal

16


SQL SERVER MANAGEMENT STUDIO

17


SQL Server Management Studio

18


MIGRATE A DATABASE

19


Migrate a Database

20


DISASTER RECOVERY

21


Restore Basic Any point in last 7 days

Standard 14 days

Premium 35 days


DR BasicGeo-restore, any Azure Region

StandardStandard Geo-Replication, offline secondary

PremiumActive Geo-Replication, up to 4 readable secondary


Restore & DR

24


MONITORING & TUNING

26


MAINTENANCE

28


This slide intentionally blank

29


Automation

Azure Automation

Elastic Pools

Azure Scheduler

Azure Batch Service

Azure Logic App

SQL Agent (VM or local)

3rd Party (tons)


POWERSHELL

32


Use Your MSDN Account to Play

Understand the SLA

Understand DTU

Learn PowerShell

Continue DB Maintenance


Goal

Understand the infrastructure and offerings available within Azure SQL Database

Learn how to migrate and manage a database within Azure SQL Database

Understand the trade-offs and shortcomings of Azure SQL Database

34


Get in touch

scarydba.com

[email protected]

@gfritchey

Grant Fritchey


Questions?

36

azure sql database for the earthed dba

Data & Analytics