Search Azure terms

Databases complete SQL Managed Instance Microsoft Learn describes Azure SQL Managed Instance as a fully managed PaaS database engine with near complete SQL Server compatibility, native virtual network deployment, automated patching and backups, and instance-scoped features that help teams lift and shift SQL Server workloads with fewer application or database changes. Azure SQL fundamentals 5 commands Aliases: SQL MI, Azure SQL MI, Azure SQL Managed Instance, managed SQL instance Quick peek Open full term page

Databases complete SQL managed instance backup retention Microsoft Learn explains that automated backups for Azure SQL Managed Instance let teams restore a managed database to a specific point in time within the configured retention period, up to 35 days, while long-term retention policies can preserve selected backups for years when compliance requires it. SQL Managed Instance intermediate 5 commands Aliases: SQL MI backup retention, managed instance PITR retention, MI short-term retention, SQL MI restore window Quick peek Open full term page

Databases complete SQL managed instance distributed transaction Microsoft Learn describes DTC for Azure SQL Managed Instance as support for distributed transactions in mixed environments, including managed instances, SQL Server, other relational databases, custom applications, and transaction participants that can establish network connectivity to Azure and coordinate transaction outcomes safely. SQL Managed Instance intermediate 5 commands Aliases: SQL MI distributed transaction, managed instance DTC, Azure SQL MI DTC, distributed transaction coordinator Quick peek Open full term page

Databases complete SQL managed instance failover group Microsoft Learn describes failover groups for Azure SQL Managed Instance as a way to manage geo-replication and coordinated failover of all user databases from one managed instance to another managed instance in a different Azure region, with stable listener endpoints for application connectivity. SQL Managed Instance intermediate 5 commands Aliases: SQL MI failover group, managed instance failover group, instance failover group, SQL Managed Instance FOG Quick peek Open full term page

Databases complete SQL managed instance link Microsoft Learn describes the Managed Instance link as near real-time data replication between SQL Server and Azure SQL Managed Instance, enabling hybrid flexibility, database mobility, read-only workload offload, analytics in Azure, disaster recovery patterns, and migrations with planned or forced failover. SQL Managed Instance intermediate 5 commands Aliases: Managed Instance link, SQL MI link, Azure SQL MI link, MI link Quick peek Open full term page

Databases complete SQL Managed Instance maintenance window Microsoft Learn describes the maintenance window as a configurable schedule for Azure SQL Managed Instance maintenance events, helping teams make impactful platform updates more predictable and less disruptive by aligning them with approved operational windows instead of surprise business-hour interruptions. SQL Managed Instance intermediate 5 commands Aliases: SQL MI maintenance window, Azure SQL MI maintenance schedule, managed instance maintenance configuration Quick peek Open full term page

Databases complete SQL Managed Instance private endpoint Microsoft Learn describes private endpoints for Azure SQL Managed Instance as private IP-based connections that use Azure Private Link to provide secure, isolated client connectivity from virtual networks without exposing the managed instance network infrastructure to broader public paths. Properly. and DNS. SQL Managed Instance intermediate 5 commands Aliases: SQL MI private endpoint, Azure SQL MI Private Link, managed instance Private Link endpoint Quick peek Open full term page

Databases complete SQL Managed Instance public endpoint Microsoft Learn explains that Azure SQL Managed Instance can provide user connectivity through a public endpoint, but the configuration must be secured with network controls, port 3342 access rules, strong authentication, and careful operational review before production use. Always. Carefully. under explicit governance. SQL Managed Instance intermediate 5 commands Aliases: SQL MI public endpoint, Azure SQL MI public data endpoint, managed instance public data endpoint Quick peek Open full term page

Databases complete SQL Managed Instance service tier Microsoft Learn describes SQL Managed Instance service tiers as purchasing-model choices, such as General Purpose, Next-gen General Purpose, and Business Critical, that define architecture, storage limits, availability behavior, performance characteristics, and billing for a managed instance. Review it using workload evidence. for production database workloads. SQL Managed Instance intermediate 5 commands Aliases: SQL MI service tier, Azure SQL MI tier, managed instance tier, SQL Managed Instance SKU tier Quick peek Open full term page

Databases complete SQL Managed Instance storage size Microsoft Learn explains that SQL Managed Instance storage size is configured capacity for the instance, specified in supported increments, charged according to the maximum configured size, and constrained by service tier, hardware, and resource-limit rules. Review it before migrations begin. across shared database estates. planning. SQL Managed Instance advanced 5 commands Aliases: SQL MI storage size, Azure SQL MI storage capacity, managed instance storage capacity, storageSizeInGB Quick peek Open full term page

Databases complete SQL managed instance subnet Microsoft Learn describes a SQL Managed Instance subnet as a dedicated subnet in an Azure virtual network that must meet SQL Managed Instance network requirements before deployment. Its address range, network configuration, routing, and available IP capacity determine where managed instances can be placed and expanded. SQL Managed Instance intermediate 5 commands Aliases: Azure SQL Managed Instance subnet, SQL MI subnet, managed instance dedicated subnet Quick peek Open full term page

