Azure SQL Managed Instance - Microsoft

[Pages:32]Azure SQL Managed Instance

A fully managed SQL Server in the cloud

Mladen Andzic Program Manager, Azure SQL mlandzic@

Agenda

When to choose SQL Managed Instance What to expect with SQL MI What's new and what's coming next

Azure SQL

The family of SQL database services on Azure

Service

SQL Server on Azure Virtual Machines

Best for lift and shift migrations and apps requiring

OS-level access and control

Azure SQL Managed Instance

Best for modernizing existing apps

Azure SQL Database

Best for supporting modern cloud apps

Resource model

virtual machine

Automated manageability features

and OS-level access

Infrastructure-as-a-Service (IaaS)

instance

Offers high compatibility with SQL Server and native VNET support

database

Pre-provisioned or serverless compute and Hyperscale storage to meet specific workload

requirements

Platform-as-a-Service (PaaS)

Familiarity

Tools

Flexibility

Which Azure SQL offering is right for you?

Migration, App Modernization, App Innovation

Control

Capabilities

Full control and capabilities of SQL Server instance

? OS level access

Customer Managed

? SQL Server versions 2008 - 2019

Yes

? Patching/Upgrades

? App or other services colocation

?

No

Fully managed SQL Server engine as a service

? Native restore and log shipping

? Cross-DB transactions and Linked Server

? Service Broker and Event Notifications

Yes

Microsoft Managed

? SQL Agent and Transactional Replication ? .NET CLR integration and ML Services

No

Fully managed SQL database as a service

Yes

? A database scoped programming model

SQL Server on Azure VMs

Azure SQL Managed Instance

Azure SQL Database

What to expect with SQL MI

Hardware allocation, deployment of service binaries

Tier selection, instance sizing, operation scheduling

Service deployment

What service is providing for you

What is under your control

Service updates and patches (OS, SQL)

Updates of database schema, compat level change

Keeping system up-to-date

What service is providing for you

What is under your control

Service-aided subnet configuration

Filtering & routing data traffic, Express Route configuration

Network security & connectivity

What service is providing for you

What is under your control

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download