SQL Server technical documentation

Technical documentation to help you get started, administer, develop, and work with SQL Server and associated products.

SQL Server

WHAT’S NEW

• SQL Server 2019
• Azure Data Studio
• SQL Server on Linux

QUICKSTART

• Connect & query (SSMS)
• Connect & query (Azure Data Studio)

DOWNLOAD

• SQL Server
• SQL Server Management Studio
• Azure Data Studio

REFERENCE

• Transact-SQL
• SQL PowerShell
• Sample databases
• Internals & architecture guides
• Previous versions 2005-2014

SQL on Azure

OVERVIEW

• Azure SQL Database single database
• Azure SQL Database managed instance
• Azure Synapse Analytics (SQL DW)
• SQL Server on a Windows VM
• SQL Server on a Linux VM

Administration

DEPLOY

• Install SQL Server
• Upgrade SQL Server

OVERVIEW

• Security
• Monitor and tune performance
• In-Memory Database
• Automatic tuning
• Intelligent Query Processing

CONCEPT

• Backup & restore
• Always on availability groups
• Failover cluster instances
• SQL Server Replication

Business Intelligence

OVERVIEW

• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• Azure Data Factory

Migration

OVERVIEW

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

Big data & machine learning

OVERVIEW

• SQL Server Big Data Clusters
• Analytics Platform System
• Machine Learning with SQL Server
• R Services
• Data virtualization with Polybase