m02 - micrisoft azure db - azure open group

PauloRenato

CloudsolutionsArchitect

@Prenatos

AlexDerafshan

DataSolutionsArchitect

@CloudNeutron

AhmedFarag

CloudSolutionsArchitect

@Mr_AhmedFarag

http://aka.ms/AzureMeetup

Public,Global,SharedDatacentersMicrosoftAzureStack&CloudPlatformSystem

Security&

Managem

ent

PublicCloud

Platform

HybridOperationsSe

curity&

Managem

ent

HybridOperations

SoftwareAsaService• Office365• MicrosoftCRM• DynamicsAX• VSOnline• Etc.

2015 2016

HyperscaleInfrastructureistheenabler34RegionsWorldwide,26ONLINE…hugecapacityaroundtheworld…growingeveryyear

n 100+datacentersn Top2networksintheworldn 2.5xAWS,7xGoogleDCRegions

OperationalAnnounced/NotOperational

CentralUSIowa

WestUSCalifornia

EastUSVirginia

USGovVirginia

NorthCentralUSIllinois

USGovIowa

SouthCentralUSTexas

BrazilSouthSaoPauloState

WestEuropeNetherlands

ChinaNorth*Beijing

ChinaSouth*Shanghai

JapanEastTokyo,Saitama

JapanWestOsaka

IndiaSouthChennai

EastAsiaHongKong

SEAsiaSingapore

AustraliaSouthEastVictoria

AustraliaEastNewSouthWales

*Operatedby21Vianet

IndiaCentralPune

CanadaEastQuebecCity

CanadaCentralToronto

IndiaWestMumbai

GermanyNorthEastMagdeburg

GermanyCentralFrankfurt

UnitedKingdomRegions

NorthEuropeIreland

EastUS2Virginia

PlatformServices

InfrastructureServices

WebApps

MobileApps

APIManagement

APIApps

LogicApps

NotificationHubs

ContentDeliveryNetwork(CDN)

MediaServices

BizTalkServices

HybridConnections

ServiceBus

StorageQueues

HybridOperations

Backup

StorSimple

AzureSiteRecovery

Import/Export

SQLDatabase

DocumentDB

RedisCache

AzureSearch

StorageTables

DataWarehouse AzureAD

HealthMonitoring

ADPrivilegedIdentityManagement

OperationalAnalytics

CloudServices

Batch RemoteApp

ServiceFabric

VisualStudio

AppInsights

AzureSDK

VSOnline

DomainServices

HDInsight MachineLearning

StreamAnalytics

DataFactory

EventHubs

MobileEngagement

DataLake

IoT Hub

DataCatalog

Security&Management

AzureActiveDirectory

Multi-FactorAuthentication

Automation

Portal

KeyVault

Store/Marketplace

VMImageGallery&VMDepot

AzureADB2C

Scheduler

ApplicationbuiltonMicrosoftAzure

Data tier

App tier

Network tier AzureTrafficManager

AzureWebSites

AzureSearch

Streaming

AzureSQLDatabase

AzureDocumentDB Azure

HDInsight

AzureStorage

AzureWebRoles

AzureWebJobs

IoT

Azure SQL DBAzure SQL DWSQL Server 2016, Oracle, MySQL,… on VM

Analytics Platform System

Azure Data Lake

SQL Server 2016Analytics Platform System

SQL

Relational Non-relational

On-prem

ises

Clou

dMicrosoftDataPlatform&AzureSQLDB

• Manageallyourdatainamissioncritical,scalable,secureway

• Gaindeepinsightsacrossallofyourdatawithoutdatamovement

• Utilizeexistingskillsandinvestments

• Consistenton-premises,cloudandhybridexperiences

Federated query

Business intelligence

Machine learning & advanced analytics

Insights

AvailabilitySet StorageAccountStorageAccount

RedoStream

• BuiltforSaaSandEnterpriseapplications• Predictableperformance&pricing• 99.99%availabilitybuilt-in• Geo-replicationandrestoreservicesfordata

protection• Secureandcompliantforyoursensitivedata• FullycompatiblewithSQLServer2014databases

FullymanagedSQLdatabaseservicesoyoucanfocusonyourbusiness

SQLDatabaseServiceArelationaldatabaseasaservice,fullymanagedbyMicrosoft.Forcloud-designedappswhennear-zeroadministrationandenterprise-gradecapabilitiesarekey.PerfectforcloudarchitectsanddeveloperslookingforprogrammaticDBA-likefunctionality.

SQLDBV12

• Singletondatabases

• Elasticpooldatabase