Databases complete SQL managed instance virtual cluster Microsoft Learn describes the SQL Managed Instance virtual cluster as service-managed infrastructure that hosts managed instances inside a customer virtual network subnet. The virtual cluster contains isolated virtual machines and VM groups, supports management operations, and is created or changed as instances are deployed, scaled, or removed. SQL Managed Instance intermediate 5 commands Aliases: SQL MI virtual cluster, Azure SQL Managed Instance virtual cluster, managed instance platform cluster Quick peek Open full term page

Databases complete SQL managed instance zone redundancy Microsoft Learn describes SQL Managed Instance zone redundancy as a high-availability configuration that spreads managed instance components across Azure availability zones in supported regions. It improves protection from datacenter-level failures while preserving the managed instance endpoint and using Azure SQL platform redundancy rather than application-managed failover. SQL Managed Instance intermediate 5 commands Aliases: SQL MI zone redundancy, Azure SQL Managed Instance zone redundancy, zone redundant managed instance 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 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 premium Managed Instance failover group Managed Instance failover group is a disaster-recovery relationship that lets databases in a SQL Managed Instance fail over to a paired managed instance. Teams use it when business-critical databases need cross-region continuity and a managed failover path. In plain English, it gives operators a named control for planned or emergency recovery with clearer listener, replication, and ownership evidence 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 failover group, Azure SQL Managed Instance Quick peek Open full term page

Databases premium field-manual Managed instance link Managed Instance link is a SQL Managed Instance feature that links SQL Server to Managed Instance for migration, replication, or hybrid continuity scenarios. Teams use it when teams need to move SQL Server databases to Azure with controlled replication and cutover planning. In plain English, it gives operators a named control for migration evidence, replication visibility, and lower-risk transition from on-premises SQL Server 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 link, Azure SQL Managed Instance Quick peek Open full term page

Databases premium field-manual Managed instance virtual cluster Managed Instance virtual cluster is an Azure-managed infrastructure grouping that hosts one or more SQL Managed Instances inside a subnet. Teams use it when teams deploy, scale, move, or delete managed instances and need to understand the hidden infrastructure boundary. In plain English, it gives operators a named control for clearer expectations for provisioning time, subnet planning, instance placement, and cleanup behavior 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 virtual cluster, Azure SQL Managed Instance Quick peek Open full term page

Databases premium Instance pool Instance pool controls how multiple small Azure SQL Managed Instances share capacity for migrations that need instance-level compatibility with lower per-instance overhead. Teams see it in azure sql managed instance pools, virtual clusters. It is not an Azure SQL elastic pool, a VM scale set, a Hyperscale database, or a shared SQL Server instance; confusing them can create capacity exhaustion, subnet design mistakes. Use the term when reviewing access, monitoring, cost, recovery, or performance. It keeps architects, operators, security reviewers, and support teams focused on the same setting, resource, or behavior. Azure SQL Managed Instance Intermediate 5 commands Aliases: SQL Managed Instance pool, Azure SQL instance pool, managed instance pool, SQL MI instance pool 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 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

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 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 MI maintenance configuration Microsoft Learn describes SQL Managed Instance maintenance configuration as the setting that assigns a maintenance window to Azure SQL resources. It lets teams choose when impactful planned maintenance should occur, making platform updates more predictable and less disruptive for workloads with sensitive business hours. Azure SQL Managed Instance intermediate 5 commands Aliases: SQL Managed Instance maintenance configuration, SQL MI maintenance window, maintenanceConfigurationId Quick peek Open full term page

Databases complete SQL MI private endpoint Microsoft Learn describes a private endpoint for Azure SQL Managed Instance as a Private Link connection that gives clients in another virtual network a private IP path to the managed instance. It supports isolated client connectivity and requires correct DNS resolution for successful connections. Azure SQL Managed Instance advanced 5 commands Aliases: SQL Managed Instance private endpoint, Azure SQL MI Private Link, managedInstance private endpoint Quick peek Open full term page

Databases complete SQL Microsoft Entra authentication Microsoft Learn describes Microsoft Entra authentication for Azure SQL as using identities from Microsoft Entra ID to authenticate to Azure SQL Database, Azure SQL Managed Instance, Synapse SQL, and related SQL platforms. It supports users, groups, applications, and managed identities while database permissions still control authorization. Azure SQL security and identity intermediate 5 commands Aliases: Azure SQL Entra authentication, Microsoft Entra authentication for Azure SQL, Azure AD authentication for SQL, Entra ID SQL authentication Quick peek Open full term page

