Implementing backend using Microsoft Azure SQL database

January 20, 2023

About the Author

Sachin 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?

Fully managed and always on the latest version of SQL
Hyperscale the most demanding workloads
Layers of protection and intelligent threat detection help keep your data secure
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.

Step 2: Click on “SQL databases”.

Step 3: Click on “Create SQL database”.

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”.

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

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® 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

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

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

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

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”.