mssql-docs

name	mssql-docs
skill_type	graph
description	Comprehensive reference documentation for Mssql Docs.
crawl_depth	2
source_url	https://learn.microsoft.com/en-us/sql/sql-server/
tags	["docs","reference","mssql-docs","knowledge-base"]

Mssql Docs Documentation

Comprehensive reference documentation for Mssql Docs.

Original Sources:

• https://learn.microsoft.com/en-us/sql/sql-server/

Contains: 459 markdown files with full folder structure (crawled at depth 2). Last updated: March 08, 2026

📚 Table of Contents

• 📁 database-engine_availability-groups_windows_overview-of-always-on-availability-groups-sql-server/
  • 📁 What-is-an-Always-On-availability-group/
    • Active Secondary Replicas
    • Additional Resources
    • Automatic Page Repair
    • Availability Databases
    • Availability Modes
    • Availability Replicas
    • Benefits
    • Client Connections
    • Configure Tls 1.3 Encryption
    • Feedback
    • In This Article
    • Interoperability And Coexistence With Other Database Engine Features
    • Next Step
    • Overview
    • Related Tasks
    • Session Timeout Period
    • Terms And Definitions
    • Types Of Failover
  • What is an Always On availability group?
  • Database Engine Availability Groups Windows Overview Of Always On Availability Groups Sql Server
• 📁 database-engine_database-mirroring_database-mirroring-sql-server/
  • Database Mirroring (SQL Server)
  • Database Engine Database Mirroring Database Mirroring Sql Server
  • Table of Contents
• 📁 database-engine_install-windows_install-sql-server/
  • SQL Server installation guide
  • Database Engine Install Windows Install Sql Server
  • Table of Contents
• 📁 database-engine_install-windows_upgrade-analysis-services/
  • Upgrade Analysis Services
  • Database Engine Install Windows Upgrade Analysis Services
  • Table of Contents
• 📁 database-engine_install-windows_upgrade-sql-server/
  • Upgrade SQL Server
  • Database Engine Install Windows Upgrade Sql Server
  • Table of Contents
• 📁 database-engine_log-shipping_about-log-shipping-sql-server/
  • About log shipping (SQL Server)
  • Database Engine Log Shipping About Log Shipping Sql Server
  • Table of Contents
• 📁 database-engine_sql-server-business-continuity-dr/
  • 📁 Business-continuity-and-database-recovery---SQL-Server/
    • Additional Resources
    • Cross Platform And Linux Distribution Interoperability
    • Disaster Recovery
    • Distributed Availability Groups
    • Feedback
    • High Availability
    • In This Article
    • Log Shipping
    • Migrations And Upgrades
    • Read Scale
    • Related Content
    • Sql Server Scenarios That Use Availability Features
    • Summary
  • Business continuity and database recovery - SQL Server
  • Database Engine Sql Server Business Continuity Dr
• 📁 en-us_azure_azure-sql_azure-sql-iaas-vs-paas-what-is-overview/
  • What is Azure SQL?
  • En Us Azure Azure Sql Azure Sql Iaas Vs Paas What Is Overview
  • Table of Contents
• 📁 en-us_azure_azure-sql_database_sql-database-paas-overview/
  • 📁 What-is-Azure-SQL-Database/
    • Additional Resources
    • Advanced Security And Compliance
    • Availability Capabilities
    • Built In Intelligence
    • Compute Tiers
    • Create Azure Sql Resources With The Azure Portal
    • Deployment Models
    • Easy To Use Tools
    • Engage With The Sql Server Engineering Team
    • Extensive Monitoring And Alerting Capabilities
    • Feedback
    • In This Article
    • Manage Azure Sql Resources With The Azure Portal
    • Overview
    • Purchasing Models
    • Related Content
    • Sql Database Frequently Asked Questions
    • Service Tiers
  • What is Azure SQL Database?
  • En Us Azure Azure Sql Database Sql Database Paas Overview
