SQL Server knowledge map

- x +

Platform
- Azure SQL docs
  - Azure Service Tiers docs
  - Azure SQL Database docs
    - Single database docs
    - Elastic Database (sharding) docs
    - Elastic Pools docs
    - Hyperscale docs
    - Serverless docs
    - Logical servers docs
    - Purchasing models (vCore,DTU) docs
    - What's New docs
  - Azure SQL Managed Instance docs
    - Single instance docs
    - Instance Pools docs
    - Purchasing models (vCore) docs
    - Known issues docs
    - What's New docs
  - SQL Server on Azure VMs docs
    - SQL Server on a Linux VM docs
    - SQL Server on a Windows VM docs
    - SQL Server IaaS Agent extension docs
    - Licensing models docs
    - Virtual machines docs
  - Azure Synapse Analytics docs
  - SQL Server on Azure Arc-enabled servers docs
  - Azure Arc-enabled data services docs
  - Azure VMs docs
  - Feature comparison docs
  - Service Level Agreements docs
- SQL Server docs
  - SQL Server on Windows docs
    - 2019 docs
      - Editions & Features docs
      - Release Notes docs
      - What's New docs
    - 2017 docs
      - Editions & Features docs
      - Release Notes docs
      - What's New docs
    - 2016 docs
      - Editions & Features docs
      - Release Notes docs
      - What's New docs
  - SQL Server on Linux docs
    - 2019 docs
    - 2017 docs
  - Express LocalDB docs
  - SQL Server Compact docs
- Azure Data Architecture Guide docs
- Azure Well-Architected Framework docs
- Reference Architectures docs

Deployment
- Azure SQL docs
  - Azure Portal docs
  - Azure CLI docs
    - Azure CLI samples docs
  - Cloud Shell docs
  - Powershell docs
    - Powershell samples docs
  - REST API docs
  - ARM templates docs
    - ARM template samples docs
    - Azure Pipelines docs
    - GitHub Actions docs
  - Bicep templates docs
    - Azure Pipelines docs
    - GitHub Actions docs
- On-premises install docs
  - Planning docs
  - Command line docs
  - Configuration docs
  - Configuration file docs
  - Wizard docs
  - Upgrade docs
  - Uninstall docs

Migration docs
- Cloud Adoption Framework docs
- Azure Migrate docs
- Migrate to Azure SQL docs
- Data Migration Assistant (DMA) docs
- Azure Database Migration Service (DMS) docs
- Azure SQL Migration extension for Azure Data Studio docs
- SSMS docs
- Database Experimentation Assistant (DEA) docs
- SQL Server Migration Assistant (SSMA) docs
- Query Tuning Assistant docs
- Azure Data Box docs
- Post-migration Validation & Optimization docs

Connection
- Azure connectivity architecture
  - Azure SQL Database docs
  - Azure SQL Managed Instance docs
- Connection strings docs
  - Shared Memory docs
  - Named Pipes docs
  - TCP/IP Sockets docs
- Drivers docs
  - Microsoft OLE DB Driver for SQL Server docs
  - Microsoft ODBC Driver for SQL Server docs
  - SQL Server Native Client (SQLNCLI) docs
  - SQL Server Native Client OLE DB docs
  - SQL Server Native Client ODBC docs
- Network configuration docs
  - Azure network access controls docs
  - Azure outbound firewall rules docs
  - Azure Private Link docs
  - Azure VNet endpoints docs
  - SQL Server pipes docs
  - SQL Server ports docs
- Troubleshooting docs
  - CSS_SQL_Networking_Tools docs
- Transmission protocols docs
- SQL Server Browser Service docs
- Dedicated Admin Connection (DAC) docs
- Admin lock-out docs

Security
- Advanced Threat Protection docs
- Auditing docs
  - Azure SQL Database docs
  - Azure SQL Managed Instance docs
  - SQL Server docs
- Authentication and access docs
  - Azure AD Authentication docs
  - Windows Authentication for Azure AD docs
- Automated patching on SQL VMs docs
- Azure DNS Aliases docs
- Azure Policy docs
- Azure SQL Database Ledger docs
- Azure SQL Database server roles docs
- Azure SQL Database database roles docs
- Configuration docs
  - TRUSTWORTHY Database Property docs
