title

SQL Server 2016 Technical Documentation | Microsoft Docs

ms.date

02/27/2017

ms.prod

sql-server-2016

ms.reviewer

ms.suite

ms.technology

server-general

ms.tgt_pltfrm

ms.topic

article

f1_keywords

sql13.portal.f1

helpviewer_keywords

documentation [SQL Server], home page

Help [SQL Server]

SQL Server, documentation

home page [SQL Server]

Help [SQL Server], documentation home page

Books Online [SQL Server], home page

portal page [SQL Server]

ms.assetid

674933a8-e423-4d44-a39b-2a997e2c2333

caps.latest.revision

106

author

BYHAM

ms.author

rickbyh

manager

jhubbard

SQL Server Technical Documentation

[!INCLUDEtsql-appliesto-ss2008-all_md]

Documentation to help you install, configure, and use SQL Server. The content includes end-to-end examples, code samples, and videos. For [!INCLUDEssNoVersion_md] language topics, see Language Reference.

SQL Server vNext

For the latest release notes, see SQL Server vNext Release Notes

For the latest information on what is new, see What's New in SQL Server vNext

SQL Server 2016:

SQL Server 2016 Release Notes

What's New in SQL Server 2016

Try SQL Server!

SQL Server Technologies


	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 Services Microsoft R Services provides multiple ways to incorporate the popular R language into enterprise workflows. [!INCLUDErsql_productname] integrates the R language with [!INCLUDEssNoVersion], making it easy to build, retrain, and score models by calling [!INCLUDEtsql] stored procedures. Microsoft R Server provides multi-platform, scalable support for R in the enterprise, and supports data sources such as Hadoop and Teradata.
	Data Quality Services SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution. 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. 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 Services [!INCLUDEssISnoversion] 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 [!INCLUDEssMDSshort] is the [!INCLUDEssNoVersion] solution for master data management. A solution built on [!INCLUDEssMDSshort] helps ensure that reporting and analysis is based on the right information. Using [!INCLUDEssMDSshort], you create a central repository for your master data and maintain an auditable, securable record of that data as it changes over time.
	Analysis Services [!INCLUDEssASnoversion_md] is an analytical data platform and toolset for personal, team, and corporate business intelligence. Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using [!INCLUDEssGemini], Excel, and a SharePoint Server environment. [!INCLUDEssASnoversion] also includes Data Mining so that you can uncover the patterns and relationships hidden inside large volumes of data.
	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. 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 Services 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.