index.yml

### YamlMime:Hub
title: Microsoft SQL documentation
summary: Learn how to use Microsoft SQL Server to address your database needs, both on-premises and in the cloud.
brand: sql
metadata:
   title: Microsoft SQL documentation | Microsoft Docs
   description: Learn how to use Microsoft SQL Server to manage your database needs, both on-premises and in the cloud.
   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: SQL Server Education Center
     itemType: learn
     url: lp/sql-server/sql-education-center.md

productDirectory:
  items:
  - title: SQL on Azure 
    imageSrc: media/index/azure.png
    links:
      - url: https://docs.microsoft.com/azure/sql-database/
        text: Azure SQL Database
      - 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 Windows
    imageSrc: media/index/windows.png
    links:
      - url: sql-server/index.yml
        text: On-premises
      - url: https://docs.microsoft.com/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-overview/
        text: On an Azure VM
      - url: https://docs.microsoft.com/previous-versions/sql/
        text: Previous Versions (SQL 2005-2012)
  - title: SQL Server on Linux
    imageSrc: media/index/linux.png
    links:
      - url: linux/sql-server-linux-overview.md
        text: On-premises
      - url: linux/quickstart-install-connect-clouds.md
        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 Machine Learning Services
          url: advanced-analytics/index.yml
          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
      footerLink:
        text: See more
        url: lp/sql-server/install-sql-and-services.md
    - 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: lp/sql-server/load-move-data.md


additionalContent: 
  sections:
    - items:
      - title: Administration
        links:
          - text: Dynamic Management Views (DMVs)
            url: relational-databases/system-dynamic-management-views/system-dynamic-management-views.md
          - text: System catalog views
            url: relational-databases/system-catalog-views/catalog-views-transact-sql.md
          - text: Extended events
            url: relational-databases/extended-events/quick-start-extended-events-in-sql-server.md
          - text: Securing SQL Server
            url: relational-databases/security/securing-sql-server.md
          - text: SQL PowerShell
            url: powershell/sql-server-powershell.md         
          - text: Azure SQL REST API
            url: https://docs.microsoft.com/rest/api/sql/
          - text: Azure SQL PowerShell
            url: https://docs.microsoft.com/powershell/module/az.sql/
      - title: Security & Privacy
        links:
          - text: SQL Server Auditing
            url: relational-databases/security/auditing/sql-server-audit-database-engine.md
          - text: Azure SQL Database Auditing
            url: https://docs.microsoft.com/azure/sql-database/sql-database-auditing
          - text: Data classification
            url: relational-databases/security/sql-data-discovery-and-classification.md
          - text: Always Encrypted
            url: relational-databases/security/encryption/always-encrypted-database-engine.md
      - title: Development
        links:
          - text: Build an app using SQL Server
            url: https://www.microsoft.com/sql-server/developer-get-started/
          - text: DevOps using SQL Server 
            url: https://www.microsoft.com/sql-server/developer-get-started/sql-devops/
          - text: SQL Server security
            url: https://docs.microsoft.com/dotnet/framework/data/adonet/sql/overview-of-sql-server-security
          - text: Azure SQL DB applications
            url: https://docs.microsoft.com/azure/sql-database/sql-database-develop-overview
          - text: Azure SQL DB connectivity libraries
            url: https://docs.microsoft.com/azure/sql-database/sql-database-connect-query#libraries
          - text: SQL Server client connectivity
            url: connect/homepage-sql-connection-programming.md
          - text: Transact-SQL (T-SQL)
            url: t-sql/language-reference.md
          - text: Database samples
            url: samples/sql-samples-where-are.md
      - title: Reporting & Machine Learning
        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: Azure Machine Learning
            url: https://docs.microsoft.com/azure/machine-learning/
          - text: SQL Machine Learning Services (R & Python)
            url: advanced-analytics/index.yml
          - text: SQL Server R Services
            url: advanced-analytics/r/sql-server-r-services.md
      - title: Big data
        links:
          - text: SQL Server 2019 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: Azure SQL Database Hyperscale
            url: https://docs.microsoft.com/azure/sql-database/sql-database-service-tier-hyperscale
          - text: Azure Analysis Services
            url: https://docs.microsoft.com/azure/analysis-services/
          - text: SQL Server Analysis Services (SSAS)
            url: https://docs.microsoft.com/analysis-services/analysis-services-overview
          - text: Microsoft Analytics Platform System
            url: analytics-platform-system/index.md
      - title: Tools
        links:
          - text: Azure Data Studio
            url: azure-data-studio/download.md
          - text: SQL Server Management Studio (SSMS)
            url: ssms/download-sql-server-management-studio-ssms.md
          - text: mssql-cli
            url: tools/mssql-cli.md
          - text: Azure SQL CLI
            url: https://docs.microsoft.com/cli/azure/sql
          - text: SQL Server Data Tools (SSDT)
            url: ssdt/download-sql-server-data-tools-ssdt.md
          - text: Distributed replay
            url: tools/distributed-replay/sql-server-distributed-replay.md
          - text: See more tools
            url: tools/overview-sql-tools.md