- Credentials docs
- Data Discovery and Classification docs
- Dynamic Data Masking docs
- Encryption docs
  - Always Encrypted docs
  - Always Encrypted with secure enclaves docs
  - Azure Key Vault Integration docs
  - Certificates & Keys docs
  - Encryption Algorithm docs
  - Encryption hierarchy docs
  - Encryption Keys docs
  - Transparent Data Encryption (TDE) docs
- Extended Protection connections docs
- Microsoft Defender for SQL docs
- Password policy docs
- Permissions docs
- Row-level security docs
- Security baselines (Azure) docs
- Secure public endpoints (MI) docs
- Server trust groups (MI) docs
- SQL injection docs
- SQL Vulnerability Assessment (VA) docs
- Surface area configuration docs

HADR
- Azure Backup docs
- Azure Site Recovery docs
- Backup and restore docs
  - Azure SQL automated backups docs
  - Hyperscale backups docs
  - Manual backups docs
  - Manual restore docs
  - File-snapshot backups docs
  - SQL Server Managed Backup to Microsoft Azure docs
  - Automated Backup v2 for Azure VMs docs
- Azure SQL business continuity docs
  - Azure SQL database active geo-replication docs
  - Auto-failover groups
    - Azure SQL database docs
    - Azure SQL Managed Instance docs
  - Azure SQL Server on Azure VMs docs
    - Availability Sets docs
    - Availability Zones docs
  - High availability docs
  - Outage recovery docs
  - Recovery drills docs
- SQL Server business continuity docs
  - Windows Server Failover Clusters docs
  - Always On Availability Groups docs
  - Always On Failover Cluster Instance docs
  - Managed Instance Link docs
  - Database Mirroring docs
  - Log shipping docs
- Azure Service Health Alerts docs

Internals docs
- Query Processing Architecture docs
- Thread & Task Architecture docs
- Memory Management Architecture docs
- Transaction Locking & Row Versioning Guide docs
- Transaction Log Architecture & Management Guide docs
- Index Architecture & Design docs
- Ghost record cleanup process docs

Development
- Basic
  - Transact-SQL docs
    - Data types docs
    - Language Elements docs
    - Queries docs
    - Statements docs
  - Collation docs
  - Cursors docs
  - Databases docs
  - Errors docs
  - Error severities docs
  - Functions docs
  - Indexes docs
  - Joins docs
  - Scripting docs
  - Stored procedures docs
  - Subqueries docs
  - Synonyms docs
  - Tables docs
  - Triggers
    - Logon triggers docs
    - DDL triggers docs
    - DML triggers docs
  - User-defined functions docs
  - Views docs
