Azure SQL Database | All
you need to know about
Azure SQL Services
October 6, 2020 by Akshay Tondak Leave a Comment
Azure SQL Database is evergreen, meaning it does not need to be patched or
upgraded, and it has a solid track record of innovation and reliability for
mission-critical workloads. Companies are choosing Azure for their SQL
In this blog, we are going to cover about Azure SQL Services, Azure SQL
Database, Deployment option, and how to work on it.
What is Azure SQL Service?
Azure SQL allows hosting our Microsoft SQL Server workloads on the Azure
cloud. We have three major ways of hosting the SQL database on the Azure
1) Azure SQL Database: It is a fully managed database service in Azure. It
is always running on the current version of the SQL Server database engine
and patched OS with 99.99% availability.
2) Azure SQL Managed Instance: It is a fully managed service. It’s for
those companies who want to migrate their existing SQL workloads to the
3) SQL Server on Azure VM’s: It is when we want to have more control
over the SQL server environment.
Join Over 140k
Subscribers to get
FREE Tips, How-To's,
and Latest Information
on Cloud Technologies
Also read: our blog on Azure Data Lake Overview for Beginners
What Is The Azure SQL
It is a fully-managed platform as a service. Here the platform manages
aspects such as the database software upgrades, the patching, the backups,
Using this, we can provide a highly available and performant storage layer
for our applications.
Types Of Deployment Options For The Database:
1) Single Database: Single database represents a managed isolated
database. We create a database in Azure SQL with its own set of resources
and it is managed by sever.
2) Elastics Pool: An Azure SQL Elastics pool allows us to allocate a shared
set of computing resources to the collection of Azure SQL Database. Elastics
Pools are well fit for a large number of databases with particular utilization