際際滷

際際滷Share a Scribd company logo

SQL_Server_2016_Everything_Built-In_Datasheet_EN_US

Rolando Rangel
Rolando Rangel

This document contains graphics and information published by Gartner about Microsoft SQL Server 2016. The graphics should be evaluated in the context of the full Gartner report, which is available from Microsoft upon request. Gartner does not endorse any vendor or product and its research should not be construed as statements of fact.

1 of 2
The above graphics were published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Microsoft. Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. National Institute of Standards and Technology Comprehensive Vulnerability Database update 10/2015 TPC-H non-clustered results as of 04/06/15, 5/04/15, 4/15/14 and 11/25/13, respectively. http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster SQL Server 2016: Everything built-in In-memory across all workloads Microsoft $120 Tableau $480 Oracle $2,230 Self-service BI per user built-in 0 1 4 0 0 3 34 29 22 15 5 22 6 43 20 69 18 49 3 0 10 20 30 40 50 60 70 80 2010 2011 2012 2013 2014 2015 SQL Server Oracle MySQL SAP HANA Consistent experience from on-premises to cloud built-in built-in built-in built-in #1 SQL Server #2 SQL Server #3 SQL Server Oracle is #5 TPC-H at massive scale
PolyBase SQL Server Hadoop T-SQL query Manage structured & unstructured data Simple T-SQL to query Hadoop (HDFS) JSON support Quote: $658.39 Stretch database App Microsoft Azure Query Customer data Product data Order History Stretch to cloud Data is encrypted & queryable Save money & improve customer experience No application changes Learn more! www.microsoft.com/ SQLServer2016 Order history Name SSN Date Philip Wenger cm61ba906fd 2/28/2005 Denny Usher ox7ff654ae6d 3/18/2005 Alicia Hodge i2y36cg776rg 4/10/2005 Alta Levy nx290pldo90l 4/27/2005 Dionne Hardin ypo85ba616rj 5/12/2005 Kristy Flowers bns51ra806fd 5/22/2005 Sara Wiley mci12hh906fj 6/07/2005 Whitney Lang utb76b916gi 6/18/2014 Lorenzo Olds px61hi9306fj 7/1/2014 Sophie Cook ol43bi506gd 7/12/2014 Aida Durham tx83hal916fi 7/29/2014 Name DOB State Denny Usher 11/13/58 WA Gina Burch 04/29/76 WA Real-time operational analytics 0100101010110 ETL In-memory ColumnStore In-memory OLTP Real-time business problem detection 2-24 hrs Up to 30x faster transactions with in-memory OLTP Queries from minutes to seconds In-database Advanced Analytics R built-in to SQL Server Mission critical OLTP R built-in to your T-SQL Real-time operational analytics without moving the data Open source R with in-memory & massive scale multi-threading and massive parallel processing End-to-end mobile BI In-memory built-in Real-time with direct query capabilities Powerful modeling with 250+ built-in analytical functions Mobile reports with online & offline access Modern data visualizations with Reporting Services or Power BI Highest performing data warehouse SMP MPP Petabyte- scale Data marts Azure SQL Data Warehouse MPP SQL Server SQL Server + Analytics Platform System Data marts Petabyte- scale SMP Scale to MPP on-premises & in the cloud Simple T-SQL to manage structured and unstructured data 遜 the cost of Oracle Exadata SQL Server in Azure VM Always Encrypted App SELECT Name FROM Patients WHERE SSN=@SSN @SSN='198-33-0987' SQL Server Column Master Key Query Column Encryption Key Enhanced ADO.NET Library Denny Usher Name 198-33-0987 SSN USA Country Result Set Philip Wegner Name 1x7fg655se2e SSN USA Country Denny Usher 0x7ff654ae6d USA Alicia Hodge 0y8fj754ea2c USA dbo.Patients Denny Usher Name 0x7ff654ae6d SSN USA Country Result Set SELECT Name FROM Patients WHERE SSN=@SSN @SSN=0x7ff654ae6d Protect data at rest and in motion Without impacting database performance Trusted On-premises Cloud

