Microsoft SQL documentation

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

Download

Try SQL Server 2022

Overview

Get an Azure VM with SQL Server

Overview

SQL tools

Reference

Troubleshoot

SQL Server on Windows

• On-premises
• On an Azure VM
• Previous versions (SQL 2005-2014)

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

• What is SQL Server?
• Connect to the Database Engine
• Connect and query with SSMS
• Write Transact-SQL
• SQL Server in a Linux container
• SQL Docs navigation tips
• Educational SQL resources

What's new

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

Install

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

Migrate

• Data migration
• Database compatibility certification
• Azure Database Migration Service (DMS)
• Database Migration Assistant (DMA)
• Database Experimentation Assistant (DEA)
• SQL Server Migration Assistant (SSMA)
• See more

Development

• SQL Server client connectivity
• Azure SQL Database applications
• Azure SQL Database connectivity libraries
• Transact-SQL (T-SQL)
• SQL PowerShell
• Database samples

Reporting and analysis

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

Big data and 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