SQL Server 2016 中的新增功能What's new in SQL Server 2016

适用对象:yesSQL Server(从 2016 版开始)noAzure SQL 数据库 noAzure SQL 数据仓库 no并行数据库APPLIES TO: yesSQL Server (starting with 2016) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

通过 SQL Server 2016,可以使用可缩放的混合数据库平台生成任务关键型智能应用程序。此平台内置了需要的所有功能,包括内存中性能、高级安全性和数据库内分析。With SQL Server 2016, you can build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics. SQL Server 2016 版本新增了安全功能、查询功能、Hadoop 和云集成、R 分析等功能,以及许多改进和增强功能。The SQL Server 2016 release adds new security features, querying capabilities, Hadoop and cloud integration, R analytics and more, along with numerous improvements and enhancements.

此页面收录了摘要信息和链接,可方便读者详细了解 SQL Server 2016,以及每个 SQL Server 组件的最近更新。This page provides summary information and links to more detailed SQL Server 2016 what's new information for each SQL Server component.

SQL Server 2016

立即试用 SQL Server!Try SQL Server today!

SQL Server 2016 数据库引擎SQL Server 2016 Database Engine

  • 现在可以在 SQL Server 安装和设置过程中配置多个 tempDB 数据库文件。You can now configure multiple tempDB database files during SQL Server installation and setup.
  • 新的“查询存储”在数据库中存储查询文本、执行计划和性能指标,以便于监视和排查性能问题。New Query Store stores query texts, execution plans, and performance metrics within the database, allowing easy monitoring and troubleshooting of performance issues. 仪表板可显示耗时最长、占用内存或 CPU 资源最多的查询。A dashboard shows which queries consumed the most time, memory or CPU resources.
  • 时态表是记录所有数据更改(包括更改日期和时间)的历史记录表。Temporal tables are history tables which record all data changes, complete with the date and time they occurred.
  • SQL Server 中新增了内置 JSON 支持,可以支持 JSON 导入、导出、分析和存储。New built-in JSON support in SQL Server supports JSON imports, exports, parsing and storing.
  • 新的 PolyBase 查询引擎将 SQL Server 与 Hadoop 或 Azure Blob 存储中的外部数据相集成。New PolyBase query engine integrates SQL Server with external data in Hadoop or Azure Blob storage. 可以导入和导出数据,也可以执行查询。You can import and export data as well as executing queries.
  • 借助新增的 Stretch Database 功能,可以将本地 SQL Server 数据库中的数据动态安全地存档到云中的 Azure SQL 数据库。The new Stretch Database feature lets you dynamically, securely archive data from a local SQL Server database to an Azure SQL database in the cloud. SQL Server 会自动查询本地数据和链接数据库中的远程数据。SQL Server automatically queries both local and remote data in the linked databases.
  • 内存中 OLTP:In-memory OLTP:
    • 现在支持 FOREIGN KEY、UNIQUE 和 CHECK 约束,以及本地编译存储过程 OR、NOT、SELECT DISTINCT、OUTER JOIN 和 SELECT 中的子查询。Now supports FOREIGN KEY, UNIQUE and CHECK constraints, and native compiled stored procedures OR, NOT, SELECT DISTINCT, OUTER JOIN, and subqueries in SELECT.
    • 支持最大 2TB 的表(之前为最大 256GB)。Supports tables up to 2TB (up from 256GB).
    • 为了实现排序和 AlwaysOn 可用性组支持,增强了列存储索引。Has column store index enhancements for sorting and Always On Availability Group support.
  • 新增安全功能:New security features:
    • Always Encrypted: 启用后,只有具有加密密钥的应用程序,才能访问 SQL Server 2016 数据库中的加密敏感数据。Always Encrypted: When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. 密钥绝不会传递给 SQL Server。The key is never passed to SQL Server.
    • 动态数据掩码: 如果在表定义中指定,那么大多数用户都看不到已掩码的数据,只有拥有 UNMASK 权限的用户才能看到完整数据。Dynamic Data Masking: If specified in the table definition, masked data is hidden from most users, and only users with UNMASK permission can see the complete data.
    • 行级别安全性: 可以在数据库引擎一级限制数据访问,这样用户就能只看到与其相关的数据。Row Level Security: Data access can be restricted at the database engine level, so users see only what is relevant to them.

