About the Author
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 :
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
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”.
Step 12: Click on “Create”, once you review all the sections.
Step 13: Once the Validation will complete & show message, “your deployment is complete”. Click on “Go to resource".
Now, a tab will open from where you will get options to Configure, connect to application & start developing your application.
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