110 th the cost of Oracle SQL SERVER

  • Slides: 22
Download presentation

1/10 th the cost of Oracle SQL SERVER 2017 INDUSTRY-LEADING PERFORMANCE AND SECURITY NOW

1/10 th the cost of Oracle SQL SERVER 2017 INDUSTRY-LEADING PERFORMANCE AND SECURITY NOW ON LINUX AND DOCKER Choice of platform and language Most secure over the last 7 years Industry-leading performance Only commercial DB with AI built-in End-to-end mobile BI on any device 200 $2, 230 #1 TPC-H performance 1 TB, 10 TB, 30 TB 120 100 80 + T-SQL 60 40 20 $120 Microsoft N A L HA P SA 2 re SQ DB tg Po s L cle M IB ra y. S M Se rv L SQ #1 price/performance $480 0 Q #1 TPC-E performance O PHP Node. js Python Ruby 140 er T-SQL Java C/C++ C#/VB. NET R 160 Self-service BI per user 1/10 Vulnerabilities (2010 -2016) 180 R and Python + in-memory at massive scale Tableau Oracle A fraction of the cost In-memory across all workloads Private cloud Most consistent data platform Public cloud

FLEXIBLE, RELIABLE DATA MANAGEMENT SQL Server on the platform of your choice Windows Support

FLEXIBLE, RELIABLE DATA MANAGEMENT SQL Server on the platform of your choice Windows Support for Red. Hat Enterprise Linux (RHEL), Ubuntu, and SUSE Enterprise Linux (SLES) Linux and Windows Docker containers Windows Server / Windows 10 Package-based installation: Yum Install, Apt-Get, and Zypper Choice of platform and language Linux/Windows container Linux

Performance and scale Cross-OS compatibility Same app code runs across platforms Native user experience

Performance and scale Cross-OS compatibility Same app code runs across platforms Native user experience On Linux and mac. OS (server & tools)

System Resource & Latency Sensitive Code Paths Everything else DB Engine IS AS RS

System Resource & Latency Sensitive Code Paths Everything else DB Engine IS AS RS SQL Platform Abstraction Layer (SQLPAL) Windows Host Ext. Linux Host Extension Windows Linux SQL Platform Abstraction Layer (SQLPAL) Win 32 -like APIs SQL OS API SQL OS v 2 Host Extension mapping to OS system calls (IO, Memory, CPU scheduling)

MISSION CRITICAL AVAILABILITY ON ANY PLATFORM Always On cross-platform capabilities HA and DR for

MISSION CRITICAL AVAILABILITY ON ANY PLATFORM Always On cross-platform capabilities HA and DR for Linux and Windows High availability Support for clusterless Availability Groups Ultimate HA with OS-level redundancy and low-downtime migration Load balancing of readable secondaries Primary Sync/Async Replicas Linux Cross-operating system Sync/Async Replicas Choice of platform and language

Push code Build Test Deploy

Push code Build Test Deploy

Development Create dev/test environments Deploy CD Scheduled tests Check-in tests CI Pre. Create production

Development Create dev/test environments Deploy CD Scheduled tests Check-in tests CI Pre. Create production pre-prod tests environment t n i r p S shing if ni Push change Consume dev/test environment

Dependency Update Create dev/test environments Development

Dependency Update Create dev/test environments Development

The power to query over any type of data Graph data support Eric Mears

The power to query over any type of data Graph data support Eric Mears Bring graph data support to your relational data to store and analyze new types of relationships NEW* Michelle Burns Andy Smith Mary Jones Quarterly business review Denny Usher Bill Brown Rachel Hogan Product dev project IT assessment Managers Associates Projects HR team can determine which staff are working on which projects

Advanced Analytics Data Predictive & Prescriptive Analytics Decisions Action Business Intelligence Descriptive & Diagnostic

Advanced Analytics Data Predictive & Prescriptive Analytics Decisions Action Business Intelligence Descriptive & Diagnostic Analytics Value

Intelligent workloads Intelligent apps need to be able to: Ingest data in real-time Query

Intelligent workloads Intelligent apps need to be able to: Ingest data in real-time Query across historical and real-time data Analyze patterns and make predictions Analyze global trends: Could lead to accident Query across historical data: They’ve been hot for 4 hours! Ingest real-time train data: Brakes are hot!

ANNOUNCING SPECIAL PRICING FOR SQL SERVER ON LINUX AND RED HAT ENTERPRISE LINUX

ANNOUNCING SPECIAL PRICING FOR SQL SERVER ON LINUX AND RED HAT ENTERPRISE LINUX

New capabilities for data integration in the cloud Wednesday, September 26 11: 00 –

New capabilities for data integration in the cloud Wednesday, September 26 11: 00 – 12: 15 BRK 2254 How to build ML apps using R and Python Thursday, September 28 2: 15 -3: 30 BRK 3298 Modernize your on-premises applications with SQL Database Managed Instances Azure Cosmos DB: The globally distributed, multi-model database Wednesday, September 27 10: 45 - 12: 00 BRK 2217 Tuesday, September 26 10: 45 - 12: 00 BRK 3086 Dining on data: Consume and query petabytes of data with Azure SQL Data Warehouse Microsoft. com/SQLServer 2017 Tuesday, September 26 9: 00 -10: 15 BRK 3242 https: //github. com/twright-msft/mssql-test-scripts https: //github. com/twright-msft/contoso-u https: //github. com/tobiassql/samples aka. ms/azuredataservices