Glossary
Search Azure terms
Open a clear definition, then continue into exam context, architecture, commands, operational examples, common mistakes, and related concepts.
Search all
Commands
Learning guides
Concept graph
Compare
Search-first Azure knowledge base
Term results
Search for a term or click a category. Results render only after you ask for them, so the glossary does not dump every available term on first load. Each result includes Quick peek and Open full term page actions.
Start with a search or a category.
Try managed identity , resource group , az group , private endpoint , or click Databases to load all database-related terms.
Showing 50 of 1,973 matching terms. Narrow the search to reduce the list.
Databases
premium
Azure SQL logical server
An Azure SQL logical server is a logical administrative construct for Azure SQL Database and related SQL resources. Microsoft Learn describes it as the central point for managing a collection of databases, including logins, firewall rules, auditing, threat detection policies, and failover groups.
Azure SQL Database
fundamentals
16 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL active geo-replication
Azure SQL active geo-replication creates readable secondary databases in other regions for database-level disaster recovery and failover.
Azure SQL Database
intermediate
5 commands
Aliases: Azure SQL active geo-replication, SQL geo-replication, active geo-replication, geo-secondary database
Quick peek
Open full term page
Databases
premium
Azure SQL auditing
Azure SQL auditing tracks database events and writes audit logs to supported destinations such as storage, Log Analytics, or Event Hubs.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL audit logs, Azure SQL auditing, SQL auditing, database auditing
Quick peek
Open full term page
Databases
premium
Azure SQL automated backup
Azure SQL automated backup automatically protects databases and supports point-in-time restore using service-managed backup chains.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL automated backup, Azure SQL automatic backups, SQL automated backups, point-in-time restore backups
Quick peek
Open full term page
Databases
premium
Azure SQL automatic tuning
Azure SQL automatic tuning monitors query performance and can apply tuning actions such as plan correction and index recommendations.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL automatic tuning, Azure SQL tuning recommendations, SQL automatic tuning, automatic tuning
Quick peek
Open full term page
Databases
premium
Azure SQL Business Critical tier
Azure SQL Business Critical tier is a vCore service tier for OLTP workloads that need high transaction rates, low-latency I/O, and high resilience through isolated replicas.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL Business Critical tier, Business Critical tier, BusinessCritical, Premium-like vCore tier, SQL Business Critical
Quick peek
Open full term page
Databases
premium
Azure SQL Database
Azure SQL Database is a fully managed relational database service in Azure that provides SQL Server-compatible engines as single databases, elastic pools, and serverless or provisioned compute choices. Microsoft Learn presents it as platform as a service with built-in availability, backups, patching, scaling, and security integration.
Database
intermediate
5 commands
Aliases: Azure SQL DB, Azure SQL Database, Azure SQL pooled database, Azure SQL single database, SQL Database
Quick peek
Open full term page
Databases
premium
Azure SQL database copy
Azure SQL database copy creates a transactionally consistent copy of an Azure SQL Database using portal, PowerShell, Azure CLI, or Transact-SQL.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL copy, Azure SQL database copy, CREATE DATABASE AS COPY OF, SQL database copy, database copy
Quick peek
Open full term page
Databases
premium
Azure SQL Database DTU model
Azure SQL Database DTU model is a purchasing model that bundles compute, storage, and I/O resources into Database Transaction Units for Basic, Standard, and Premium tiers.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL Database DTU model, DTU model, DTU-based purchasing model, Database Transaction Unit, eDTU
Quick peek
Open full term page
Databases
premium
Azure SQL elastic job
Azure SQL elastic jobs schedule and run Transact-SQL scripts across one or many Azure SQL databases, including target groups across servers, pools, and subscriptions.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure Elastic Jobs, Azure SQL elastic job, SQL elastic job agent, elastic job agent, elastic jobs
Quick peek
Open full term page
Databases
premium
Azure SQL elastic pool
Azure SQL elastic pool lets multiple Azure SQL databases on one logical server share a set of resources at a set price for variable usage patterns.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL elastic pool, SQL elastic pool, eDTU pool, elastic pool, pooled databases
Quick peek
Open full term page
Databases
premium
Azure SQL failover group
Provide a stable listener endpoint for applications that must survive an Azure SQL regional failover.; Coordinate failover for several related user databases instead of managing each geo-replica separately.
Azure SQL Database
intermediate
5 commands
Aliases: Azure SQL failover group, SQL failover group, auto-failover group, failover group, geo-failover group
Quick peek
Open full term page
Databases
premium
Azure SQL General Purpose tier
Azure SQL General Purpose tier is a vCore service tier for common workloads that need balanced compute and storage at budget-oriented pricing.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL General Purpose tier, GP tier, General Purpose tier, GeneralPurpose, SQL General Purpose
Quick peek
Open full term page
Databases
premium
Azure SQL geo-restore
Azure SQL geo-restore uses geo-replicated backups to restore a database to any logical server in any Azure region when primary-region access is unavailable.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL geo-restore, SQL geo restore, geo-replicated backup restore, geo-restore, regional backup restore
Quick peek
Open full term page
Databases
premium
Azure SQL hyperscale
Azure SQL Database Hyperscale is a service tier built for very large databases, fast storage scaling, rapid backups and restores, and high throughput. Microsoft Learn describes its distinct architecture, including separated compute and storage, page servers, log service, and optional replicas.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL ledger
A database capability or setting in Azure SQL Database that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL long-term retention
A database capability or setting in Azure SQL Database that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL maintenance window
A database capability or setting in Azure SQL Database that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL Microsoft Entra authentication
A database capability or setting in Azure SQL Database that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL point-in-time restore
A database capability or setting in Azure SQL Database that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL serverless compute
Run development, test, training, or demo databases that need full SQL behavior but sit idle outside work hours.; Support tenant databases with sporadic activity where provisioned compute would waste budget for long idle
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL serverless compute
Quick peek
Open full term page
Databases
premium
Azure SQL Query Store
Find the exact query plan regression that appeared after an application deployment or database compatibility-level change.; Compare normal and incident windows before deciding whether a SKU scale-up is justified.
Azure SQL Database
fundamentals
4 commands
Aliases: Azure SQL Query Store
Quick peek
Open full term page
Databases
premium
Azure SQL service objective
An Azure SQL service objective is the named performance level or SKU selected for an Azure SQL Database or elastic pool, defining resource limits, capabilities, and price within the chosen purchasing model.
Azure SQL Database
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL transparent data encryption
Azure SQL Transparent Data Encryption helps protect Azure SQL Database data, log files, and backups at rest by encrypting and decrypting database pages without requiring application changes.
Azure SQL Database
fundamentals
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL vCore model
The Azure SQL vCore purchasing model lets customers independently choose compute, storage, service tier, and hardware configuration for Azure SQL Database workloads.
Azure SQL Database
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL vulnerability assessment
Azure SQL vulnerability assessment is a Defender for Cloud capability that scans Azure SQL databases for security misconfigurations, risky settings, and findings that can be reviewed and remediated.
Azure SQL Database
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL zone redundancy
Azure SQL zone redundancy places database replicas or storage across multiple availability zones in a supported region to improve resilience against datacenter-level failures.
Azure SQL Database
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL tempdb
Azure SQL tempdb refers to the SQL engine temporary workspace used for temporary tables, table variables, internal worktables, sorting, version store activity, and other transient database operations.
Azure SQL Database
intermediate
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
field-manual-complete
Azure SQL firewall rule
An Azure SQL firewall rule is an allow-list entry for public network access to Azure SQL Database. It says which client IP address or range may connect to a logical server or a specific database. It does not replace identity, passwords, Microsoft Entra authentication, or private networking; it only decides whether the network connection is.
Azure SQL Database
intermediate
5 commands
Aliases: Azure SQL firewall rule, IP firewall rule, SQL firewall rule, database-level firewall rule, server-level firewall rule
Quick peek
Open full term page
Databases
field-manual-complete
Azure SQL private endpoint
A database capability or setting in Azure SQL Database that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure SQL Database
intermediate
5 commands
Aliases: Azure SQL private endpoint, azure-sql-private-endpoint, azure-sql-database, azure-sql-logical-server, private-endpoint, private-dns-zone, vnet-peering, managed-identity, app-service-vnet-integration, azure-sql-firewall-rule, service-endpoint
Quick peek
Open full term page
Databases
premium
Azure Managed Redis
Azure Managed Redis is a Microsoft-managed in-memory data store based on Redis Enterprise, used for low-latency caching, session storage, messaging, and semantic cache scenarios.
Managed cache
intermediate
6 commands
Aliases: Managed Redis, Redis Enterprise on Azure, Azure Redis Enterprise
Quick peek
Open full term page
AI and Machine Learning
premium
Azure AI Search indexer
An Azure AI Search indexer is the automated worker that fills a search index from another data source. Instead of your application pushing every document into Azure AI Search, the indexer pulls from places such as Blob Storage, Azure SQL, Cosmos DB, or Data Lake Storage. It can map fields, detect changes, crack documents, and run enrichment skills before writing searchable documents. It is useful when source data changes regularly.
AI platform and search
intermediate
5 commands
Aliases: Azure AI Search indexer, search indexer, indexer, azure-ai-search-indexer
Quick peek
Open full term page
Databases
premium
Azure Database for MySQL Flexible Server
A fully managed Azure database service for MySQL workloads with configurable compute, storage, backups, networking, maintenance, and high availability options.
Managed MySQL
intermediate
5 commands
Aliases: MySQL Flexible Server
Quick peek
Open full term page
Databases
premium
Azure Database for PostgreSQL Flexible Server
A fully managed Azure PostgreSQL service with configurable compute, storage, backups, networking, maintenance, extensions, and high availability options.
Managed PostgreSQL
intermediate
5 commands
Aliases: PostgreSQL Flexible Server
Quick peek
Open full term page
Databases
premium
Serverless SQL database
A serverless SQL database is an Azure SQL Database single database configured with the serverless compute model. It automatically scales compute within configured limits, can auto-pause in supported tiers, resumes on activity, and keeps the managed SQL Database platform features such as backups, patching, monitoring, and security.
Azure SQL Database
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Advanced threat protection for SQL
Advanced threat protection for SQL is the Defender for SQL capability that detects anomalous and potentially harmful database activity. In everyday Azure work, teams use it to surface SQL injection attempts, unusual access, unfamiliar principals, suspicious applications, or brute-force credential patterns. The useful evidence is Defender plan state, server or database protection setting, alert recipient,
Azure SQL
intermediate
4 commands
Aliases: SQL Advanced Threat Protection, Azure SQL threat detection, Defender for SQL ATP, ATP for Azure SQL
Quick peek
Open full term page
AI and Machine Learning
premium
Azure AI Search data source
Azure AI Search data source is the connection definition an Azure AI Search indexer uses to read content from a supported external data store.
AI platform and search
intermediate
4 commands
Aliases: Search data source, SearchIndexerDataSourceConnection, data source connection, indexer data source, search data source connection
Quick peek
Open full term page
Databases
premium
Azure Cosmos DB
Azure Cosmos DB is a fully managed database service for NoSQL, relational, and vector workloads. It supports global distribution, elastic scale, multiple APIs, request-unit capacity, backup, and high availability so modern applications can store and query data without operating database servers.
Azure Cosmos DB
fundamentals
4 commands
Aliases: Azure Cosmos DB, Cosmos DB, Azure Cosmos DB for NoSQL, Cosmos database, global NoSQL database, request-unit database
Quick peek
Open full term page
Databases
premium
Azure Cosmos DB for NoSQL
The native document database API of Azure Cosmos DB for JSON data, SQL-like queries, partitioning, indexing, and scalable request-unit throughput.
Azure Cosmos DB
intermediate
4 commands
Aliases: Cosmos DB NoSQL API, Azure Cosmos DB SQL API
Quick peek
Open full term page
Databases
premium
Microsoft Entra admin for SQL
Microsoft Entra admin for SQL is the Microsoft Entra identity designated to administer an Azure SQL logical server or SQL Managed Instance through Entra authentication. Teams should manage it with clear ownership, monitoring, rollback evidence, and production change discipline.
Azure SQL identity
intermediate
4 commands
Aliases: Azure SQL Entra admin, Azure AD admin for SQL, SQL Entra administrator
Quick peek
Open full term page
Databases
premium
Microsoft Entra authentication for SQL
Microsoft Entra authentication for SQL is the use of Microsoft Entra identities to authenticate to Azure SQL Database, SQL Managed Instance, or related SQL resources. Teams should manage it with clear ownership, monitoring, rollback evidence, and production change discipline.
Azure SQL identity
intermediate
4 commands
Aliases: Azure SQL Entra authentication, Azure AD authentication for SQL, SQL Entra auth
Quick peek
Open full term page
Analytics
top-250-pre130-priority-upgraded
Dedicated SQL pool
Dedicated SQL pool is a provisioned massively parallel processing data warehouse resource in Azure Synapse Analytics used for relational analytical queries at a selected DWU level in Azure.
Analytics platform
fundamentals
7 commands
Aliases: Dedicated SQL pool
Quick peek
Open full term page
Databases
verified
VNet injection for SQL MI
VNet injection for SQL MI means deploying Azure SQL Managed Instance inside a dedicated Azure virtual network subnet that is delegated to Microsoft.Sql/managedInstances, with required network rules so the managed instance has private connectivity and service management access.
Azure SQL Managed Instance
intermediate
6 commands
Aliases: SQL MI VNet injection, SQL Managed Instance subnet integration, SQL MI delegated subnet, managed instance VNet placement
Quick peek
Open full term page
Databases
complete
SQL automatic tuning
Microsoft Learn describes automatic tuning for Azure SQL as a managed performance capability that continuously monitors database queries, creates tuning recommendations, and can automatically apply corrective actions. It uses Query Store signals, verifies the impact of changes, and can revert actions that do not improve workload performance.
Azure SQL
intermediate
6 commands
Aliases: automatic tuning, Azure SQL automatic tuning, SQL auto tuning, automatic database tuning
Quick peek
Open full term page
Databases
complete
SQL compatibility level
Microsoft Learn explains that compatibility level controls database behavior for SQL Server, Azure SQL Database, and Azure SQL Managed Instance. It can be viewed or changed with Transact-SQL, requires ALTER permission on the database, and should be evaluated because changes can affect applications and query optimization.
Data platform
intermediate
6 commands
Aliases: database compatibility level, compatibility_level, SQL Server compatibility level, Azure SQL compatibility level
Quick peek
Open full term page
Databases
complete
SQL contained database user
Microsoft Learn describes contained database users as users that authenticate at the database level rather than through a matching login in the master database. In Azure SQL Database, they can support SQL authentication or Microsoft Entra identities, and the database name must be included in the connection string.
Data platform
intermediate
6 commands
Aliases: contained database user, database-contained user, Azure SQL contained user, CREATE USER FROM EXTERNAL PROVIDER
Quick peek
Open full term page
Databases
complete
SQL contained user
Microsoft Learn explains that a contained database user is a SQL user not connected to a login in the master database. For Microsoft Entra authentication, administrators create the user in the target database from an external provider, including users, groups, service principals, or managed identities.
Azure SQL
intermediate
6 commands
Aliases: contained user, database user without login, contained SQL user, database-scoped SQL user
Quick peek
Open full term page
Databases
complete
SQL active geo-replication
Microsoft Learn describes active geo-replication as a business continuity feature for Azure SQL Database that creates readable geo-secondary databases. If a regional disaster or large outage occurs, you can initiate geo-failover to a secondary database in another Azure region. promptly. quickly.
Azure SQL
intermediate
5 commands
Aliases: SQL active geo-replication, sql active geo replication, sql-active-geo-replication
Quick peek
Open full term page
Databases
complete
SQL Agent on Managed Instance
Microsoft Learn explains that SQL Server Agent executes SQL Agent jobs for task automation in Azure SQL Managed Instance. A job is a specified series of T-SQL scripts against a database, used to run administrative tasks one or more times and monitor success or failure.
Azure SQL Managed Instance
intermediate
5 commands
Aliases: SQL Agent on Managed Instance, sql agent on managed instance, sql-agent-on-managed-instance
Quick peek
Open full term page
Databases
complete
SQL auditing
Microsoft Learn explains that auditing for Azure SQL Database and Azure Synapse Analytics tracks database events and writes them to an audit log in an Azure storage account, Log Analytics workspace, or Event Hubs. It helps maintain regulatory compliance and understand database activity.
Azure SQL
intermediate
5 commands
Aliases: SQL auditing, sql auditing, sql-auditing
Quick peek
Open full term page
No glossary terms matched that search.
Try a service name, acronym, command group, or category such as RBAC , az group , App Service , Application Insights , Databases , or Azure AI Search .
Clear filters and show matches
Reset search