SQL Server 技术文档SQL Server Technical Documentation

本主题适用于: yesSQL Server(从 2016 开始)noAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

与以前版本的 SQL Server 相关的内容,请参阅安装 SQL Server 2014For content related to previous versions of SQL Server, see Installation for SQL Server 2014.

用于帮助安装、配置和使用 SQL Server 2016 的文档。Documentation to help you install, configure, and use SQL Server. 内容包括端到端示例、代码示例和视频。The content includes end-to-end examples, code samples, and videos. 有关 SQL ServerSQL Server 语言的主题,请参阅 语言参考For SQL ServerSQL Server language topics, see Language Reference.

SQL Server 自 2017 年 1SQL Server 2017

SQL Server 2016:SQL Server 2016:

SQL Server 技术SQL Server Technologies

SQL 数据库引擎SQL database engine 数据库引擎Database Engine

数据库引擎是用于存储、处理和保护数据的核心服务。The Database Engine is the core service for storing, processing, and securing data. 数据库引擎提供了受控访问和快速事务处理,以满足企业内最苛刻的数据消费应用程序的要求。The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. 数据库引擎还提供了大量的支持以保持高可用性。The Database Engine also provides rich support for sustaining high availability.
R ServerR Server R ServicesR Services

Microsoft R 服务提供了多种将受欢迎的 R 语言并入企业工作流的方法。Microsoft R Services provides multiple ways to incorporate the popular R language into enterprise workflows.

R Services (数据库中)R Services (In-Database) 将 R 语言与 SQL ServerSQL Server集成,以便轻松通过调用 Transact-SQLTransact-SQL 存储过程生成、重新导流模型,并对模型评分。 stored procedures.

Microsoft R Server 在企业中为 R 提供多平台可扩展支持,并且支持 Hadoop 和 Teradata 等数据源。Microsoft R Server provides multi-platform, scalable support for R in the enterprise, and supports data sources such as Hadoop and Teradata.
Data Quality ServicesData Quality Services Data Quality ServicesData Quality Services

SQL Server Data Quality Services (DQS) 向您提供知识驱动型数据清理解决方案。SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution. DQS 使您可以生成知识库,然后使用此知识库,同时采用计算机辅助方法和交互方法,执行数据更正和消除重复的数据。DQS enables you to build a knowledge base, and then use that knowledge base to perform data correction and deduplication on your data, using both computer-assisted and interactive means. 您可以使用基于云的引用数据服务,并可以生成一个数据管理解决方案将 DQS 与 SQL Server Integration Services 和 Master Data Services 相集成。You can use cloud-based reference data services, and you can build a data management solution that integrates DQS with SQL Server Integration Services and Master Data Services.
Integration ServicesIntegration Services Integration ServicesIntegration Services

Integration ServicesIntegration Services 是一个生成高性能数据集成解决方案的平台,其中包括对数据仓库提供提取、转换和加载 (ETL) 处理的包。 is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.
Master Data Services Master Data ServicesMaster Data Services

Master Data ServicesMaster Data Services 是用于主数据管理的 SQL ServerSQL Server 解决方案。 solution for master data management. 基于 Master Data ServicesMaster Data Services 生成的解决方案可帮助确保报表和分析均基于适当的信息。A solution built on Master Data ServicesMaster Data Services helps ensure that reporting and analysis is based on the right information. 使用 Master Data ServicesMaster Data Services,您可以为主数据创建中央存储库,并随着主数据随时间变化而维护一个可审核的安全对象记录。Using Master Data ServicesMaster Data Services, you create a central repository for your master data and maintain an auditable, securable record of that data as it changes over time.
Analysis ServicesAnalysis Services Analysis ServicesAnalysis Services

Analysis ServicesAnalysis Services 是一个针对个人、团队和公司商业智能的分析数据平台和工具集。 is an analytical data platform and toolset for personal, team, and corporate business intelligence. 服务器和客户端设计器通过使用 Power PivotPower Pivot、Excel 和 SharePoint Server 环境,支持传统的 OLAP 解决方案、新的表格建模解决方案以及自助式分析和协作。Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using Power PivotPower Pivot, Excel, and a SharePoint Server environment. Analysis ServicesAnalysis Services 还包括数据挖掘,以便你可以发现隐藏在大量数据中的模式和关系。 also includes Data Mining so that you can uncover the patterns and relationships hidden inside large volumes of data.
复制服务Replication services 复制Replication

复制是一组技术,用于在数据库间复制和分发数据和数据库对象,然后在数据库间进行同步操作以维持一致性。Replication is a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency. 使用复制时,可以通过局域网和广域网、拨号连接、无线连接和 Internet,将数据分发到不同位置以及分发给远程用户或移动用户。By using replication, you can distribute data to different locations and to remote or mobile users by means of local and wide area networks, dial-up connections, wireless connections, and the Internet.
Reporting ServicesReporting Services Reporting ServicesReporting Services

Reporting Services 提供企业级的 Web 报表功能,从而使您可以创建从多个数据源提取数据的表,发布各种格式的表,以及集中管理安全性和订阅。Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

早期 SQL Server 版本Earlier SQL Server versions

示例数据库Sample databases

是否需要帮助?是否需要帮助?MSDN 论坛堆栈溢出ConnectNeed help? Need help? MSDN Forum, Stackoverflow, Connect