azure synapse
#azure-synapse#azure-sql-database

Azure SQL Database >

This article provides an overview of Azure SQL Database, a fully managed platform as a service

(PaaS) database engine that handles most of the database management functions such as

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

With Azure SQL Database, you can create a highly available and high-performance data storage

layer for the applications and solutions in Azure.

always runs on the latest stable version of the

SQL Database Engine

and patched OS.

offers an

enterprise-class availability SLA

, which is higher when

zone

redundancy

is implemented.

is a

multi-model database

, where you can store and work with data in

multiple formats, including both relational and non-relational data such as vector, graph,

JSON, XML, spatial data, and key-value pairs. You can avoid complexity of multiple

platforms and languages with modern cloud applications.

The

Hyperscale service tier

(recommended) offers the best

combination of price and performance, with no SQL license fee, and scalability up to 128 TB,

including a serverless compute option.

In Azure SQL Database, you can use advanced query processing features, such as

high-

performance in-memory technologies

and

intelligent query processing. In fact, the newest

capabilities of SQL Server are often released first to Azure SQL Database, and later to SQL Server

versions.

You get the newest SQL Server capabilities with no overhead for patching or upgrading, proven

across millions of databases in Azure. Azure SQL Database is a fully managed service that has

built-in high availability, backups, and other common maintenance operations. Microsoft handles

all patching and updating of the SQL and operating system code. You don’t have to manage the

Note

and get 100,000 vCore seconds of serverless

compute and 32 GB of storage every month.