SQL Server technical documentation

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
• SQL Server 2014 docs
• 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