SQL Server 文档SQL Server Documentation

本主题适用于: 是SQL Server没有Azure SQL 数据库没有Azure SQL 数据仓库没有并行数据仓库THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 是 Microsoft 数据平台的核心部分。SQL Server is a central part of the Microsoft data platform. SQL Server 在操作数据库管理系统 (ODBMS) 中处于领先水平。SQL Server is an industry leader in operational database management systems (ODBMS). 本文档可帮助你安装、配置和使用 SQL Server。This documentation helps you install, configure, and use SQL Server. 内容包括端到端示例、代码示例和视频。The content includes end-to-end examples, code samples, and videos. 有关 SQL Server 语言的主题,请参阅 语言参考For SQL Server language topics, see Language Reference.

新增功能What's new 发行说明Release notes
SQL Server 2017 的新增功能What's New in SQL Server 2017 SQL Server 2017 发行说明SQL Server 2017 Release Notes
SQL Server 2016 中的新增功能What's New in SQL Server 2016 SQL Server 2016 发行说明SQL Server 2016 Release Notes
SQL Server 2014 中的新增功能What's New in SQL Server 2014 SQL Server 2014 Release NotesSQL Server 2014 Release Notes

试用 SQL Server!Try SQL Server!

从评估中心下载 下载 SQL Server 2017Download from Evaluation Center Download SQL Server 2017 从评估中心下载 下载 SQL Server 2016Download from Evaluation Center Download SQL Server 2016
创建虚拟机 获取具有 SQL Server 的虚拟机Create Virtual Machine Get a Virtual Machine with SQL Server 从评估中心下载 下载 SQL Server Management Studio (SSMS)Download from Evaluation Center Download SQL Server Management Studio (SSMS)
从评估中心下载 下载 SQL Server Data Tools (SSDT)Download from Evaluation Center Download SQL Server Data Tools (SSDT)

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.
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.
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.
Reporting ServicesReporting Services Reporting ServicesReporting Services

Reporting Services 提供启用了 Web 的企业级报告功能。Reporting Services delivers enterprise, Web-enabled reporting functionality. 从而使用户可以创建从多个数据源提取数据的表,发布各种格式的表,以及集中管理安全性和订阅。You can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.
R ServerR Server 机器学习服务Machine Learning Services

Microsoft 机器学习服务支持使用常用 R 和 Python 语言,将机器学习集成到企业工作流中。Microsoft Machine Learning Services supports integration of machine learning, using the popular R and Python languages, into enterprise workflows.

机器学习服务(数据库内)将 R 和 Python 与 SQL Server 集成,方便用户通过调用存储过程,轻松生成、重新定型模型,并对模型评分。Machine Learning Services (In-Database) integrates R and Python with SQL Server, making it easy to build, retrain, and score models by calling stored procedures. Microsoft 机器学习服务器对 R 和 Python 提供企业级支持,用户无需使用 SQL Server。Microsoft Machine Learning Server provides enterprise-scale support for R and Python, without requiring SQL Server.
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.
复制服务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.
Master Data Services Master Data ServicesMaster Data Services

Master Data ServicesMaster Data Services 是用于主数据管理的 SQL ServerSQL Server 解决方案。 is the 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.

迁移和移动数据Migrate and move data

早期 SQL Server 版本Earlier SQL Server versions

示例Samples

info_tip 获取帮助Get Help