WhatexactlyisaDTU?

%CPU

%READ %WRITE

%MEMORY

DTU representsasetofoperationsthataretypicalforanonlinetransactionprocessing(OLTP)request,andthenmeasuredbyhowmanytransactionscouldbecompletedpersecondunderfullyloadedconditions

B S0 S1 S2S3

P2

P11

P1

5 10 20 50 100 125 250

1750P4

500

P6

1000

SQLDatabaseservicetiers(singleDBmodel)

*The99.99%availabilitySLAdoesnotapplytotheexistingWebandBusinesseditions,whichwillcontinuetobesupportedat 99.9%availability.

BuiltFor

AvailableSLA

MaxStorage

BusinessContinuity

Security

DatabaseTransactionUnits(DTUs)

Point-in-timeRestore(“oops”Recovery)

BASIC PREMIUMSTANDARD

P1S0

Lighttransactionalworkloads Mediumtransactionalworkloads HeavyTransactionalWorkloads

99.99%*

2GB 250GB 500GB

Anypointwithin7days Anypointwithin14days Anypointwithin35days

Geo-restore,Activegeo-replication,uptofourreadablesecondarybackups

AlwaysEncrypted,TransparentDataEncryption,AzureActiveDirectoryauthentication,Auditing,row-levelsecurity,dynamicdatamasking

5

S1 S2 S3 P2 P4 P6 P11

10 20 50 100 125 250 500 1,000 1,750

1TB

Dashboardviewsofmetrics

Getin-depthviewsviaPortalandAPIs.Monitor

EncryptionType Type CustomerValue

Encryption-In-Transit TLS fromClienttoServerTLS=TransportLayerSecurity

Protectsdatabetweenclientandserveragainstsnoopingandman-in-the-middleattacks.SQLDBisphasingoutSSL3.0andTLS1.0infavorofTLS1.2.

Encryption-At-Rest TDEforSQLDBTDE=TransparentDataEncryption

Protects dataondisk.KeymanagementdonebyAzure.Makesiteasiertoobtaincompliance.

Encryption-End-To-End Client-sidecolumnencryptionforSQLDB(libraryavailablefordownload)

Dataprotectedend-to-endbutapplicationisawareofencryptedcolumns.UsedintheabsenceofdatamaskingandTDEforcompliancerelatedscenarios.

DatabaseFiles,Backups,TxLog,TempDB

CustomerData

In-Transit At-RestEnd-To-End

Encryptionoverview

AutomaticbackupFullbackupsweekly,differentbackupdaily,logbackupsevery5minutes

Dailyandweeklybackupsautomaticallyuploadedtogeo-redundantAzureStorage

Self-servicerestorePoint-in-timeuptoasecondgranularity

RESTAPI,PowerShell,orPortal

Createsanewdatabaseinthesamelogicalserver

TieredretentionpolicyBasic- 7daysStandard- 14daysPremium- 35days

Noadditionalcosttoretainbackups

Geo- replicated

Restorefrombackup

SQLDatabasebackupssabcp01bl21

AzureStorage

sabcp01bl21

Point-in-timerestore

Activegeo-replicationMissioncriticalbusinesscontinuity*

Upto4 secondaries

Service levels Basic, StandardandPremiumSelfService

Readable Secondaries Upto4

Regions available Any Azureregion

Replication Automatic,Asynchronous

Manageabilitytools RESTAPI,PowerShellorAzurePortal

Recovery TimeObjective(RTO)

<1hour

Recovery PointObjective <5mins

Failover On Demand

ActiveGeo-replicationnowavailablewithallservicetiersseeblog

Comingsoon:• T-SQLsupport• Switchbetweenprimaryandsecondary

HowisitdifferentfromVMs?

Bestfor…

TCObenefits

SQLServerinaVM AzureSQLDatabase

Scalability

Resources

“OneofAzure’smostpopularservices,SQLDatabasehas1Mdatabases.”ScottGuthrie,C+EExecutiveVicePresident,Microsoft

MigratefromothertopdatabasesWithfreetoolsfromMicrosoft

SQL Server

SQL Server migration assistant

Savesyoutimeandmoney

SimplifymigrationtoSQLServer

https://azure.microsoft.com/en-us/free/

Pricing:https://azure.microsoft.com/en-us/pricing/details/sql-database/?b=16.50

Services:https://azure.microsoft.com/en-us/services/sql-database/

Documentation:https://azure.microsoft.com/en-us/documentation/

Stackoverflow:http://stackoverflow.com/questions/tagged/sql-azure

https://aka.ms/azuremeetupsurvey