请参阅数据库引擎See Database Engine.

SQL Server 2016 Analysis Services (SSAS)SQL Server 2016 Analysis Services (SSAS)

SQL Server 2016 Analysis Services 提升了兼容性级别为 1200 的表格模型数据库的性能,并提供了创建、数据库管理、筛选、处理等功能。SQL Server 2016 Analysis Services provides improved performance, authoring, database management, filtering, processing, and much more for tabular model databases based on the 1200 compatibility level.

  • SQL Server R Services 将用于统计分析的 R 编程语言集成到 SQL Server 中。SQL Server R Services integrate the R programming language, used for statistical analysis, into SQL Server.
  • 新增的数据库一致性检查器 (DBCC) 在内部运行,以检测潜在的数据损坏问题。New Database Consistency Checker (DBCC) runs internally to detect potential data corruption issues.
  • 直接查询是查询实时外部数据,而不是先导入数据。现在支持更多的数据源,包括 Azure SQL、Oracle 和 Teradata。Direct Query, which queries live external data rather than importing it first, now supports more data sources, including Azure SQL, Oracle and Teradata.
  • 新增了许多 DAX(数据访问表达式)函数。There are numerous new DAX (Data Access Expressions) functions.
  • 新增的 Microsoft.AnalysisServices.Tabular 命名空间管理表格模式实例和模型。New Microsoft.AnalysisServices.Tabular namespace manages tabular mode instances and models.
  • Analysis Services 管理对象 (AMO) 经过重新设计,包含另一个程序集,即 Microsoft.AnalysisServices.Core.dll。Analysis Services Management Objects (AMO) is re-factored to include a second assembly, Microsoft.AnalysisServices.Core.dll.

请参阅 Analysis Services 引擎 (SSAS)See Analysis Services Engine (SSAS).

SQL Server 2016 Integration Services (SSIS)SQL Server 2016 Integration Services (SSIS)

  • 支持 AlwaysOn 可用性组Support for Always On Availability Groups
  • 增量包部署Incremental package deployment
  • 支持 Always EncryptedAlways Encrypted support
  • 新增了 ssis_logreader 数据库级别角色New ssis_logreader database-level role
  • 新增了自定义日志记录级别New custom logging level
  • 数据流中的错误列名称Column names for errors in the data flow
  • 新增了连接器New connectors
  • 支持 Hadoop 文件系统 (HDFS)Support for the Hadoop file system (HDFS)

请参阅 Integration Services (SSIS)See Integration Services (SSIS).

SQL Server 2016 Master Data Services (MDS)SQL Server 2016 Master Data Services (MDS)

  • 改进了派生层次结构,包括支持递归和多对多层次结构Derived hierarchy improvements, including support for recursive and many-to-many hierarchies
  • 基于域的属性筛选Domain-based attribute filtering
  • 用于在模型之间共享实体数据的实体同步功能Entity syncing for sharing entity data between models
  • 通过变更集实现的批准工作流Approval workflows via changesets
  • 用于提升查询性能的自定义索引Custom indexes to improve query performance
  • 新增了权限级别,以提高安全性New permission levels for improved security
  • 重新设计了业务规则管理体验Redesigned business rules management experience

请参阅 Master Data Services (MDS)See Master Data Services (MDS).

SQL Server 2016 Reporting Services (SSRS)SQL Server 2016 Reporting Services (SSRS)

在这一版中,Microsoft 彻底改进了 Reporting Services。Microsoft has thoroughly revamped Reporting Services in this release.

  • 具有 KPI 功能的新 Web 报表门户New web Report Portal with KPI feature
  • 新的移动报表发布服务器New Mobile Report Publisher
  • 重新设计了支持 HTML5 的报表呈现引擎Redesigned report rendering engine that supports HTML5
  • 新增了树状图和旭日图图表类型New treemap and sunburst chart types

请参阅 Reporting Services (SSRS)See Reporting Services (SSRS).

后续步骤Next steps

info_tip 获取帮助Get Help

编辑内容 参与编辑 SQL 文档Contribute SQL documentation

您是否知道,您可以编辑内容自己?Did you know that you could edit the content yourself? 如果这样做,不仅将得到改善我们的文档,而且你将还贷记作为参与者到页。If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.