azure synapse
#azure-synapse#azure-sql-managed-instance

Azure SQL Managed Instance >

This article provides an overview of Azure SQL Managed Instance, a fully managed platform as

a service (PaaS) database engine that handles most database management functions such as

upgrading, patching, backups, and monitoring without user involvement.

is a scalable cloud database service that’s always running on the

latest stable version of the

Database Engine

and a patched OS with

enterprise class

built-in availability SLA

, offering close to 100% feature compatibility with SQL Server. PaaS

capabilities built into Azure SQL Managed enable you to focus on domain-specific database

administration and optimization activities that are critical for your business while Microsoft

handles backups, as well as patching and updating of the SQL and operating system code,

which removes the burden on managing the underlying infrastructure.

If you’re new to Azure SQL Managed Instance, check out the

video from our in-depth

Azure SQL video series

:

is a PaaS service that has near 100% compatibility with the latest

Enterprise Edition SQL Server Database Engine. It provides a native

virtual network (VNet)

implementation that addresses common security concerns, and a

business model

favorable

to existing SQL Server customers. SQL Managed Instance enables existing SQL Server

customers to lift and shift their on-premises applications to the cloud with minimal application

and database changes. At the same time, SQL Managed Instance provides all PaaS capabilities

(automatic patching and version updates,

automated backups

,

high availability

) to drastically

reduce management overhead and the total cost of ownership (TCO).

Note

and get 720 vCore hours on a General

Purpose SQL Managed Instance with up to 100 databases per instance for the first 12

months.

https://learn.microsoft.com/shows/Azure-SQL-for-Beginners/Azure-SQL-Managed-

Instance-Overview-6-of-61/player

Note

was previously known as Azure Active Directory (Azure AD).