Microsoft SQL documentation

Learn how to use SQL Server and Azure SQL, both on-premises and in the cloud.

Download

Try SQL Server 2019

Overview

Get an Azure VM with SQL Server

Overview

SQL tools

Learn

Educational SQL resources

SQL Server on Windows

• On-premises
• On an Azure VM
• Previous Versions (SQL 2005-2012)

SQL on Azure

• Azure SQL Database
• Azure SQL Managed Instance
• Azure SQL Edge
• Azure Synapse Analytics

SQL Server on Linux

• On-premises
• On an Azure VM

Getting started

• Connect & query (Azure Data Studio)
• Connect & query (SSMS)
• Writing Transact-SQL
• SQL Server Docker container
• SQL Docs navigation tips

What's new

• SQL Server 2019
• Azure SQL Database
• Azure SQL Managed Instance
• SQL Server on Azure VMs
• Azure Data Studio
• SQL Server Machine Learning Services
• Azure Arc-enabled SQL Server

Install

• SQL Server
• SQL Server Management Studio (SSMS)
• Azure Data Studio
• Analysis Services (SSAS)
• Integration Services (SSIS)
• Reporting Services (SSRS)

Migrate

• Data Migration Guide
• Database Compatibility Certification
• Azure Database Migration Service (DMS)
• Database Migration Assistant (DMA)
• Database Experimentation Assistant (DEA)
• SQL Server Migration Assistant (SSMA)
• See more

Development

• Build an app using SQL Server
• SQL Server client connectivity
• DevOps using SQL Server
• Azure SQL Database applications
• Azure SQL Database connectivity libraries
• Transact-SQL (T-SQL)
• SQL PowerShell
• Database samples

Reporting & analysis

• Power BI Report Server
• Power BI Service
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Azure Analysis Services

Big data & machine learning

• Azure Synapse Analytics
• SQL Server Machine Learning Services (R & Python)
• SQL Server Big Data Clusters
• Data Virtualization with Polybase
• Microsoft Analytics Platform System