More Related Content

SQL_Server_2016_Everything_Built-In_Datasheet_EN_US

  • 1. The above graphics were published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Microsoft. Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. National Institute of Standards and Technology Comprehensive Vulnerability Database update 10/2015 TPC-H non-clustered results as of 04/06/15, 5/04/15, 4/15/14 and 11/25/13, respectively. http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster SQL Server 2016: Everything built-in In-memory across all workloads Microsoft $120 Tableau $480 Oracle $2,230 Self-service BI per user built-in 0 1 4 0 0 3 34 29 22 15 5 22 6 43 20 69 18 49 3 0 10 20 30 40 50 60 70 80 2010 2011 2012 2013 2014 2015 SQL Server Oracle MySQL SAP HANA Consistent experience from on-premises to cloud built-in built-in built-in built-in #1 SQL Server #2 SQL Server #3 SQL Server Oracle is #5 TPC-H at massive scale
  • 2. PolyBase SQL Server Hadoop T-SQL query Manage structured & unstructured data Simple T-SQL to query Hadoop (HDFS) JSON support Quote: $658.39 Stretch database App Microsoft Azure Query Customer data Product data Order History Stretch to cloud Data is encrypted & queryable Save money & improve customer experience No application changes Learn more! www.microsoft.com/ SQLServer2016 Order history Name SSN Date Philip Wenger cm61ba906fd 2/28/2005 Denny Usher ox7ff654ae6d 3/18/2005 Alicia Hodge i2y36cg776rg 4/10/2005 Alta Levy nx290pldo90l 4/27/2005 Dionne Hardin ypo85ba616rj 5/12/2005 Kristy Flowers bns51ra806fd 5/22/2005 Sara Wiley mci12hh906fj 6/07/2005 Whitney Lang utb76b916gi 6/18/2014 Lorenzo Olds px61hi9306fj 7/1/2014 Sophie Cook ol43bi506gd 7/12/2014 Aida Durham tx83hal916fi 7/29/2014 Name DOB State Denny Usher 11/13/58 WA Gina Burch 04/29/76 WA Real-time operational analytics 0100101010110 ETL In-memory ColumnStore In-memory OLTP Real-time business problem detection 2-24 hrs Up to 30x faster transactions with in-memory OLTP Queries from minutes to seconds In-database Advanced Analytics R built-in to SQL Server Mission critical OLTP R built-in to your T-SQL Real-time operational analytics without moving the data Open source R with in-memory & massive scale multi-threading and massive parallel processing End-to-end mobile BI In-memory built-in Real-time with direct query capabilities Powerful modeling with 250+ built-in analytical functions Mobile reports with online & offline access Modern data visualizations with Reporting Services or Power BI Highest performing data warehouse SMP MPP Petabyte- scale Data marts Azure SQL Data Warehouse MPP SQL Server SQL Server + Analytics Platform System Data marts Petabyte- scale SMP Scale to MPP on-premises & in the cloud Simple T-SQL to manage structured and unstructured data 遜 the cost of Oracle Exadata SQL Server in Azure VM Always Encrypted App SELECT Name FROM Patients WHERE SSN=@SSN @SSN='198-33-0987' SQL Server Column Master Key Query Column Encryption Key Enhanced ADO.NET Library Denny Usher Name 198-33-0987 SSN USA Country Result Set Philip Wegner Name 1x7fg655se2e SSN USA Country Denny Usher 0x7ff654ae6d USA Alicia Hodge 0y8fj754ea2c USA dbo.Patients Denny Usher Name 0x7ff654ae6d SSN USA Country Result Set SELECT Name FROM Patients WHERE SSN=@SSN @SSN=0x7ff654ae6d Protect data at rest and in motion Without impacting database performance Trusted On-premises Cloud