Welcome back, in this article and the next one we will discuss the concept of Azure SQL as a service ( Platform as a service PAAS) and how you can as a database admin to use this service.
Azure SQL database is a service hosted in Microsoft cloud, it’s allow database admins to use a database without any worries of infrastructure like servers, Hardware components, OS updates, SQL updates … etc. This means that you will use the SQL as service not as virtual machine, you will not have any access to the server components, again you just have an access to the instance of database only.
to demonstrate more, let’s try to clarify the deference between two concepts in cloud services : Infrastructure AS A Service (IAAS) and Platform AS A Service (PAAS).
In IAAS mode you will own your infrastructure components such as Network, VM, Storage … etc. and you will be the responsible to manage all of these components such as OS updates, Network Monitoring, Storage sizing … etc. in addition to implement all these components.
In PAAS mode, you will use the service itself without any worries of other infrastructure components, for example you will have an access to the database with the access to the servers which hosted the SQL, and in this case Microsoft will take the responsibility to keep other components up and running in health state.
So in Azure, you have the choice of using an IAAS by creating new virtual machine and install the SQL on it or using the Azure SQL (PAAS), in this article we will demonstrate how to use Azure SQL platform as a service (PAAS).
so let’s discuss the some scenarios which help you to decide which type to use SQL as IAAS or PAAS:
Most Common SQL PAAS Scenarios:
1- You need to implement a new fresh application environments which use SQL service and you don’t have enough time to implement an SQL server as IAAS and don’t have an efforts to put on that.
2- Applications that need to be built in highly available, In Azure SQL PAAS your SQL will be high redundant by default, so based on Microsoft SLA your SQL service will be up and running 99.9% of the time.
3- You don’t have an enough technical team to handle the Infrastructure, in Azure SQL PAAS Microsoft will take responsibility of Infrastructure.
4- if your database is less than 1 TB size, in Azure SQL PAAS the DB should not be more that 1 TB.
5- eliminate the hardware cost and administrative tasks.
6 – In addition to built-in fault tolerance infrastructure capabilities, Azure SQL Database provides features, such as Point in Time Restore, Geo-Restore, and Geo-Replication to increase business continuity.
Most Common SQL IAAS in Azure Scenario (As Azure SQL VM):
1- if your application need to access local resources such as active directory.
2- if the DB’s size is more than 1 TB.
3- if you have any customizations that need a full privilege in SQL servers.
4- Eliminate hardware cost.
5- You have IT resources for support and maintenance.
6- if you need a highly available solution, Microsoft offer many ways to achieve the high availability in the VM’s level.
IN Azure SQL PAAS, you will charge for the consumed size only, this mean if you choose DB size to be 250 GB and you consume only 50 GB you will be charged for the 50 GB only, the concept of PAY AS YOU GO
In next part we will show how to implement the Azure SQL with an example of how to deal with it.
About Blogger …
Ahmad Yasin in a Microsoft Cloud Engineer and the publisher of
AzureDummies blog. He also hold many certificates in office 365
and windows azure including Developing Microsoft Azure Solutions, Implementing Microsoft Azure Infrastructure Solutions
and MCSA office 365.