WIXLIB

17-18 March, 2018 · BeijingData 101 –Which DB, WhenJoe YongSr. Program ManagerMicrosoft Corp.

The world is changing

AIincreased by300% in 2017

Data will grow to44 ZB in 2020Today, 80%of organizationsadopt cloud-firststrategiesAI investmentincreased by300% in 2017

Organizations that harness data,cloud, and AI outperformNearly doubleoperating margin 100M in additionaloperating income

T H E Y R E LY O N A M O D E R N D ATA E S TAT E

Transform your businesswith a modern data estateHYBRIDCloudOn-premisesPrivate cloudOperational databasesData warehousesReason overData lakesany data, anywhereOperational databasesFlexibilityof choiceData warehousesSecurityData lakesand performance

Microsoft Data Products in AzureDATA SOURCESDATA MANAGEMENTStructuredDATA INSIGHTSOperational dataON-PREM CLOUDBusiness intelligencePower BIOLTPMOBILEAzureSQL DatabaseAzureDatabase forMySQLAzureCosmos DBAzureDatabase forPostgreSQLSQL ServerLOBUnstructuredData TYAdvanced Analytics & AISQL Server AnalysisServices and R built-inOpen SourceData warehousingSQL ServerData WarehouseData integrationERPSQL ServerReporting Servicesand Mobile BIAzure SQLData WarehouseLeast vulnerable data platform, with more certifications than any other cloud providerAny language, any platform, anywhere.NET JAVA Azure3rdAzureMachine LearningAzureStream AnalyticsAzureCognitive Services

SQL SERVER 2017 MOMENTUM 2millionDocker pulls

SQL SERVER 20171/10th the cost of OracleINDUSTRY-LEADING PERFORMANCE AND SECURITY NOW ON LINUX AND DOCKE RChoice of platformand languageOnly commercial DBwith AI built-inMost secureover the last 7 yearsIndustry-leadingperformanceEnd-to-end mobile BIon any device200PHPNode.jsPythonRuby#1 OLTP performance#1 DW performanceR160140120100806040200123456R and Python in-memory at massive scaleNative T-SQL scoring#1 price/performance 2,230Self-service BI per userT-SQLJavaC/C C#/VB.NETVulnerabilities (2010-2016)180 480 120MicrosoftTableauOracleA fraction of the costIn-memory across all workloadsPrivate cloudMost consistent data platformPublic cloud

New features inSQL Server 2017Support for graph data and queriesAdvanced Machine Learning with R & PythonNative T-SQL scoringAdaptive Query Processing andAutomatic Plan Correction

C LO U D - F I R S T A P P R O A C H B R E E D S FA S T E R I N N O VAT I O NContinuousenhancementsSQLSQLSQLSQL

Azure SQL DatabaseManaged InstanceSeamless and reliable migration at scaleLift and shift migration to the cloud withno code changesDatabaseMigration Ser viceMaximize current on-premiseslicense investments N E WAzure Hybrid Benefitfor SQL Ser ver

MOVING TO A ZURE IS E ASYW I T H S Q L D ATA B A S E A N DD ATA B A S E M I G R AT I O N S E R V I C E

A Z U R E S Q L D ATA B A S ETHE INTELLIGENT CLOUD DATABASE FOR APP DEVELOPERSLearns& adaptsRealize automaticperformanceimprovementsScaleson the flyChange performancelevels and storagewithout downtimeEnablesmulti-tenantSaaS appsWorks in yourenvironmentSecures& protectsEasily managemulti-tenant appsdatabase isolationDevelop your appwith the tools andplatforms you preferBuild security-enhancedapps with industryleading compliance

S Y S T E M S O F I N T E L L I G E N C E O N S Q L D ATA B A S EAZURE MACHINE LEARNINGAZURE SQL DATABASEINTELLIGENT RESPONSIVE APPSSQLRealtime scoringAzure Machine LearningWorkbench

GRAPH SUPPORT FORA Z U R E S Q L DATA B A S ENew relationships uncovered with graph data supportMBA,FinanceStatisticsAnalyze interconnected data and generate deeper insightsT-SQL extensions to support pattern matchingand graph ntureWorks

