SQL Database (IaaS/PaaS)
An SQL Database can be implemented in Azure in two ways:
- Using Azure SQL Database: It follows the PaaS model, and we have been using it so far
- Using Azure VMs and building SQL on them: This follows an IaaS model, and will be covered in more detail shortly
Azure SQL Database (PaaS)
As mentioned earlier, Azure SQL Database is a relational database as a service, built and hosted on Azure.
Azure SQL Database minimizes the costs of managing and provisioning databases. Using this model will reduce the responsibility of managing the virtual machines that host the SQL server, the operating system, and even the SQL Server software.
This model eliminates concerns regarding upgrades, backups, and even the high availability of databases, because they are not your responsibility anymore, in addition to being able to add databases as you wish, whenever you want. Taking this into account, you will pay less credits because, in this scenario, you will not pay for a VM with SQL installed...