SQL Documentation

• • Databases

    • Manage relational data with SQL databases in your datacenter or on Azure. Use machine learning and analytics to gain insights on SQL data.

    • Databases

      SQL

      • SQL Server (2016, 2017)
      • SQL Server 2014
      • Previous Versions (2005 - 2012)
      • Azure SQL Database
      • Azure SQL Data Warehouse
      • Analytics Platform System - Parallel Data Warehouse

      Run on Windows or Linux

      • SQL Server on Linux
      • Linux virtual machines
      • Windows virtual machines

      Open source SQL

      • Azure Database for PostgreSQL
      • Azure Database for MySQL

      NoSQL

      • Cosmos DB

    • Develop

      Design

      • Connect with client applications
      • Relational database concepts
      • SQL Security

      Tools

      • SQL Operations Studio ^PREVIEW
      • SQL Server Management Studio (SSMS)
      • SQL Server Data Tools (SSDT)
      • See all SQL tools

      Reference

      • T-SQL
      • DMVs
      • PowerShell
      • XQuery

      Samples

      • Code samples on GitHub
      • Wide World Importers DB
      • AdventureWorks DB

    • Data Analytics

      Analysis

      • SQL Server Analysis Services (2016, 2017)
      • SQL Server 2014 Analysis Services
      • SQL Server 2012 Analysis Services
      • Azure Analysis Services
      • Azure Stream Analytics
      • Azure Data Lake Analytics
      • Azure Machine Learning
      • SQL Server Machine Learning Services
      • Machine Learning Server (Standalone)

      Reporting

      • SQL Server Reporting Services (2016, 2017)
      • SQL Server 2014 Reporting Services
      • SQL Server 2012 Reporting Services
      • Power BI Service