hello!!
In this blog, we'll see Azure SQL services and capabilities
- SQL server on azure VM
- A virtual machine in Azure with SQL server installed
Iaas
Azure SQL managed instance
PaaS
automated updates, backups and maintenance tasks
Azure SQL DB
Fully managed highly scalable PaaS Database serviceAzure SQL Edge
Optimized for IoT scenarios
IaaS
SQL service compatibility - Fully compatible with on premise or VM
Architecture - Supports 1+ database
Availability - 99.99%
Management - Manage all server updates, configuration, tasks
Use case - Use this option when you need to migrate or extend an on-premises SQL Server solution and retain full control over all aspects of server and database configuration.
PaaS
SQL service compatibility - 100% compatibility with SQL server
Architecture - 1+ database support, Instance pool used to share resources
Availability - 99.99%
Management - Fully automated updates, backups, and recovery.
Use case - Cloud migration scenarios
SaaS
SQL service compatibility - Core DB level services, some feature may not be available
Architecture - Manage single DB server or use elastic pool
Availability - 99.95%
Management - Fully automated updates, backups, and recovery.
Use case - New cloud solution
Thanks for reading :)
Top comments (1)
😎😎