• 📁 en-us_azure_azure-sql_managed-instance_sql-managed-instance-paas-overview/
  • 📁 What-is-Azure-SQL-Managed-Instance/
    • Additional Resources
    • Advanced Security And Compliance
    • Authentication
    • Database Migration
    • Feedback
    • High Availability
    • In This Article
    • Key Features And Capabilities
    • License Free Dr Benefit
    • Managed Instance Link
    • Management Operations
    • Microsoft Entra Integration
    • Overview
    • Programmatically Identify A Sql Managed Instance
    • Related Content
    • Save On Costs
    • Service Tiers
    • Supported Sql Features
    • Vcore Based Purchasing Model
  • What is Azure SQL Managed Instance?
  • En Us Azure Azure Sql Managed Instance Sql Managed Instance Paas Overview
• 📁 en-us_training_student-hub/
  • AI Agents for Beginners - A Course
  • Provide feedback
  • Saved searches
  • Search code, repositories, users, issues, pull requests...
  • En Us Training Student Hub
  • microsoft/ai-agents-for-beginners
  • Table of Contents
• 📁 integration-services_import-export-data_import-and-export-data-with-the-sql-server-import-and-export-wizard/
  • Import and Export Data with the SQL Server Import and Export Wizard
  • Integration Services Import Export Data Import And Export Data With The Sql Server Import And Export Wizard
  • Table of Contents
• 📁 integration-services_install-windows_install-integration-services/
  • Install Integration Services (SSIS)
  • Integration Services Install Windows Install Integration Services
  • Table of Contents
• 📁 integration-services_install-windows_upgrade-integration-services/
  • Upgrade Integration Services
  • Integration Services Install Windows Upgrade Integration Services
  • Table of Contents
• 📁 linux_sql-server-linux-overview/
  • What is SQL Server on Linux?
  • Linux Sql Server Linux Overview
  • Table of Contents
• 📁 machine-learning_r_sql-server-r-services/
  • What is SQL Server 2016 R Services?
  • Machine Learning R Sql Server R Services
  • Table of Contents
• 📁 relational-databases_automatic-tuning_automatic-tuning/
  • Automatic tuning
  • Relational Databases Automatic Tuning Automatic Tuning
  • Table of Contents
• 📁 relational-databases_backup-restore_back-up-and-restore-of-sql-server-databases/
  • Back up and restore of SQL Server databases
  • Relational Databases Backup Restore Back Up And Restore Of Sql Server Databases
  • Table of Contents
• 📁 relational-databases_blob_filestream-sql-server/
  • FILESTREAM (SQL Server)
  • Relational Databases Blob Filestream Sql Server
  • Table of Contents
• 📁 relational-databases_blob_filetables-sql-server/
  • FileTables (SQL Server)
  • Relational Databases Blob Filetables Sql Server
  • Table of Contents
• 📁 relational-databases_collations_collation-and-unicode-support/
  • 📁 Collation-and-Unicode-support/
    • Additional Resources
    • Collation In Microsoft Fabric
    • Collation Terms
    • Collations In Azure Sql Database
    • Collations In Azure Sql Managed Instance
    • Complex Script Support
    • Feedback
    • Gb18030 Support
    • In This Article
    • Related Content
    • Related Tasks
    • Supplementary Characters
    • Utf 8 Support
    • Unicode Support
  • Collation and Unicode support
  • Relational Databases Collations Collation And Unicode Support
• 📁 relational-databases_event-classes_sql-server-event-class-reference/
  • SQL Server Event Class Reference
  • Relational Databases Event Classes Sql Server Event Class Reference
  • Table of Contents
• 📁 relational-databases_extended-events_extended-events/
  • Extended Events overview
  • Relational Databases Extended Events Extended Events
  • Table of Contents
• 📁 relational-databases_fuzzy-string-match_overview/
  • What is fuzzy string matching?
  • Relational Databases Fuzzy String Match Overview
  • Table of Contents
