Your Hybrid Cloud world Cloud OnPremises Common Identity
Your Hybrid Cloud world Cloud On-Premises
Common Identity Integrated Management and Security Consistent Data Platform Unified Development and Dev. Ops
Common Identity Integrated Management and Security Consistent Data Platform Unified Development and Dev. Ops
Common Identity Integrated Management and Security Consistent Data Platform Unified Development and Dev. Ops
Consistent data platform Seamlessly distribute data between cloud and onpremises, and enrich with analytics and deep learning On-premises to the cloud Most secure and proven database across all environments Paa. S Azure SQL Database Azure SQL Data Warehouse Iaa. S • Common tools for development and management • Common T-SQL surface area • Simple cloud migration • SQL Server in Azure VM SQL Server (DW) in Azure VM On-premises Single vendor for support SQL Server (OLTP) SQL Server (DW) Reference Architecture
THE MODERN DATA ESTATE HYBRID Cloud On-premises Private cloud Operational databases Data warehouses Data lakes Reason over any data, anywhere Data lakes Flexibility of choice Security and privacy
THE MODERN DATA ESTATE Microsoft’s on-premises solution SQL Server 1/10 th the cost of Oracle Operational databases Industry leader 4 years in a row Data warehouses #1 TPC-H performance Data lakes T-SQL query over any data Flexibility of choice Security and privacy Only commercial DB with AI built-in Any language, any platform, anywhere Most secure over last 7 years R JAVA MULTI Vulnerabilities Reason over any data, anywhere 150 100 50 0 SQL Server
INSIGHTS TO AGENTS 10 X FASTER Fastest in-memory technology CHALLENGE Real estate data business struggled to meet customer expectations for on-demand services on 150 M+ real estate listings IMPACT Accelerated service updates from 24 hours to <3 hours Before In-memory Columnstore 101001010 1000010 Storage costs slashed by compressing data 64% ETL 1 24 hours <3 hours 12. 5 TB 4. 5 TB Fast reads Data compression No ETL required
VALUE THROUGH POLICY CUSTOMIZATION Big Data insights with Poly. Base CHALLENGE Car insurance company needed quick access to IOT sensor data to create tailored policy rates IMPACT Customized policy rates based on real time sensor data analysis Increased revenues based on customer satisfaction and differentiated offering Before Big Data with Poly. Base $$$ $$ Car sensor data $$$ T-SQL $$$ Poly. Base $$$ Nearly uniform policy rates $ Insurance policy data Customized policies incentivize safer driving
COMPLEX FRAUD DETECTION IN REAL TIME The power of in-memory and graph data combined CHALLENGE Bank lost millions to fraud and is unable to detect sophisticated offenders due to complex web of covered tracks Before IMPACT Real-time graph analysis coupled with inmemory analytics reveals veiled identities and complex networks Graph support Graph data model Intuitive visualizations illustrate clear outcomes and insights Cannot track complex relationships In-memory OLTP Mobile reporting
ENCRYPT DATA AT REST AND IN MOTION Always Encrypted Client side Search for single customer record Query Result set with unencrypted data Sensitive data remains encrypted inside SQL Server Enhanced SQL Server Library Data set Customer Credit card # Exp. Denny Usher 0 x 7 ff 654 ae 6 d 4949 -8003 -8473 -1930 5/17 Column master key Server side CIPHERTEXT Customer Credit card # Exp. Tim Irish 1 x 7 fg 655 se 2 e 4839 -2939 -1919 -3987 7/19 Denny Usher 0 x 7 ff 654 ae 6 d 4949 -8003 -8473 -1930 5/17 Alicia Hodge 0 y 8 fj 754 ea 2 c 9000 -4899 -1600 -1324 4/18 Column encryption key
THE MODERN DATA ESTATE HYBRID Cloud On-premises Private cloud Operational databases Data warehouses Data lakes Reason over any data, anywhere Data lakes Flexibility of choice Security and privacy
THE MODERN DATA ESTATE Microsoft’s cloud solution Azure data services Operational databases 70% faster than competition Azure SQL Database Data warehouses Industry leading SLAs Azure Cosmos DB 2 x the global reach Azure SQL Data Warehouse Data lakes 99. 9% SLA Azure Data Lake, HDInsight Reason over any data, anywhere Flexibility of choice Security and privacy AI built-in Any language, any platform, anywhere More certifications than any other cloud R JAVA
CLOUD-FIRST APPROACH BREEDS INNOVATION New innovations SQL SQL Across customer base Continuous enhancements SQL
Azure SQL Database The intelligent relational cloud database service Learns & adapts Scales on the fly Realize automatic performance improvements from continuous assessments Change service tiers, performance levels, and storage dynamically with minimal downtime. Redefines multi-tenancy Works in your environment Easily manage and monitor multitenant apps, and benefit from database isolation Develop your app and connect to SQL Database with the tools and platforms you prefer Secures & protects Build securityenhanced, highly compliant apps with built-in protection and intelligent Threat Detection
SINGLE SIGN-ON FOR 10 M USERS Flexible data model for unstructured data CHALLENGE Customers encountered multiple sign-in prompts between disjointed Citrix websites, impairing the user experience Before Cosmos DB IMPACT Streamlined access with >99. 99 percent availability and enterprise-grade SLAs Global distribution to Azure regions brings data to the customer for guaranteed low latency at any scale Single sign-on Log-in required Multiple sign-in prompts and low responsiveness Turnkey global distribution Infinite scale Enterprise-grade SLAs Automatic indexing Improved access for 10 M users
GREATER SCALE AND PERFORMANCE FOR LESS Lower costs with improved performance for high-traffic website CHALLENGE Technology news website faced performance problems due to spikes in user traffic, requiring resource-consuming external support Before IMPACT 45% lower costs with simplified management and faster webpage loads Azure platform Performance Azure Database for My. SQL scales on the fly without downtime for 2 M monthly users Management On-demand scalability Managed environment 2 M monthly users Performance challenges at scale Lower TCO Greater scalability and performance
INTELLIGENT WATER UTILIZATION SAVES $5. 2 M Power of Advanced Analytics and AI CHALLENGE Cruise line struggled to accurately predict water usage onboard ships, leading to costly water storage or production IMPACT Advanced Analytics model optimizes onboard water storage, saving $200 k per ship annually Before Simple calculations Cortana intelligence Diverse data sources Historical and real-time data analysis enables predictive maintenance Advanced Analytics Machine learning Intelligence APIs Inaccurate water estimations Reduced storage and production costs
THE COMPLETE MODERN DATA ESTATE HYBRID Cloud On-premises Private cloud Operational databases Data warehouses Data lakes Reason over any data, anywhere Data lakes Flexibility of choice Security and privacy
THE MODERN DATA ESTATE Microsoft’s hybrid solution Hybrid Operational databases Data warehouses Data lakes Easiest lift & shift with no code changes Stretch on-premises data to cloud Cloud DR and backup Hybrid use rights for best TCO Reason over any data, anywhere Flexibility of choice Security and privacy Insight across your data estate Any language, any platform, anywhere VNet isolation JAVA MULTI
OPTIMIZE WITH A MODERN DATA PLATFORM Azure Database Services Easy lift and shift to the cloud Existing deployments Running on: SQL Server 2008+ Azure SQL Database Azure Cosmos DB Elastic scale without downtime Turnkey global distribution Threat Detection, self-tuning APIs for Mongo. DB, Graph, Tables Azure Database for My. SQL + Postgre. SQL Azure SQL Data Warehouse Elastic scale without downtime Threat detection, pause compute Elastic scale without downtime My. SQL + Postgre. SQL compatibility Oracle 9. 3+ My. SQL Server 2017 Modernize to SQL Server 2017 Linux or Windows Intelligence built-in (R, Python) Unmatched performance Mobile BI Most secure Leading TCO
Lift and shift SQL Server DBs without app redesign SQL Agent, 3 part name, CLR, Log shipping, Transaction Replication, CDC, Service broker Ensure security and Azure VNet isolation Move your entire fleet at once Database Migration Services (DMS) Use existing SQL Server licenses VNet
T H E M I C R O S O F T LOB CRM Graph Image Hybrid SQL Server O F F E R I N G Social Io. T Azure Data Services Easiest lift and shift with no code changes Industry leader 4 years in a row Operational databases 70% faster #1 TPC-H performance Data warehouses 2 x the global reach T-SQL query over any data Data lakes 99. 9% SLA AI built-in | Most secure | Lowest TCO Reason over any data, anywhere Flexibility of choice Security and privacy
Empower today’s innovators to unleash the power of data and reimagine possibilities that will improve our world
https: //myignite. microsoft. com/evaluations https: //aka. ms/ignite. mobileapp
- Slides: 28