Shulou(Shulou.com)06/01 Report--

Https://www.microsoft.com/zh-cn/server-cloud/products/sql-server/comparison.aspx

Compare the features of each SQL Server version

SQL Server 2016SQL Server 2014SQL Server 2012SQL Server 2008 R2

Functional features

Performance OLTP* in memory

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Column storage in memory *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Real-time operational analysis *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Resource governor *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Query storage

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Availability AlwaysOn*

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Enhanced virtualization support and real-time migration

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Security is always encrypted *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Transparent data encryption *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Row-level security

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Dynamic data mask

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Backup encryption support

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Fine-grained audit

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Separation of duties

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Programmability JSON support

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

PolyBase query through Hadoop data * *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Temporary

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Cloud ready SQL Server Stretch Database

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Backup to Azure

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Disaster recovery to Azure*

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Optimized virtual machine image in Azure library

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Manage Distributed Replay

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Policy-based management

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Business Intelligence Modernization report

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Mobile Business Intelligence *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Integrated services hosted as servers

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Pinning the report to Power BI

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Multidimensional semantic model

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Enhanced tabular BI semantic model *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Master data service *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

Data quality service *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

High-level analysis within a database through R Services

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Functional features

R query and multithreading of streaming memory *

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

* SQL Server Enterprise Edition and developer Edition only. For more information, see the SQL Server version page.

* * use PolyBase to perform relational and non-relational data queries through the simplicity of T-SQL, which requires a Microsoft SQL Server 2016 Enterprise Edition as the header node and expands to multiple standard computing nodes.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.