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 493 matching terms. Narrow the search to reduce the list.
Databases
verified
Database
A named store of application data, tables, indexes, and metadata.
Database
intermediate
2 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Database compatibility level
A SQL database setting that controls engine behaviors and query-processing compatibility so applications can move versions without every feature changing at once.
Azure SQL
fundamentals
4 commands
Aliases: compatibility level, SQL compatibility level, Azure SQL compatibility level
Quick peek
Open full term page
Monitoring and Observability
premium
Database diagnostic settings
Azure Monitor routing rules that export database logs and metrics to Log Analytics, Storage, Event Hubs, or partner destinations for investigation and governance.
Azure Monitor
intermediate
4 commands
Aliases: SQL diagnostic settings, database diagnostics export, Azure Monitor diagnostic settings for databases
Quick peek
Open full term page
Databases
premium
Database server / account
The Azure resource boundary that owns database instances, authentication, networking, regional placement, and service-wide settings for a database workload.
Database platform
intermediate
4 commands
Aliases: database account, database server, database resource account, logical database server
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
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
Analytics
premium
Kusto database
Kusto database is a logical container inside an Azure Data Explorer cluster that holds tables, functions, policies, permissions, and ingestion/query configuration.
Azure Data Explorer database
Intermediate
5 commands
Aliases: ADX database, Azure Data Explorer database, Kusto DB
Quick peek
Open full term page
Analytics
premium
Kusto follower database
Kusto follower database is a read-only database attached from another Azure Data Explorer cluster so consumers can query leader data without copying it.
Azure Data Explorer data sharing
Advanced
5 commands
Aliases: ADX follower database, Azure Data Explorer follower database, followed database
Quick peek
Open full term page
Databases
premium
PostgreSQL database
A named PostgreSQL catalog inside a flexible server that holds schemas, tables, extensions, permissions, and application data.
Azure Database for PostgreSQL
fundamentals
5 commands
Aliases: PostgreSQL database, postgresql database, Azure Database for PostgreSQL database, database catalog, schema migration, charset, collation
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
Shared database throughput
Shared database throughput in Azure Cosmos DB means RU/s are provisioned at the database level and shared by containers in that database. Microsoft recommends container-level throughput for most workloads because shared throughput can create unpredictable performance and scale behavior across containers.
Azure Cosmos DB
intermediate
5 commands
Aliases: Cosmos DB shared database throughput, database-level throughput, shared RU/s database, Cosmos DB database throughput, shared throughput database
Quick peek
Open full term page
Databases
premium
Cosmos DB database
An Azure Cosmos DB database is a unit of management for one or more containers within an account and acts as a namespace for child resources.
Cosmos DB
fundamentals
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Hyperscale database
Hyperscale database is an individual Azure SQL Database configured to use the Hyperscale service tier and its scalable storage and compute architecture.
Azure SQL
intermediate
4 commands
Aliases: Azure SQL Hyperscale database, hyperscale database, Hyperscale database, Hyperscale SQL database
Quick peek
Open full term page
Databases
premium
MySQL database
MySQL database means a named database inside an Azure Database for MySQL server that stores application tables, users, routines, and data objects. You see it when developers create application data boundaries, run migrations, grant access, restore data, or separate tenant and service data. Think of it as the application data boundary inside the managed MySQL server. It matters because the setting changes how teams design, secure, operate, and troubleshoot the workload. Before changing it in production, know the owner, dependency, evidence, expected result, and rollback path.
Azure Database for MySQL
fundamentals
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Managed instance database
A managed instance database is a database hosted inside Azure SQL Managed Instance with managed platform operations and SQL Server compatibility features. Teams use it when a workload needs managed SQL operations while keeping instance-level features closer to SQL Server. In plain English, it gives operators a named control for database-level ownership, backup evidence, restore planning, and migration clarity within a managed instance instead of leaving the decision hidden in a portal setting, script, or deployment file. Treat it as production-ready only when the owner, dependencies, permission boundary, monitoring signal, and rollback evidence are clear.
Azure SQL Managed Instance
intermediate
3 commands
Aliases: Managed instance database, Azure SQL Managed Instance
Quick peek
Open full term page
Databases
field-manual-complete
Ledger database
Microsoft Learn describes a database ledger as part of SQL ledger, where ledger tables record cryptographic digests and history so organizations can verify protected data was not silently changed and produce evidence of database integrity for audits.
Azure SQL
fundamentals
11 commands
Aliases: No aliases yet
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
verified
Redis database
A Redis database is the keyspace and endpoint an application uses to store Redis keys, values, streams, sets, hashes, and other data structures. In Azure Managed Redis and Redis Enterprise, database settings govern clustering, eviction, access, persistence, and client connectivity inside the managed service.
Azure Managed Redis
fundamentals
5 commands
Aliases: Redis keyspace, Redis DB, Redis cache database
Quick peek
Open full term page
Databases
verified
Redis Enterprise database
A Redis Enterprise database is the database resource inside a Redis Enterprise cluster. It defines the actual Redis endpoint, port, clustering policy, modules, eviction policy, persistence settings, access-key behavior, and geo-replication links that applications use after the cluster is provisioned.
Data platform
intermediate
5 commands
Aliases: RedisEnterprise database, Enterprise database, Redis Enterprise DB
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse lake database
Synapse lake database is documented by Microsoft as part of the Synapse Analytics area in Azure.
Synapse Analytics
fundamentals
5 commands
Aliases: Azure Synapse lake database, Synapse database designer, Synapse lake database, lake database, lake-backed database, metadata over data lake, synapse lake database, synapse-lake-database
Quick peek
Open full term page
Databases
complete
Shared throughput database
A Cosmos DB database whose containers share provisioned request units from one database-level throughput pool.
Cosmos DB
intermediate
5 commands
Aliases: Cosmos DB shared throughput database, database-level throughput, shared database throughput, database RU/s pool
Quick peek
Open full term page
Databases
complete
Single database
A fully managed Azure SQL Database with its own compute, storage, backup, and service-tier settings under a logical server.
Azure SQL
fundamentals
5 commands
Aliases: Azure SQL single database, SQL single database, single Azure SQL database
Quick peek
Open full term page
Databases
complete
SQL database
Microsoft Learn describes Azure SQL Database as a fully managed relational database service where a single database is created on a logical server and configured with compute, storage, backup, security, and availability settings. It supports portal, PowerShell, Azure CLI, REST, and Transact-SQL operations for deployment and management.
Azure SQL
fundamentals
5 commands
Aliases: Azure SQL database, single SQL database, Azure SQL DB, SQL DB resource
Quick peek
Open full term page
Databases
complete
SQL database collation
Microsoft Learn explains that database collation defines the default rules for character data comparison, sorting, case sensitivity, accent sensitivity, and Unicode behavior. A database collation can be specified when creating or modifying a database, but existing column-level collations and stored data are not automatically changed.
Data platform
intermediate
5 commands
Aliases: database collation, SQL collation, Azure SQL collation, default database collation
Quick peek
Open full term page
Databases
complete
SQL database copy
Microsoft Learn describes database copy in Azure SQL Database as an operation that creates a new database from an existing database through the portal, Azure CLI, PowerShell, or Transact-SQL. The copy runs asynchronously, creates the target database after acceptance, and can require login remapping across servers.
Azure SQL
intermediate
5 commands
Aliases: database copy, Azure SQL database copy, copy database, SQL DB clone
Quick peek
Open full term page
Databases
complete
SQL database export
Microsoft Learn describes SQL database export as creating a BACPAC file that contains database schema and data and storing it in Azure Storage or local tooling output. Export can be started from the portal, PowerShell, Azure CLI, SqlPackage, SSMS, or supported developer tools.
Azure SQL
fundamentals
5 commands
Aliases: database export, Azure SQL BACPAC export, SQL export, export database to BACPAC
Quick peek
Open full term page
Databases
complete
SQL database firewall rule
Microsoft Learn describes Azure SQL firewall rules as IP allow rules that must permit traffic before clients can reach a logical server or database. Server-level rules can be managed through Azure tools, while database-level rules are scoped to individual databases and managed with Transact-SQL.
Data platform
intermediate
5 commands
Aliases: Azure SQL firewall rule, SQL server firewall rule, database-level firewall rule, SQL IP firewall rule
Quick peek
Open full term page
Databases
complete
SQL database import
SQL database import is the Azure SQL workflow that rebuilds a database from a BACPAC file stored in Azure Storage or supplied through tooling.
Azure SQL
fundamentals
5 commands
Aliases: Azure SQL Database import, BACPAC import, SQL import, database import operation
Quick peek
Open full term page
Analytics
field-manual-complete
Lake database
A lake database in Azure Synapse Analytics combines database design, metadata, and storage layout for data stored in the lake, helping teams describe structure and query files through shared Spark and serverless SQL metadata without turning the data lake into a traditional database.
Analytics platform
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL external table
A Synapse SQL external table is database metadata that lets Synapse SQL query files stored outside the database, usually in Azure Storage or ADLS Gen2. It references an external data source, file format, and file location for governed SQL analytics.
Synapse Analytics
fundamentals
6 commands
Aliases: external table in Synapse, Synapse external table, SQL external table, external table over lake files
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL on-demand
Synapse SQL on-demand is the serverless SQL pool model in Azure Synapse Analytics. It lets teams run T-SQL queries over data in the lake without provisioning dedicated warehouse capacity, storing only metadata objects while using external data sources, views, functions, and security objects.
Synapse Analytics
fundamentals
6 commands
Aliases: SQL on-demand, Synapse serverless SQL, serverless SQL in Synapse, built-in serverless SQL pool
Quick peek
Open full term page
Databases
learning-path-anchor
Synthetic partition key
A synthetic partition key is a partition key value you create because no single natural field distributes Cosmos DB data well enough. For example, tenantId alone may create one huge tenant partition, while date alone may concentrate today's traffic. A synthetic key might combine tenant, region, and date bucket into one stored value that...
Cosmos DB
intermediate
5 commands
Aliases: generated partition key, composite partition key value, calculated partition key, synthetic key
Quick peek
Open full term page
Storage
learning-path-anchor
Table Storage
Table Storage is Azure Storage for simple structured NoSQL records. You create tables, store entities, and identify each entity with a PartitionKey and RowKey. It is useful when the data is large, sparse, inexpensive to keep, and usually accessed by known keys. It is not a relational database, search engine, or analytics warehouse. The best fit is operational data that can be denormalized, read directly, updated independently, and kept cheap without requiring joins, stored procedures, or secondary indexes.
Table Storage
fundamentals
5 commands
Aliases: Azure Table Storage, Storage Tables, Azure Storage Tables, Azure Tables storage
Quick peek
Open full term page
Management and Governance
learning-path-anchor
Tags
Tags are labels you attach to Azure things so people and tools can understand what they are for. A tag has a name and a value, such as Owner=DataPlatform or Environment=Prod. Tags do not make a virtual machine faster, secure a database, or change a web app setting. They make the estate easier to organize, report on, govern, and automate. Useful tags answer questions the business actually asks: who owns this, what does it support, what environment is it, and who pays for it?
Tags and naming
advanced
5 commands
Aliases: Azure tags, resource tags, name-value tags, Azure metadata tags
Quick peek
Open full term page
Databases
learning-path-anchor
Cosmos DB continuous backup
Azure Cosmos DB continuous backup is the backup mode that supports point-in-time restore for supported Cosmos DB resources within a configured retention tier.
Azure Cosmos DB
fundamentals
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks schema
A Unity Catalog namespace under a catalog that groups tables, views, volumes, models, functions, and permissions.
Databricks
fundamentals
4 commands
Aliases: Unity Catalog schema, Databricks database schema, schema in Unity Catalog
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks secret scope
A named Databricks collection of secrets used to store credentials and grant controlled read or manage access to workloads.
Databricks
fundamentals
4 commands
Aliases: Databricks secrets scope, secret scope, Azure Databricks secrets
Quick peek
Open full term page
Databases
learning-path-anchor
Table
A table is the basic place where structured data lives in a database. Each row is one record, and each column describes one attribute, such as customer ID, order date, amount, or status. In Azure, tables show up in Azure SQL Database, SQL Managed Instance, Synapse dedicated SQL pools, Fabric warehouses, PostgreSQL, MySQL, and...
Database
intermediate
4 commands
Aliases: database table, SQL table, relational table, data table
Quick peek
Open full term page
Databases
learning-path-anchor
Temporary bytes
Disk space used by temporary files created during queries, sorts, hashes, or joins.
PostgreSQL
advanced
4 commands
Aliases: Temporary bytes, temporary bytes, Azure Temporary bytes, temp_bytes, Temporary Files Size, PostgreSQL temporary files
Quick peek
Open full term page
Monitoring and Observability
learning-path-anchor
Throughput
Throughput is the amount of work a system completes over time, such as requests, messages, bytes, events, or transactions per second. In Azure, teams measure it with service metrics, logs, and capacity settings to judge whether an app, database, storage account, or messaging pipeline can sustain demand.
Performance
intermediate
4 commands
Aliases: Throughput, throughput, Azure Throughput, Microsoft Learn Throughput, requests per second, events per second, transactions per second, bytes per second, work completed over time
Quick peek
Open full term page
Databases
learning-path-anchor
Time to live
Time to live in Azure Cosmos DB automatically expires items after a configured number of seconds. TTL can be set at the container level and overridden per item, helping teams remove stale operational data, limit storage growth, and keep queries focused on current records.
Azure Cosmos DB
intermediate
4 commands
Aliases: Time to live, time to live, Azure Time to live, Microsoft Learn Time to live, TTL, Cosmos DB TTL, defaultTtl, item expiration, container TTL
Quick peek
Open full term page
Databases
learning-path-anchor
Cosmos DB dedicated gateway
Azure Cosmos DB dedicated gateway is provisioned server-side compute that fronts an account and enables the integrated cache for supported NoSQL workloads.
Azure Cosmos DB
fundamentals
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
learning-path-anchor
Cosmos DB emulator
The Azure Cosmos DB emulator provides a local environment that emulates Azure Cosmos DB for development and testing without requiring a cloud account.
Azure Cosmos DB
fundamentals
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
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
Change feed processor
A database capability or setting in Azure Cosmos DB that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure Cosmos DB
fundamentals
15 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Conflict resolution policy
the container-level Cosmos DB setting that defines how write conflicts are resolved when more than one region can update the same data
Cosmos DB
intermediate
15 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
command-rich
Watermark column
In Azure Data Factory incremental copy patterns, a watermark column is a source column, often a last-modified timestamp or increasing key, used to identify rows created or changed since the previous run. The maximum value becomes the next stored watermark.
Data engineering and analytics
intermediate
5 commands
Aliases: incremental copy watermark column, high watermark column, delta load column, LastModified watermark
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