• 📁 relational-databases_graphs_sql-graph-overview/
  • Graph processing with SQL Server and Azure SQL Database
  • Relational Databases Graphs Sql Graph Overview
  • Table of Contents
• 📁 relational-databases_hierarchical-data-sql-server/
  • Hierarchical data (SQL Server)
  • Relational Databases Hierarchical Data Sql Server
  • Table of Contents
• 📁 relational-databases_import-export_import-flat-file-wizard/
  • Import Flat File to SQL Wizard
  • Relational Databases Import Export Import Flat File Wizard
  • Table of Contents
• 📁 relational-databases_in-memory-oltp_in-memory-oltp-in-memory-optimization/
  • In-Memory OLTP overview and usage scenarios
  • Relational Databases In Memory Oltp In Memory Oltp In Memory Optimization
  • Table of Contents
• 📁 relational-databases_indexes_indexes/
  • Indexes
  • Relational Databases Indexes Indexes
  • Table of Contents
• 📁 relational-databases_json_json-data-sql-server/
  • JSON data in SQL Server
  • Relational Databases Json Json Data Sql Server
  • Table of Contents
• 📁 relational-databases_logs_the-transaction-log-sql-server/
  • The transaction log
  • Relational Databases Logs The Transaction Log Sql Server
  • Table of Contents
• 📁 relational-databases_performance_database-engine-tuning-advisor/
  • Database Engine Tuning Advisor
  • Relational Databases Performance Database Engine Tuning Advisor
  • Table of Contents
• 📁 relational-databases_performance_joins/
  • Joins (SQL Server)
  • Relational Databases Performance Joins
  • Table of Contents
• 📁 relational-databases_performance_monitor-and-tune-for-performance/
  • Monitor and Tune for Performance
  • Relational Databases Performance Monitor And Tune For Performance
  • Table of Contents
• 📁 relational-databases_performance_monitoring-performance-by-using-the-query-store/
  • Monitor performance by using the Query Store
  • Relational Databases Performance Monitoring Performance By Using The Query Store
  • Table of Contents
• 📁 relational-databases_performance_performance-center-for-sql-server-database-engine-and-azure-sql-database/
  • Performance Center for SQL Server Database Engine and Azure SQL Database
  • Relational Databases Performance Performance Center For Sql Server Database Engine And Azure Sql Database
  • Table of Contents
• 📁 relational-databases_performance_subqueries/
  • Subqueries (SQL Server)
  • Relational Databases Performance Subqueries
  • Table of Contents
• 📁 relational-databases_polybase_polybase-guide/
  • Data virtualization with PolyBase in SQL Server
  • Relational Databases Polybase Polybase Guide
  • Table of Contents
• 📁 relational-databases_replication_sql-server-replication/
  • SQL Server Replication
  • Relational Databases Replication Sql Server Replication
  • Table of Contents
• 📁 relational-databases_search_full-text-search/
  • Full-Text Search
  • Relational Databases Search Full Text Search
  • Table of Contents
• 📁 relational-databases_security_authentication-access_create-a-login/
  • Create a login
  • Relational Databases Security Authentication Access Create A Login
  • Table of Contents
• 📁 relational-databases_security_dynamic-data-masking/
  • Row-level security
  • Relational Databases Security Dynamic Data Masking
  • Table of Contents
• 📁 relational-databases_security_encryption_always-encrypted-database-engine/
  • Always Encrypted
  • Relational Databases Security Encryption Always Encrypted Database Engine
  • Table of Contents
• 📁 relational-databases_security_encryption_transparent-data-encryption/
  • Transparent data encryption (TDE)
  • Relational Databases Security Encryption Transparent Data Encryption
  • Table of Contents
• 📁 relational-databases_security_permissions-database-engine/
  • Permissions (Database Engine)
  • Relational Databases Security Permissions Database Engine
  • Table of Contents
• 📁 relational-databases_security_row-level-security/
  • Row-level security
  • Relational Databases Security Row Level Security
  • Table of Contents