Databases complete SQL Query Store Microsoft Learn describes Query Store as a SQL feature that captures a history of queries, execution plans, and runtime statistics for review. It helps troubleshoot performance changes, especially regressions caused by plan changes, and is available across SQL Server, Azure SQL Database, Azure SQL Managed Instance, and related SQL platforms. SQL performance monitoring intermediate 5 commands Aliases: Query Store, Azure SQL Query Store, SQL Server Query Store, query performance history 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 premium Flexible server A flexible server is the Azure Database deployment model for managed PostgreSQL or MySQL servers with configurable compute, storage, availability, maintenance, backup, and networking options. Teams use it to host managed relational databases with more control over maintenance windows, compute tiers, backup retention, high availability, private networking, stop-start behavior, and performance settings. It is not a self-managed VM database, a single-server compatibility promise, a free unlimited database tier, or proof that schema design, indexes, failover, and application connection pooling are correct. Azure managed databases intermediate 6 commands Aliases: Azure Database flexible server, PostgreSQL flexible server, MySQL flexible server, managed flexible database server Quick peek Open full term page

Databases premium Automatic tuning Automatic tuning is Azure SQL Database’s built-in assistant for common query performance problems. In plain terms, Azure watches how queries behave and can recommend or apply changes that improve performance, such as index adjustments or plan correction. It is useful when workloads change faster than people can manually tune every query.. Azure SQL intermediate 4 commands Aliases: Azure SQL automatic tuning, SQL automatic tuning, automatic plan correction, automatic index tuning 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

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 Long-term backup retention Long-term backup retention is the Azure SQL feature for keeping selected automated full database backups in redundant Azure Blob storage for months or years, up to supported policy limits, so databases can be restored for compliance, audit, and recovery needs. Azure SQL intermediate 4 commands Aliases: No aliases yet Quick peek Open full term page

Databases field-manual-complete Primary key A primary key is the column, or set of columns, that gives every row in a table its own identity. Think of it as the database rule that says, “no two rows can be confused for each other.” In Azure SQL, PostgreSQL, MySQL, Synapse, and application databases hosted on Azure, primary keys help joins, updates, deletes, imports, and audits target the right record. A good key is stable, unique, and practical. A bad key creates duplicate data, slow joins, broken migrations, and confusing application bugs. Database intermediate 5 commands Aliases: No aliases yet Quick peek Open full term page

Databases field-manual-complete Transparent data encryption Transparent data encryption helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics by encrypting data, backups, and transaction logs at rest. Encryption and decryption happen in real time without requiring application changes, with service-managed or customer-managed key options. Azure SQL intermediate 5 commands Aliases: TDE, SQL transparent data encryption, Azure SQL TDE, database encryption at rest, TDE protector Quick peek Open full term page

Databases premium field-manual Max connections The max connections setting is the configured or effective limit on how many client sessions can connect to a database server at one time. Teams use it when applications, pools, jobs, or services risk exhausting database connection capacity. In plain English, it gives operators a named control for controlled concurrency, safer pooling design, and clearer troubleshooting for connection storms 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. Database connection limits intermediate 4 commands Aliases: Max connections, maximum connections, concurrent connections, connection limit, max_connections, database connection limit, maximum database connections, Azure Database and Azure SQL platforms, Database connection limits Quick peek Open full term page

Analytics learning-path-anchor Synapse workspace managed identity A Synapse workspace managed identity is the workspace's own identity in Microsoft Entra ID. Instead of saving passwords, keys, or connection strings inside pipelines and notebooks, Synapse can use this identity to ask for tokens and reach trusted Azure resources. It is commonly used for Data Lake Storage, Key Vault, SQL, and linked service... Synapse Analytics intermediate 8 commands Aliases: Synapse managed service identity, Synapse MSI, workspace system-assigned identity, Synapse workspace identity 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

Identity learning-path-anchor System-assigned managed identity A system-assigned managed identity lets one Azure resource authenticate without a stored password, client secret, or certificate managed by your app team. You turn it on for a resource such as a web app, function, virtual machine, data factory, or automation account. Azure creates an identity for that resource, and the resource can request... Managed identities intermediate 4 commands Aliases: system assigned identity, resource managed identity, SystemAssigned identity, managed service identity 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 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

Analytics premium Synapse SQL administrator A Synapse SQL administrator is the Synapse RBAC role focused on serverless SQL access and SQL artifacts. It grants broad serverless SQL pool permissions plus create, read, update, and delete access to published SQL scripts, credentials, and linked services within a workspace. Synapse Analytics intermediate 6 commands Aliases: Synapse SQL Administrator, Synapse SQL admin, SQL administrator in Synapse, Synapse SQL admin role 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 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 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 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

Analytics premium Serverless SQL pool Serverless SQL pool in Azure Synapse Analytics lets users query data in the lake with T-SQL without provisioning dedicated SQL compute. It stores only metadata objects in databases, supports SELECT, CETAS, views, credentials, users, and object permissions, and charges based on data processed by queries. Azure Synapse Analytics fundamentals 5 commands Aliases: No aliases yet Quick peek Open full term page

Analytics learning-path-anchor Synapse SQL CETAS Synapse SQL CETAS means CREATE EXTERNAL TABLE AS SELECT. It creates external table metadata and exports the result of a T-SQL SELECT statement in parallel to files in Azure Storage or Azure Data Lake Storage Gen2 for later SQL or lake consumption. Synapse Analytics fundamentals 6 commands Aliases: CREATE EXTERNAL TABLE AS SELECT, CETAS, Synapse CETAS, serverless SQL CETAS 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