Azure SQL Database – Introduction
- 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
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
Pingback: Graphics Design
Pingback: Rasna
Pingback: Source
Pingback: Kaka\'ako Real Estate
Pingback: MASK ON 10 FREAKY GIRLS Instrumental Metro Boomin Type Beat 2019
Pingback: vlogging kit for beginners
Pingback: www.friv.run
Pingback: top roof removal folsom
Pingback: Tree cutting
Pingback: tor search engine link
Pingback: vinci the game
Pingback: where to buy original paintings online
Pingback: Mitch Brownlie Australia
Pingback: najezykach.com.pl/forum/
Pingback: 바카라사이트
Pingback: 카지노사이트
Pingback: 온라인카지노
Pingback: where to find real estate agent
Pingback: 배트맨토토
Pingback: 바카라사이트
Pingback: 놀이터
Pingback: buy followers for instagram cheap
Pingback: Food That Could Prevent cancer.
Pingback: แทงบาคาร่า
Pingback: ti le bong da truc tuyen
Pingback: Ted Kaczynski Zodiac Killer
Pingback: double penetration Anal cumshots Gaping
Pingback: cbd oil
Pingback: cornhole board wraps
Pingback: should cbd have a taste?
Pingback: ซี ฉัตรปวีณ์ ตรีชัชวาลวงศ์
Pingback: ca cuoc bong ro truc tuyen