10BC0 sql-docs/docs/sql-server/sql-server-technical-documentation.md at live · shaneis/sql-docs · GitHub
[go: up one dir, main page]
Skip to content

sql-server-technical-documentation.md

Latest commit

 

History

History
178 lines (136 loc) · 14.1 KB

sql-server-technical-documentation.md

File metadata and controls

178 lines (136 loc) · 14.1 KB
title SQL Server Documentation | Microsoft Docs
ms.date 09/24/2019
ms.prod sql
ms.reviewer
ms.custom
ms.technology
ms.topic conceptual
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
author craigg-msft
ms.author jroth
monikerRange =azuresqldb-current||=azuresqldb-mi-current||=azure-sqldw-latest||>= aps-pdw-2016||>=sql-server-2016||>=sql-server-linux-2017||=sql-server-previousversions||=sqlallproducts-allversions

SQL Server Documentation

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]

::: moniker range=">= sql-server-linux-2017 || >= sql-server-2017 || = sqlallproducts-allversions" SQL Server is a central part of the Microsoft data platform. SQL Server is an industry leader in operational database management systems (ODBMS). This documentation helps you install, configure, and use SQL Server on both Windows and Linux. The content includes end-to-end examples, code samples, and videos. For SQL Server language topics, see Language Reference. ::: moniker-end

::: moniker range="= sql-server-2016" SQL Server is a central part of the Microsoft data platform. SQL Server is an industry leader in operational database management systems (ODBMS). This documentation helps you install, configure, and use SQL Server on Windows. The content includes end-to-end examples, code samples, and videos. For SQL Server language topics, see Language Reference. ::: moniker-end

SQL Server 2014, and older versions including SQL Server 2005, have documentation available here.

::: moniker range="= sqlallproducts-allversions"

What's new Release notes
What's New in SQL Server 2019 SQL Server 2019 Release Notes
What's New in SQL Server 2017 SQL Server 2017 Release Notes
What's New in SQL Server 2016 SQL Server 2016 Release Notes
   

info_tip The SQL Server 2014 documentation is available here. ::: moniker-end

::: moniker range="= sql-server-ver15"

What's new Release notes
What's New in SQL Server 2019 SQL Server 2019 Release Notes
   

::: moniker-end

::: moniker range="= sql-server-linux-2017 || = sql-server-2017"

What's new Release notes
What's New in SQL Server 2017 SQL Server 2017 Release Notes
   

Note

SQL Server 2019 preview is now available. For more information, see What's New in SQL Server 2019. ::: moniker-end

::: moniker range="=sql-server-2016"

What's new Release notes
What's New in SQL Server 2016 SQL Server 2016 Release Notes
   

::: moniker-end

::: moniker range="= sql-server-2016 || = sqlallproducts-allversions" Try SQL Server 2016!

::: moniker range=">= sql-server-2017 || >= sql-server-linux-2017 || = sqlallproducts-allversions" Try SQL Server!

[!INCLUDEget-sql-tools]

SQL Server Technologies
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.
Machine Learning Services Machine Learning Services

Machine Learning Services gives the ability to run Python and R scripts with relational data. You can use open source and Microsoft packages for predictive analytics and machine learning. The scripts are executed in-database without moving data outside SQL Server or over the network.
Integration 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.
Analysis Services 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.
Reporting Services Reporting Services

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.
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. 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.
Data Quality Services 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.
Master Data Services 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.
   

Other members of the SQL Server family

Name Https URL root
Azure SQL Database single database https://docs.microsoft.com/azure/sql-database/
Azure SQL Database managed instance https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance
SQL Server on a virtual machine (VM) https://docs.microsoft.com/azure/virtual-machines/windows/sql/
SQL Data Warehouse https://docs.microsoft.com/azure/sql-data-warehouse/
Analytics Platform System (APS) https://docs.microsoft.com/sql/analytics-platform-system/

Note: APS hosts SQL Server Parallel Data Warehouse (PDW), which is the software that runs the massively parallel processing (MPP) data warehouse.
SQL Server on Linux https://docs.microsoft.com/sql/linux/
   

Cousins of SQL Server

Name Https URL root
PostgreSQL database https://docs.microsoft.com/azure/postgresql/
MySQL database https://docs.microsoft.com/azure/mysql/
NoSQL:   Azure Cosmos DB https://docs.microsoft.com/azure/cosmos-db/
   

::: moniker range="= sql-server-2016 || = sqlallproducts-allversions"

Migrate and move data, in version 2016

::: moniker range=">= sql-server-2017 || >= sql-server-linux-2017 || = sqlallproducts-allversions"

Migrate and move data

Update your version of SQL Server

Samples

SQL Server 2014, 2012, 2008, 2005 previous versions

[!INCLUDEprevious-versions]

Versioning control for SQL documentation

The versioning control on this :::no-loc text="Docs"::: webpage is above the table of contents. For information about how you can use the versioning control and exactly what it does, see:

[!INCLUDEget-help-options]

[!INCLUDEcontribute-to-content]
0