Azure SQL Managed Instance
[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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- managing data in azure sql database introduction to data
- microsoft ignite 2018
- azure sql database
- microsoft dp 200 implementing an azure data solution
- sql server 2016 ascent technology
- sql server 2016 cloud service
- 22nd june 2021 sql azure hyperscale o como microsoft
- socrates the new sql server in the cloud
- microsoft azure sql database step by step step by step
- chris sanders program manager
Related searches
- azure sql data classification
- azure sql database
- azure sql database hyperscale
- azure sql database version
- azure sql managed instance hyperscale
- azure sql server hyperscale
- azure sql database paas
- sql managed instance hyperscale
- azure sql connection string
- azure sql vs azure sql database
- azure sql vs sql databases
- azure sql managed instance vs sql db