424 lines (423 loc) · 35.3 KB

layout: HubPage hide_bc: true title: Microsoft SQL Documentation | Microsoft Docs description: Learn about SQL

SQL Documentation

- Get Started
  - Find popular topics and downloads for Microsoft’s SQL platform
  - What's new
    
    SQL Server
    
    SQL Server 2017 Preview
    
    SQL Server 2017 Reporting Services Preview
    
    SQL Server on Linux
  - Explore
    
    Create your first
    
    Azure SQL Database
    
    Azure SQL Data Warehouse
    
    Data science experiment
  - Download & install
    
    SQL Server
    
    SQL Server 2016
    
    SQL Server 2017 Preview
    
    SQL Server Reporting Services (SSRS)
    
    Tools
    
    SQL Server Management Studio (SSMS)
    
    SQL Server Data Tools (SSDT)
    
    Power BI Report Server and tools
    
    Sample databases
    
    Wide World Importers sample database
- Databases
  - Manage relational data with SQL databases in your datacenter or on Azure
  - SQL Server
    
    Latest versions
    
    SQL Server (2016, 2017)
    
    SQL Server 2014
    
    SQL Server 2012
    
    Run on Windows or Linux
    
    SQL Server on Linux
    
    Linux virtual machines
    
    Windows virtual machines
    
    Windows Server 2016
  - Database as a Service
    
    Microsoft SQL
    
    Azure SQL Database
    
    Azure SQL Data Warehouse
    
    Open source SQL
    
    Azure Database for PostgreSQL
    
    Azure Database for MySQL
    
    NoSQL
    
    Cosmos DB
  - Develop
    
    Design
    
    Connect with client applications
    
    Relational database concepts
    
    Tools
    
    SQL Server Management Studio (SSMS)
    
    SQL Server Data Tools (SSDT)
    
    See all SQL tools
    
    Reference
    
    T-SQL
    
    DMVs
    
    XQuery
- Data movement
  - Migrate your database or move data between databases
  - Migrate a database
    
    Download migration tools
    
    Data Migration Assistant
    
    SSMA for Access
    
    SSMA for DB2
    
    SSMA for MySql
    
    SSMA for Oracle
    
    SSMA for SAP ASE
    
    Migrate your SQL Server database
    
    To Azure SQL Database
    
    To Azure SQL Data Warehouse
  - Move data to Azure Storage for data preparation
    
    Networking
    
    Overview
    
    ExpressRoute
    
    Move to Azure blob storage
    
    Azure Storage Explorer
    
    AZCopy
    
    Import-Export Service
    
    SQL Server Integration Services (SSIS)
    
    Move to Azure Data Lake Store
    
    ADLCopy
    
    SQL Server Integration Services
  - Move data into a database
    
    SQL
    
    SQL Server Integration Services
    
    PolyBase
    
    SqlBulkCopy Class
    
    BCP
    
    NoSQL
    
    Import data into Azure Cosmos DB
- Analytics
  - Use machine learning and analytics to gain insights on SQL data
  - SQL Server
    
    Machine learning
    
    SQL Server Machine Learning Services
    
    Machine Learning Server (Standalone)
    
    Analysis Services
    
    SQL Server Analysis Services (2016, 2017)
    
    SQL Server 2014 Analysis Services
    
    SQL Server 2012 Analysis Services
    
    Reporting Services
    
    SQL Server Reporting Services (2016, 2017)
    
    SQL Server 2014 Reporting Services
    
    SQL Server 2012 Reporting Services
  - Analytics as a Service
    
    Azure Machine Learning
    
    Azure Analysis Services
    
    Azure Stream Analytics
    
    Azure Data Lake Analytics
    
    Data Science Virtual Machine
  - Power BI
    
    Power BI Service
    
    Power BI Desktop
    
    Power BI Mobile Apps
    
    Power BI Developer
    
    Power BI Report Server