Understanding Azure SQL Database- Introduction

By | March 18, 2018

Azure SQL Database- Introduction

In this first article of the series Understanding Azure SQL Database in which I am going to publish in the coming weeks to understand Azure SQL Database concepts. After this series, you will have the good understanding of the following Azure SQL concepts
  • What is Azure and Azure SQL Database
  • Pricing Model of Azure SQL
  • Creating SQL Server & Database on Azure and how to connect them
  • Understanding of different Azure Service Tier
  • Difference between Azure SQL Database & SQL Server
  • Security features in Azure SQL Database
  • Database Transaction Units (DTU) & how to calculate it.
  • Elastic Pool in Azure SQL Database
  • Database Backup & Restoration in Azure SQL Database
  • High Availability & Disaster Recovery feature in Azure SQL Database
  • Database Migration from SQL Server to Azure SQL database
  • Database Migration from Azure SQL Database to SQL Server
  • Azure Metric Alerts and how to create them
  • Performance Tuning in Azure SQL Database

 

When we think of Azure SQL Database, first question comes in our mind is what is Azure? Microsoft Azure is a cloud computing platform created by Microsoft to build, test, deploy and host the applications using the global network of Microsoft managed data centers.

Next question comes, what is Azure SQL Database? Azure SQL database is defined as the Database as a Service offered on Microsoft Azure. By Database as a Service means that Microsoft as the service provider will going to manage the database software, taken care of  Database backup, recovery, High Availability, Operating System. We as users only need to taken care of database and the queries running inside the database. Also we need to pay as per our current database uses and nothing to pay anything upfront. Also we can scale up or scale down or create or destroy the environment as per our requirement without any interference from the provider Microsoft.

Azure provides three Service tiers for setting up the SQL Database. These 3 Service Tiers are:-

1) Basic Service Tier
2) Standard Service Tier
3) Premium Service Tier

Within Standard & Premium Service tiers we have different level. For example in Standard Service tier we have 4 levels S0 , S1, S2 & S3. In Premium Service tier, we have 6 levels P1, P2, P4, P6, P11 & P15.

Azure SQL Database Backup Retention time period, Performance, Database Size are depend on which Service Tier we choose at the time of database creation. We can change the service tier or service tier level any time as per application requirement. We will going to know more about Service tiers in the coming articles in this series.

Pricing of  Azure SQL database is calculated on the hourly bases and it depends upon which Service tier we have used. The hourly rate is determine on the basis of highest Service tier we used in that hour.

In case of  SQL Server hosted in a VM, users are responsible for maintaining the operating system, taking regular database backups, database disaster recovery planning, maintaining the SQL Server, SQL performance & Security. But in case of case of Azure SQL database, we just need to choose the correct Service Tier as Azure itself responsible of taking care of operating system, Backups, High Availability & Security.

There are many features of Azure SQL database, which we are going to cover in the upcoming next articles of this series. Till then keep learning and keep visiting this site. Don’t forget to send your valuable feedback as comment or you can send to my mail id askvivekjohari@gmail.com

 

Category: Azure Tags: ,

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.

Leave a Reply