index.yml

### YamlMime:Hub
title: Microsoft SQL documentation
summary: "Learn how to use SQL Server and Azure SQL to manage your database needs, both on-premises and in the cloud. (quick link: https://aka.ms/sqldocs)"
brand: sql
metadata:
   title: Microsoft SQL documentation | Microsoft Docs
   description: "Learn how to use SQL Server and Azure SQL to manage your database needs, both on-premises and in the cloud. (quick link: https://aka.ms/sqldocs)"
   ms.topic: hub-page

# itemType: architecture | concept | deploy | download | get-started | how-to-guide | learn | overview | quickstart | reference | tutorial | video | whats-new

highlightedContent:
  items:
   - title: Try SQL Server 2019
     itemType: download
     url: https://www.microsoft.com/evalcenter/evaluate-sql-server-2019
   - title: Get an Azure VM with SQL Server
     itemType: overview
     url: https://azure.microsoft.com/services/virtual-machines/sql-server/?wt.mc_id=sqL16_vm
   - title: SQL tools
     itemType: overview
     url: tools/overview-sql-tools.md
   - title: Educational SQL resources 
     itemType: learn
     url: sql-server/educational-sql-resources.yml

productDirectory:
  items:
  - title: SQL Server on Windows
    imageSrc: media/index/windows.svg
    links:
      - url: sql-server/index.yml
        text: On-premises
      - url: https://docs.microsoft.com/azure/azure-sql/virtual-machines/windows/
        text: On an Azure VM
      - url: https://docs.microsoft.com/previous-versions/sql/
        text: Previous Versions (SQL 2005-2012)  
  - title: SQL on Azure 
    imageSrc: media/index/azure.svg
    links:
      - url: https://docs.microsoft.com/azure/azure-sql/database/
        text: Azure SQL Database
      - url: https://docs.microsoft.com/azure/azure-sql/managed-instance/
        text: Azure SQL Managed Instance      
      - url: https://docs.microsoft.com/azure/azure-sql-edge/overview
        text: Azure SQL Edge       
      - url: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is/
        text: Azure Synapse Analytics (SQL DW)
  - title: SQL Server on Linux
    imageSrc: media/index/linux.svg
    links:
      - url: linux/sql-server-linux-overview.md
        text: On-premises
      - url: https://docs.microsoft.com/azure/azure-sql/virtual-machines/linux/
        text: On an Azure VM


conceptualContent:
  items:
    - title: Getting started 
      links:
        - text: Connect & query (Azure Data Studio)
          url: azure-data-studio/quickstart-sql-server.md
          itemType: quickstart
        - text: Connect & query (SSMS)
          url: ssms/tutorials/connect-query-sql-server.md
          itemType: quickstart
        - text: Writing Transact-SQL
          url: t-sql/tutorial-writing-transact-sql-statements.md
          itemType: quickstart
        - text: SQL Server Docker container
          url: linux/quickstart-install-connect-docker.md
          itemType: quickstart
        - text: SQL Docs navigation tips
          url: sql-server/sql-docs-navigation-guide.md
          itemType: get-started
    - title: What's new
      links:
        - text: SQL Server 2019
          url: https://docs.microsoft.com/sql/sql-server/what-s-new-in-sql-server-ver15
          itemType: whats-new
        - text: SQL Server Big Data Cluster
          url: https://docs.microsoft.com/sql/big-data-cluster/big-data-cluster-overview
          itemType: whats-new
        - text: Azure Data Studio
          url: azure-data-studio/release-notes-azure-data-studio.md
          itemType: whats-new
        - text: Azure Database Migration Service
          url: https://docs.microsoft.com/azure/dms/dms-overview
          itemType: whats-new
        - text: SQL Server Machine Learning Services
          url: machine-learning/index.yml
          itemType: whats-new
        - text: SQL Server enabled Azure Arc (preview)
          url: sql-server/azure-arc/overview.md
          itemType: whats-new
    - title: Install 
      links:
        - text: SQL Server
          url: database-engine/install-windows/install-sql-server.md
          itemType: deploy
        - text: SQL Server Management Studio (SSMS)
          url: ssms/download-sql-server-management-studio-ssms.md
          itemType: deploy
        - text: Azure Data Studio
          url: azure-data-studio/download.md
          itemType: deploy
        - text: Analysis Services (SSAS)
          url: https://docs.microsoft.com/analysis-services/instances/install-windows/install-analysis-services/
          itemType: deploy
        - text: Integration Services (SSIS)
          url: integration-services/install-windows/install-integration-services.md
          itemType: deploy
        - text: Reporting Services (SSRS)
          url: reporting-services/install-windows/install-reporting-services.md
          itemType: deploy
    - title: Migrate
      links:
        - text: Data Migration Guide 
          url: https://datamigration.microsoft.com/
          itemType: overview
        - text: Database Compatibility Certification 
          url: https://aka.ms/dbcompat
          itemType: overview
        - text: Azure Database Migration Service (DMS)
          url: https://docs.microsoft.com/azure/dms/dms-overview
          itemType: overview
        - text: Database Migration Assistant (DMA)
          url: dma/dma-overview.md
          itemType: overview
        - text: Database Experimentation Assistant (DEA)
          url: dea/database-experimentation-assistant-overview.md
          itemType: overview
        - text: SQL Server Migration Assistant (SSMA)
          url: ssma/sql-server-migration-assistant.md
          itemType: overview
      footerLink:
        text: See more
        url: sql-server/migrate/index.yml


additionalContent: 
  sections:
    - items:
      - title: Development
        links:
          - text: Build an app using SQL Server
            url: https://www.microsoft.com/sql-server/developer-get-started/
          - text: SQL Server client connectivity
            url: connect/homepage-sql-connection-programming.md
          - text: DevOps using SQL Server 
            url: https://www.microsoft.com/sql-server/developer-get-started/sql-devops/
          - text: Azure SQL Database applications
            url: https://docs.microsoft.com/azure/sql-database/sql-database-develop-overview
          - text: Azure SQL Database connectivity libraries
            url: https://docs.microsoft.com/azure/sql-database/sql-database-connect-query#libraries
          - text: Transact-SQL (T-SQL)
            url: t-sql/language-reference.md
          - text: SQL PowerShell
            url: powershell/sql-server-powershell.md
          - text: Database samples
            url: samples/sql-samples-where-are.md

      - title: Reporting & analysis
        links: 
          - text: Power BI Report Server
            url: https://docs.microsoft.com/power-bi/report-server/get-started
          - text: Power BI Service
            url: https://docs.microsoft.com/power-bi/service-get-started
          - text: SQL Server Reporting Services (SSRS)
            url: reporting-services/create-deploy-and-manage-mobile-and-paginated-reports.md
          - text: SQL Server Analysis Services (SSAS)
            url: https://docs.microsoft.com/analysis-services/analysis-services-overview
          - text: Azure Analysis Services
            url: https://docs.microsoft.com/azure/analysis-services/

      - title: Big data & machine learning
        links:
          - text: SQL Server Big Data Clusters
            url: https://docs.microsoft.com/sql/big-data-cluster/big-data-cluster-overview
          - text: Data Virtualization with Polybase
            url: relational-databases/polybase/polybase-guide.md
          - text: Azure Synapse Analytics (SQL DW)
            url: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is/
          - text: Microsoft Analytics Platform System
            url: analytics-platform-system/index.md
          - text: SQL Server Machine Learning Services (R & Python)
            url: machine-learning/index.yml