• 📁 relational-databases_security_security-center-for-sql-server-database-engine-and-azure-sql-database/
  • Security for SQL Server Database Engine and Azure SQL Database
  • Relational Databases Security Security Center For Sql Server Database Engine And Azure Sql Database
  • Table of Contents
• 📁 relational-databases_sequence-numbers_sequence-numbers/
  • Sequence numbers
  • Relational Databases Sequence Numbers Sequence Numbers
  • Table of Contents
• 📁 relational-databases_spatial_spatial-data-sql-server/
  • Spatial Data
  • Relational Databases Spatial Spatial Data Sql Server
  • Table of Contents
• 📁 relational-databases_statistics_statistics/
  • 📁 Statistics/
    • Additional Resources
    • Components And Concepts
    • Feedback
    • In This Article
    • Queries That Use Statistics Effectively
    • Related Content
    • Statistics Options
    • When To Create Statistics
    • When To Update Statistics
  • Statistics
  • Relational Databases Statistics Statistics
• 📁 relational-databases_stored-procedures_stored-procedures-database-engine/
  • Stored procedures (Database Engine)
  • Relational Databases Stored Procedures Stored Procedures Database Engine
  • Table of Contents
• 📁 relational-databases_synonyms_synonyms-database-engine/
  • Synonyms (Database Engine)
  • Relational Databases Synonyms Synonyms Database Engine
  • Table of Contents
• 📁 relational-databases_system-compatibility-views_system-compatibility-views-transact-sql/
  • System Compatibility Views (Transact-SQL)
  • Relational Databases System Compatibility Views System Compatibility Views Transact Sql
  • Table of Contents
• 📁 relational-databases_system-information-schema-views_system-information-schema-views-transact-sql/
  • System information schema views (Transact-SQL)
  • Relational Databases System Information Schema Views System Information Schema Views Transact Sql
  • Table of Contents
• 📁 relational-databases_system-stored-procedures_system-stored-procedures-transact-sql/
  • System stored procedures (Transact-SQL)
  • Relational Databases System Stored Procedures System Stored Procedures Transact Sql
  • Table of Contents
• 📁 relational-databases_tables_tables/
  • Tables
  • Relational Databases Tables Tables
  • Table of Contents
• 📁 relational-databases_user-defined-functions_user-defined-functions/
  • User-defined functions
  • Relational Databases User Defined Functions User Defined Functions
  • Table of Contents
• 📁 reporting-services_create-deploy-and-manage-mobile-and-paginated-reports/
  • What is SQL Server Reporting Services (SSRS)?
  • Reporting Services Create Deploy And Manage Mobile And Paginated Reports
  • Table of Contents
• 📁 reporting-services_install-windows_install-reporting-services/
  • Install and configure SQL Server Reporting Services
  • Reporting Services Install Windows Install Reporting Services
  • Table of Contents
• 📁 reporting-services_install-windows_upgrade-and-migrate-reporting-services/
  • Upgrade and migrate Reporting Services
  • Reporting Services Install Windows Upgrade And Migrate Reporting Services
  • Table of Contents
• 📁 sql-server_ai_vectors/
  • Vector search and vector indexes in the SQL Database Engine
  • Sql Server Ai Vectors
  • Table of Contents
• 📁 sql-server_artificial-intelligence-intelligent-applications/
  • Intelligent applications and AI
  • Sql Server Artificial Intelligence Intelligent Applications
  • Table of Contents
• 📁 sql-server_connect-to-database-engine/
  • Connect to the Database Engine
  • Sql Server Connect To Database Engine
  • Table of Contents
• 📁 sql-server_failover-clusters_windows_always-on-failover-cluster-instances-sql-server/
  • Always On failover cluster instances (SQL Server)
  • Sql Server Failover Clusters Windows Always On Failover Cluster Instances Sql Server
  • Table of Contents
• 📁 sql-server_what-is-sql-server/
  • What is SQL Server?
  • Sql Server What Is Sql Server
  • Table of Contents