A Z U R E DATA B A S E F O RMYSQL AND POSTGRESQLWork in the DB of your choiceCreate with built-in high availabilitySet up in minutes, scale on the flySustain performance with adaptive improvementsRest easy with unparalleled securityStandard tier PRE VI E W

AZURE COSMOS DBGLOBALLY DISTRIBUTED, MULTI -MODEL DATABASE SERVICEMulti-model data with your favorite APIElastically scale storage and throughputMultiple, well-defined consistency levelsMillisecond latency at the 99th percentileIndustry-leading SLAsTable API

AZURE HDINSIGHTOpen source frameworks such as Apache Hadoop, Spark, KafkaEnterprise-grade security and monitoring with 99.9% SLANew HDI Interactive Query (Hive LLAP) GAOMS Integration PUB LI C PRE VIE W*IDCudy “The Bu neValue and TCO Advan ageApa he Hadp n he Cl ud w hAzu e HDIn gh ”

A Z U R E S Q L D ATA W A R E H O U S EPB scale with MPP and independent compute/storage scaleGrow, shrink, and pause in secondsRich Azure ecosystemOpen APIsGen 2, compute-optimized, for demanding workloads PREVIEWUnlimited column storage PREVIEW

T H E N E W A Z U R E D ATA FA C T O R YEasily model diverse data integration scenariosCreate & manage data integration acrosson-premises, cloud, & SaaSData movement as-a-service with30 connectors PRE VIE WEasily move your SQL Server Integration Services (SSIS)workloads to cloud PRE VI E W

POWER BI ANDPOWER BI REPORT SERVERPower BI reportsPower BI reportsGet started quicklySSRS reportsLive dashboardsNatural language queryCustomvisualizationsCustom visualizationsPower BIPower BI Report Server

MIC ROS OF TF ORLOBCRMSQL ServerYOURGraphMOD ERNImageHYBRIDSocialDATAES TATEIoTAzure Data ServicesEasiest lift and shiftwith no code changesIndustry leader 4 years in a row#1 TPC-H performanceT-SQL query over any dataOperational databasesOperational databases 70% fasterData warehousesData warehouses 2x the global reachData lakesData lakes 99.9% SLAAI built-in Most secure Lowest TCOReason overany data,anywhereFlexibilityof choiceSecurity andperformance

Microsoft Data Products in AzureDATA SOURCESDATA MANAGEMENTStructuredDATA INSIGHTSOperational dataON-PREM CLOUDBusiness intelligencePower BIOLTPMOBILEAzureSQL DatabaseAzureDatabase forMySQLAzureCosmos DBAzureDatabase forPostgreSQLSQL ServerLOBUnstructuredData TYAdvanced Analytics & AISQL Server AnalysisServices and R built-inOpen SourceData warehousingSQL ServerData WarehouseData integrationERPSQL ServerReporting Servicesand Mobile BIAzure SQLData WarehouseLeast vulnerable data platform, with more certifications than any other cloud providerAny language, any platform, anywhere.NET JAVA Azure3rdAzureMachine LearningAzureStream AnalyticsAzureCognitive Services

Which Database, When ?With Azure, you have many managed data storeoptions and you can use the right store for the jobFamiliarityBecause But not for SQLRelational storeOLTPTransactions, joins,structured data,familiar SQL queryQuickly changingdata schemasSQLRelational storeOLAPData Warehousing,structured data,familiar SQL QueryTransactionalworkloadsNoSQLNoSQL JSONdocument storeOpen SourceRelational StoreFlexible schema,Complex joins andfamiliar SQL query, lowaggregateslatencyEnterprise features,Open-source, existing high scaleMySQL resourcesworkloadsOpen SourceWhen you need .Relational StoreOpen-source, highlyextensible, existingPostgreSQLdeploymentsRead heavyoperations, quick tomarket (complexlearning curve fortraditional SQLusers)Use SQL DatabaseSQL DataWarehouseCosmo DBAzure Database forMySQLAzure Database forPostgreSQL

Data Warehouse Azure Cosmos DB Azure SQL Database SQL Server SQL Server Data Warehouse ON-PREM CLOUD Open Source Azure Database for MySQL Azure Database for PostgreSQL. 2 million Docker pulls SQL SERVER 2017 MOMENTUM. End- to-end mobile BI on any device Choice of platform and language Most secure over the last 7 years 0 20 40 60 80 100 120 140 .