110 th the cost of Oracle SQL SERVER
- Slides: 22
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 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 On Linux and mac. OS (server & tools)
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 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
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
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 Analytics Value
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
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
- Pl sql unit testing
- Microsoft sql server migration assistant for oracle
- Où se trouve le numéro d'affiliation mutuelle vignette ?
- 100 011
- Sql server cost threshold for parallelism
- Oracle procedural language extensions to sql
- Oracle pl/sql create table
- Performance tuning in oracle tutorial
- Oracle big data sql
- Oracle sql command line
- Oracle apex sql injection
- Difference between pl/sql and sql
- Oracle developer tools
- Oracle sql tuning tips
- Toad 설치
- Mssql regexp_like
- Oracle internet application server
- Oracle database server architecture
- Communications application server
- Oracle report server
- Mts explorer
- Azure sql server advanced data security
- Sql server virtualization