- Advanced
  - Change Data Capture (CDC) docs
  - Change tracking docs
  - Common Language Runtime (CLR) docs
  - Data Quality Services (DQS) docs
  - Distributed Transactions docs
  - Elastic Database Transactions docs
  - Event notification docs
  - Extended Stored Procedures docs
  - Filestream docs
  - Filetable docs
  - Full-text search docs
  - Hierarchical data docs
  - JSON docs
  - Language Extensions (Java, C#, Python, and R) docs
  - Polybase docs
  - Remote Blob Store (RBS) docs
  - Sequence numbers docs
  - Service Broker docs
  - Spatial data docs
  - SQL Graph docs
  - Temporal tables (Azure) docs
  - Temporal tables (SQL Server) docs
  - XML data docs
  - xQuery docs
- Move Data docs
  - Azure BACPAC Import docs
  - Azure BACPAC Export docs
  - Azure Data Factory docs
  - Azure Data Sync docs
  - Bulk data docs
    - Azure blob storage docs
    - bcp docs
    - BULK INSERT/OPENROWSET(BULK...) docs
    - Excel docs
    - Import Flat File Wizard docs
    - XML documents docs
  - Data tier applications DACPAC/BACPAC docs
  - Import and Export Wizard docs
  - Replication (SQL Server) docs
  - Replication (Managed Instance) docs
  - SQL Server Integration Services (SSIS) docs

Performance docs
- Monitoring docs
  - Activity Monitor (SSMS) docs
  - Azure Monitor docs
  - Data Collector docs
  - Diagnosing latch contention docs
  - Diagnosing spinlock contention docs
  - Dynamic Management Views docs
    - Wait stats docs
  - Error Logs docs
  - Event Logs docs
  - Extended events docs
  - Performance baselines docs
  - Performance Dashboard (SSMS) docs
  - Performance Monitor (perfmon) docs
  - Query Store docs
  - SQL Server Profiler docs
  - SQL Server Replication Monitor docs
  - SQL Trace docs
- Remediation
  - Accelerated database recovery (ADR) docs
  - Automatic Tuning docs
  - Buffer Pool Extension docs
  - Columnstore indexes docs
  - Database Tuning Advisor (DTA) docs
  - Database Engine Tuning Advisor docs
  - DBCC CLONEDATABASE docs
  - Elastic database (sharding) docs
  - Execution plans docs
  - In-Memory OLTP (Azure) docs
  - In-Memory OLTP (SQL Server) docs
  - Indexes docs
  - Live Query Statistics (LQS) docs
  - Partitions docs
  - Plan guides docs
  - Query Store docs
  - Query Tuning Assistant (QTA) docs
  - Read Scale-Out docs
  - Resource Governor docs
  - Scale up/down docs
  - Statistics docs
  - Storage Spaces (RAID) docs
  - Stretch database docs
  - Trace Flags docs

Administration
- Azure Billing docs
- Azure Service Tiers docs
- Azure SQL VM Best practices docs
- Azure SQL VM on a Dedicated Host docs
- Big Data Clusters docs
- Central Management Servers docs
- Checkpoints docs
- Configuration docs
- Data compression docs
- Database Mail docs
- DBCC docs
- Elastic Job agent docs
- Error Logs docs
- Event Logs docs
- Linked servers docs
- Log file viewer docs
- Log streaming export docs
- Maintenance Plans docs
- Maintenance windows docs
- Move Azure resources docs
- Policy-based management docs
- Resource limits docs
- Service Broker docs
- SQL Assessment API (Azure) docs
- SQL Assessment API (SQL Server) docs
- SQL Server Agent docs
- SQL Server Configuration Manager docs
- SQL Server Utility docs
- SQL Server VMs storage configuration docs
- System databases docs
- Trace Flags docs
- Transaction Log Management docs

Tools docs
- Command-line docs
  - azcopy docs
  - Azure CLI docs
  - Azure PowerShell docs
  - bcp (Bulk Copy Program) docs
  - dreplay (Distributed Replay) docs
  - dta (Database Tuning Advisor) docs
  - mssql-cli docs
  - mssql-conf docs
  - mssql-scripter docs
  - osql docs
  - profiler (SQL Server Profiler) docs
  - sqlagent90 (SQL Server Agent) docs
  - sqlcmd docs
  - sqldiag docs
  - sqllocaldb docs
  - sqllogship docs
  - sqlmaint docs
  - sqlpackage docs
  - sqlps (utility) docs
  - sqlps (PowerShell) docs
  - sqlservr docs
  - ssbdiagnose (SSB Diagnose) docs
  - ssms (SQL Server Management Studio) docs
  - tablediff docs
- Azure Data Studio docs
- Azure Portal docs
- Azure Portal Desktop docs
- Azure Portal Mobile docs
- Database Engine Tuning Advisor (DTA) docs
- SQL Server Backup to Microsoft Azure Tool docs
- SQL Server Configuration Manager docs
- SQL Server Data Tools (SSDT) docs
- SQL Server Extended Features docs
- SQL Server Management Objects (SMO) docs
- SQL Server Management Studio (SSMS) docs
- SQL Server Profiler docs
- SQL Server Replication Monitor docs
- SQL Trace docs
- SQLXML docs
- Visual Studio Code docs
  - mssql extension docs
- Windows Management Instrumentation (WMI) docs

Reference
- Archived Content (SQL 2005-2012) docs
- Azure SQL Database REST API docs
- Azure SQL glossary of terms docs
- Database Samples docs
- Event classes docs
- Public data sets docs
- SQL Server PowerShell docs
- Transact-SQL (T-SQL) language reference docs
- T-SQL differences docs
- xQuery docs
- System objects
  - System catalog views docs
  - System compatability views docs
  - System dynamic management views docs
  - System functions docs
  - System information schema and views docs
  - System stored procedures docs
  - System tables docs
  - System views (PDW) docs
  - Transact-SQL Reference docs