02
Microsoft Azure provides the ideal cloud destination for data modernization.
You can use the latest SQL Server engine and the power of Azure to help ensure
reliability, security, and high performance. Upgrading to Azure brings advanced
features and functionality to make your life a lot easier, including:
Enhanced performance, availability, and security
Cloud readiness and scalability
Management and programmability
Business intelligence, advanced analytics, and artificial intelligence (AI)
Various options are available on Azure for modernizing on-premises SQL
Server databases across organizational requirements and use cases: Azure
SQL Database with a single database, Azure SQL Database with elastic pools,
SQL Server on Azure Virtual Machines (infrastructure as a service, or IaaS),
and Azure SQL Database Managed Instance. Table 1 describes our focus in
more detail.
Chapter 02 Why Azure?
02
Why Azure?
02
Table 1: Azure SQL Database Managed Instance platform usage scenario
Target platform
Do not own the
application code, or
expensive to modify
Require high level
of compatibility
Use feature(s) of SQL Server
not yet supported by Azure
SQL Database
Rich instance-centric
programming model
Nearly 100 percent
compatibility
Resource guaranteed/SLA
at the instance level
Azure VNet isolation
Fully managed services
while retaining high level
of compatibility with
SQL Server
Support for SQL features
such as cross-database
queries, which are
unavailable in Azure
SQL Database
Reduced OPEX/CAPEX
Dynamic scale
Advanced security
Intelligent database
self-tuning
Azure SQL
Database
Managed
Instance
Use cases Platform delivers Value Unique benefits