What are the options for managed SQL databases on Azure?

Question

Azure SQL is available via three deployment models: Single Database—a single database, deployed to an Azure VM and managed with a SQL Database server. This is the most basic deployment model. Elastic Pool—a group of connected databases that share pooled resources. Managed Instance—a fully-managed database instance.

What are the different types of databases in SQL Azure?

Azure offers a choice of fully managed relational, NoSQL and in-memory databases, spanning proprietary and open-source engines, to fit the needs of modern app developers.

What are the options for data management in Azure?

Each of the platform's data management options—SQL Database, SQL Server in a VM, Blob Storage, and Table Storage—has strengths and weaknesses.

Is Azure SQL Database fully managed?

Azure SQL Database is a fully managed database service, which means that Microsoft operates SQL Server for you, and ensures its availability and performance. SQL Database also includes innovative features to enhance your business continuity, such as built-in high availability.

What is the difference between Azure SQL Database and Azure SQL Database managed instance?

The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine.

Expert · Answer