• 📁 sql-server_what-s-new-in-sql-server-2025/
  • 📁 Whats-new-in-SQL-Server-2025/
    • Ai
    • Additional Resources
    • Analytics
    • Availability And Disaster Recovery
    • Breaking Changes
    • Database Engine
    • Developer
    • Discontinued Services And Deprecated Features
    • Edition Changes
    • Feature Highlights
    • Feedback
    • Get Sql Server 2025
    • In This Article
    • Language
    • Linux
    • Microsoft Fabric
    • More Videos
    • New Developer Editions
    • Power Bi Report Server
    • Query Store And Intelligent Query Processing
    • Related Content
    • Sql Server Analysis Services
    • Sql Server Integration Services
    • Security
    • Tools
    • Httpslearn.Microsoft.Comen Ussqlincludesmediaedit Topic Pencil.Svgviewsql Server Ver17 Contribute To Sql Documentation
    • Httpslearn.Microsoft.Comen Ussqlincludesmediainfo Tip.Svgviewsql Server Ver17 Get Help
  • What's new in SQL Server 2025
  • Sql Server What S New In Sql Server 2025
• 📁 ssdt_download-sql-server-data-tools-ssdt/
  • Install SQL Server Data Tools (SSDT) for Visual Studio
  • Ssdt Download Sql Server Data Tools Ssdt
  • Table of Contents
• 📁 ssdt_sql-server-data-tools/
  • SQL Server Data Tools
  • Ssdt Sql Server Data Tools
  • Table of Contents
• 📁 t-sql_data-types_data-types-transact-sql/
  • Data types (Transact-SQL)
  • T Sql Data Types Data Types Transact Sql
  • Table of Contents
• 📁 t-sql_functions_functions/
  • What are the SQL database functions?
  • T Sql Functions Functions
  • Table of Contents
• 📁 t-sql_language-reference/
  • Transact-SQL reference (Database Engine)
  • T Sql Language Reference
  • Table of Contents
• 📁 tools_bcp-utility/
  • 📁 bcp-utility/
    • Additional Examples
    • Additional Resources
    • Bulk Exporting Or Importing Sqlxml Documents
    • Character Mode C And Native Mode N Best Practices
    • Command Line Options
    • Computed Columns And Timestamp Columns
    • Considerations And Limitations
    • Data Validation
    • Download The Latest Version Of The Bcp Utility
    • Examples
    • Feedback
    • In This Article
    • Native Data File Support
    • Permissions
    • Related Content
    • Remarks
    • Specify Identifiers That Contain Spaces Or Quotation Marks
    • Syntax
    • Tds 8.0 Support
    • Httpslearn.Microsoft.Comen Ussqlincludesmediaedit Topic Pencil.Svgviewsql Server Ver17 Contribute To Sql Documentation
    • Httpslearn.Microsoft.Comen Ussqlincludesmediainfo Tip.Svgviewsql Server Ver17 Get Help
  • bcp utility
  • Tools Bcp Utility
• 📁 tools_sql-server-profiler_sql-server-profiler/
  • SQL Server Profiler
  • Table of Contents
  • Tools Sql Server Profiler Sql Server Profiler
• 📁 tools_sqldiag-utility/
  • SQLdiag utility
  • Table of Contents
  • Tools Sqldiag Utility
• 📁 tools_visual-studio-code-extensions_mssql_mssql-extension-visual-studio-code/
  • What is the MSSQL extension for Visual Studio Code?
  • Table of Contents
  • Tools Visual Studio Code Extensions Mssql Mssql Extension Visual Studio Code
