Implementing backend using Microsoft Azure SQL database
Published Jan 20 2023 12:00 AM 1,044 Views
Frequent Visitor

About the Author

 

_sachinmittal_0-1673700874324.pngSachin Mittal - Beta Microsoft Learn Student Ambassador - Microsoft |

I am pursuing my bachelor's degree from IIT Roorkee, India and a Beta Microsoft Learn Student Ambassador

I am passionate about Web Development and Open-Source Contribution. I also like sharing tech information with others.

 

 

In this blog, we will learn how you can implement Azure SQL database as backend for your web app.

 

Azure SQL Database is an always-up-to-date, fully managed relational database service built for the cloud.

Want to know more about Azure SQL, check Azure SQL documentation.

 

Why to use Azure SQL database?

  1. Fully managed and always on the latest version of SQL
  2. Hyperscale the most demanding workloads
  3. Layers of protection and intelligent threat detection help keep your data secure
  4. Maintain peak performance and durability with an SLA of upto 99.995%

Let’s add backend in the web app we have created in Build your first Web Application with Microsoft Azure.

 

Step 1: Go to Azure Portal.

 

_sachinmittal_1-1673701095572.png

 

Step 2: Click on “SQL databases”.

 

Step 3: Click on “Create SQL database”.

 

_sachinmittal_2-1673701140653.png

 

Step 4: Enter a name for resource group, name for database.

 

Step 5: Click on “Create new” in Server.

 

Step 6: Now, enter a name in Server name, select Location & Authentication method & click on “OK”.

 

_sachinmittal_3-1673701172683.png

 

Step 7: Select Workload environment, Select the size of the database for most student work loads choose the basic (which is the most cost effective & Backup storage redundancy. Click on “Next: Networking >”.

For Database sizes we recommend :

DTU (Basic)

In DTU-based SQL purchase models, a fixed set of resources is assigned to the database or elastic pool via performance tiers: Basic, Standard and Premium. This model is best for customers who prefer the simplicity of fixed payments each month, where the simplicity of pre-configured options is desired.  With a cost of $0.0068/hour which is $6.11 per month

Standard-series (Gen 5)

Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers. and cost approx $0.51/hour 

_sachinmittal_4-1673701188846.png

 

Step 8: Select Connectivity method, Firewall rules, connection policy & Click on “Next: Security >”

 

_sachinmittal_5-1673701205093.png

 

Step 9: Enable Microsoft Defender for SQL & Click on “Next: Additional settings >”

 

Step 10: Select Data source & Click on “Next: Tags >”

 

_sachinmittal_6-1673701230678.png

 

Step 11: Click on “Next: Review + create > here you can can see the costs of the datbase, you can change the size under the basic tab and understand costs of cloud services based on the "Compute Storage size”.

 

_sachinmittal_7-1673701245962.png

 

Step 12: Click on “Create”, once you review all the sections.

 

_sachinmittal_8-1673701268182.png

 

Step 13: Once the Validation will complete & show message, “your deployment is complete”. Click on “Go to resource".

 

_sachinmittal_9-1673701286077.png

 

Now, a tab will open from where you will get options to Configure, connect to application & start developing your application.

 

_sachinmittal_10-1673701304670.png

 

Congratulations, you have deployed Azure SQL. If you have any query, feel free to contact.

 

Want to learn more about SQL Databases, here are some Go to following Microsoft Learn resources and interactive handson labs:

Microsoft Learn: Introduction to SQL Server 2022

 

Microsoft provides several resources for learning Azure SQL.

Microsoft Learn: Introduction to Azure SQL

Microsoft Learn: Azure SQL for Beginners

 

 

Co-Authors
Version history
Last update:
‎Jan 20 2023 01:56 AM
Updated by: