What SQL is good for you - Azure Part - 2

In previous post we have discussed about all the options that we have on azure for SQL and the difference between them and in this post we will discussing what is best as per the requirement of the customer or team :-

SQL Database single databases and elastic pools	SQL Database managed instances	Azure virtual machines with SQL Server
Built-in high availability, disaster recovery, and upgrade for the database.	Built-in high availability, disaster recovery, and upgrade for the database.	Team needs to build or manage HA , DR , Patching and upgrade.
Do not want to manage the underlying operating system and configuration settings. (PaaS)	Do not want to manage the underlying operating system and configuration settings. (PaaS)	If you need customized environment with Full Admin rights.
Databases of up to 100 TB.	Databases of up to 8 TB	SQL Server instances with up to 64 TB of storage. The instance can support as many databases as        needed.
Do not support all on-premises instance-level and database-level capabilities.	supports almost all on-premises instance-level and database-level capabilities.	Supports all on-premises capabilities.
Designing new app in cloud and want latest stable SQL server features. (all new feature come to         PAAS Azure SQL first )	New applications or existing on-premises applications that want to use the latest stable SQL Server features and that are migrated to the cloud with minimal changes.	Existing applications that require fast migration to the cloud with minimal changes or no changes.
In addition to built-in fault tolerance infrastructure capabilities, Azure SQL Database provides features, such as automated backups, Point-In-Time Restore, geo-restore, Active geo-replication, and Auto-failover groups to increase business continuity. For more information, see SQL Database business continuity overview.	In addition to built-in fault tolerance infrastructure capabilities, Azure SQL Database provides features, such as automated backups, Point-In-Time Restore, geo-restore, Active geo-replication, and Auto-failover groups to increase business continuity. For more information, see SQL Database business continuity overview.	With SQL Server on Azure VMs, you can have applications that run partly in the cloud and partly on-premises. For example, you can extend your on-premises network and Active Directory Domain to the cloud via Azure Virtual Network. For more information on hybrid cloud solutions, see Extending on-premises data solutions to the cloud.
Eliminates hardware costs and reduces administrative costs.	Eliminates hardware costs and reduces administrative costs.	Eliminates hardware costs only as you need resources for other administrative tasks.

We have discussed a lot of important points as per the need to choose Azure Sql and for more information you can dig on MS Docs below are few reference links :-


https://pachehra.blogspot.com/2019/07/what-sql-is-good-for-you-azure.html
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance
https://docs.microsoft.com/en-us/azure/sql-database/replication-to-sql-database