• What is Analysis Services?
• Install SQL Server Analysis Services
• Microsoft Analytics Platform System
• Big Data Clusters
• SQL Connectivity and Drivers
• Connect Jdbc Understanding Ssl Support
• Database Engine Availability Groups Windows Overview Of Always On Availability Groups Sql Server
• Database Engine Sql Server Business Continuity Dr
• Dea Database Experimentation Assistant Overview
• Overview of Data Migration Assistant
• En Us Ai
• What is Analysis Services?
• En Us Answers Questions
• En Us Answers Questions Ask
• Tags
• En Us Answers Tags 108 Office Teams
• En Us Answers Tags 131 Office Outlook
• En Us Answers Tags 133 Azure
• En Us Answers Tags 60 Windows
• En Us Answers Tags 9 M365
• En Us Assessments
• En Us Azure
• En Us Azure Analysis Services
• Microsoft Copilot in Azure with Azure SQL Database
• Azure SQL Database documentation
• Application development overview - Azure SQL Database & Azure SQL Managed Instance
• En Us Azure Azure Sql Database Sql Database Paas Overview
• En Us Azure Azure Sql Managed Instance
• En Us Azure Azure Sql Managed Instance Sql Managed Instance Paas Overview
• Overview of SQL Server on Linux Azure Virtual Machines
• What's new with SQL Server on Azure Virtual Machines?
• What is SQL Server on Azure Windows Virtual Machines?
• En Us Azure Data Factory
• Azure Database Migration Service documentation
• Azure Machine Learning documentation
• En Us Azure Synapse Analytics
• What is SQL Server on Azure Windows Virtual Machines?
• Microsoft Compliance
• En Us Contribute
• En Us Copilot
• Microsoft Credentials
• DevOps resource center
• En Us Dotnet Api
• Microsoft Dynamics 365 documentation
• En Us Fabric Database Mirrored Database Sql Server
• En Us Fabric Database Sql Overview
• En Us Labs
• En Us Legal Termsofuse
• En Us Power Bi Power Bi Overview
• Power BI Report Server documentation
• En Us Power Platform
• En Us Powershell Sql Server Sql Server Powershell
• Previous versions
• SQL Server previous versions documentation
• Our principles for using AI-generated and machine-translated content on Microsoft Learn
• En Us Rest Api Sql
• Sample Code from Microsoft Developer Tools
• En Us Security
• En Us Sql
• En Us Ssms Copilot Copilot In Ssms Overview
• En Us Ssms Install Install
• En Us Ssms Quickstarts Ssms Connect Query Sql Server
• En Us Ssms Scripting Database Engine Scripting
• Discover your path
• Browse all training
• En Us Training Career Paths
• En Us Training Educator Center
• En Us Training Organizations
• En Us Troubleshoot
• Lp Sql Server Sql Education Center
• SQL machine learning documentation
• Powershell Sql Server Powershell
• Relational Databases Collations Collation And Unicode Support
• Relational Databases Errors Events Errors And Events Reference Database Engine
• Relational Databases Maintenance Plans Maintenance Plans
• Relational Databases Statistics Statistics
• Relational Databases System Catalog Views Catalog Views Transact Sql
• Relational Databases System Dynamic Management Views System Dynamic Management Views
• Relational Databases System Functions System Functions For Transact Sql
• Relational Databases System Tables System Tables Transact Sql
• Relational Databases System Views Replication Views Transact Sql
• Relational Databases Triggers Logon Triggers
• Relational Databases Views Views
• Relational Databases Xml Xml Data Sql Server
• SQL samples
• Sql Server
• Educational SQL resources
• Sql Server Migrate
• Sql Server Previous Versions Sql Server
• SQL Server docs navigation guide
• Sql Server Sql Server Get Help
• Sql Server What S New In Sql Server 2025
• Ssma Sql Server Migration Assistant
• Ssms Download Sql Server Management Studio Ssms
• Ssms Scripting Database Engine Scripting
• Ssms Sql Server Management Studio Ssms
• T Sql Functions Regular Expressions Functions Transact Sql
• Tools Bcp Utility
• Xquery Xquery Language Reference Sql Server

🤖 Agent Usage Guide

• When the user asks anything about Mssql Docs, consult the reference files.
• Prefer exact quotes and direct links to the relevant file/section.
• The hierarchical TOC above makes navigation fast and intuitive.
• All images and assets are preserved so links work perfectly.