Azure SQL Managed Instance
E56739
Azure SQL Managed Instance is a fully managed, cloud-based deployment option in Microsoft Azure that provides near 100% compatibility with on-premises SQL Server while offering automated management, scaling, and high availability.
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
Azure SQL deployment option
ⓘ
Platform as a Service ⓘ cloud database service ⓘ |
| announcedBy | Microsoft Azure SQL team ⓘ |
| compatibilityLevel | near 100% compatibility with SQL Server ⓘ |
| compatibilityWith | on-premises SQL Server ⓘ |
| deploymentModel |
cloud-based
ⓘ
fully managed ⓘ |
| developedBy | Microsoft ⓘ |
| hasFeature |
automated backups to Azure storage
ⓘ
automated database tuning (optional) ⓘ built-in high availability with SLA ⓘ business-critical tier ⓘ general-purpose tier ⓘ instance-level collation ⓘ instance-level jobs via SQL Agent ⓘ integration with Azure Key Vault ⓘ monitoring via Azure Monitor ⓘ multi-database transactions ⓘ native network isolation in VNet ⓘ near full SQL Server surface area ⓘ |
| offeredAs | PaaS alternative to SQL Server on Azure VMs ⓘ |
| partOf |
Azure SQL family
ⓘ
Azure ⓘ
surface form:
Microsoft Azure
|
| supports |
Always Encrypted
ⓘ
Azure Active Directory authentication ⓘ Azure Hybrid Benefit ⓘ CLR integration (with limitations) ⓘ SQL Server 2012 compatibility level and higher ⓘ SQL Server Agent ⓘ SQL Server ⓘ
surface form:
SQL Server Database Engine
Transparent Data Encryption ⓘ Virtual Network integration ⓘ automatic backups ⓘ automatic patching ⓘ automatic updates ⓘ cross-database queries ⓘ high availability ⓘ linked servers (with limitations) ⓘ native backup and restore ⓘ point-in-time restore ⓘ private IP addresses ⓘ reserved capacity pricing ⓘ scaling compute ⓘ scaling storage ⓘ |
| useCase |
enterprise line-of-business applications
ⓘ
lift-and-shift migration of SQL Server instances ⓘ modernization of on-premises SQL Server workloads ⓘ running multiple databases per instance ⓘ |
Referenced by (6)
Full triples — surface form annotated when it differs from this entity's canonical label.