How to provision a new Azure SQL database ? Azure Cloud

Step by step tutorial for provisioning an Azure SQL database in the cloud using a Microsoft account.

Welcome to this comprehensive guie to provision a new Azure SQL database. In today’s data-driven world, managing and analyzing data efficiently is more important than ever before. Microsoft Azure provides a powerful, scalable, and secure platform for managing your data, and with Azure SQL Database, you can harness the full power of SQL in the cloud.

This tutorial will guide you through the process of creating a new Azure SQL database step-by-step, with detailed screenshots and explanations. By the end of this tutorial, you’ll have a fully functional Azure SQL database up and running, ready to store and manage your data.

Table of Contents

1. Connect to the Azure portal to provision a SQL database

The prerequisites are that you already have an active Azure account and credits available to provision new ressources.

Navigate to Navigate to https://portal.azure.com/#home
Select the Create a resource button to access the marketplace menu.

Connect to the Azure portal and select create a resource.

Video tutorial with all the steps to provision an Azure SQL Database

2. Search for the Azure SQL resource

In the search bar type azure SQL
And click on the Azure SQL button.

How to create a 12 months trial Azure Account ?

3. Select the Azure SQL resource

Double check that the plan selected is Azure SQL
And click on Create

4. Select the Single database option

Select the Azure SQL database plan for the service. Then :

Check that the option is on Single database
and click Create to go to the next step.

Select the Single database resource type in the SQL database plan to use the Azure service

5. Configure the subscription and resource group

In the project details section, we need to configure the subscription and server details.

Select the Subscription, it is the first one available one by default
Under Resource group, select Create new
And enter a valid name, here it is SQLTraining
Then enter the Database name
For the Server, you need to select the create new link (not visible on the screenshot)
Select No for the elastic pool option

Create a new Azure resource group and server

6. Set up the server and the authentication

Once in the Server details section, set up the following information, of course, you need to adjust it to your specific business case.

Type the Server name, here it is expertonlyserver (no uppercase or special characters allowed)
Select the Location, select the closest to the Azure database users.
Select the Use SQL authentication option and enter the admin login : here it is Admin
Enter and confirm the password.

7. Set up the backup storage options

Select the the Locally-redundant backup storage option
Then validate using the button Next : Networking > to go the networking section.

Select the the Locally-redundant backup storage option for the new Azure SQL database — Select the the **Locally-redundant backup storage** option for the new Azure SQL database

8. Configure the Azure database connectivity and firewall

To do so, from the Networking section, follow these 3 steps, as explained and illustrated in the screenshot below:

Select the Public endpoint as Connectivity method
Activate the options to grant the Azure services access and to add the current IP address in the firewall rules.
Then validate to go the Security section.

Grant the Azure services access and to add the current IP address in the Azure firewall rules

9. Disable Microsoft Defender for SQL

Simply select Not now to disable the options for the threat protection provided by Microsoft.

10. Use AdventureWorksLT as a sample SQL database

To generate sample data in the new Azure database:

Use the Sample option
Validate to create the AdventureWorksLT database in your set up.
Click on Review + Create to see the summary of all the settings before the actual creation.

add the AdventureWorksLT database to your Azure SQL server — Add the AdventureWorksLT database to your Azure SQL server

11. Review the settings and provision the Azure SQL database

Review the options in the Basics section
And in the Networking one
Then click on the Create button to actually create the Azure SQL server and the database.

12. Check the successful deployment message

After about 5 minutes, all the steps are finished and the message Your deployment is complete is displayed on the Azure portal.

All the steps to provision a new Azure SQL database are done click on Go to resource to access the database

Conclusion on provisioning a new Azure SQL database

Congratulations on successfully following the tutorial on how to provision a new Azure SQL database on Microsoft cloud. By following this tutorial, you have learned how to navigate the Azure portal, configure your database subscription and resource group, and set up server and authentication details. Then how to configure backup storage redundancy, and manage database connectivity and firewall options.

You have also created the AdventureWorksLT sample database, giving you a foundation to explore Azure SQL’s features and capabilities further. With your new Azure SQL database in place, you’re now ready to build, manage, and scale your data-driven applications on Microsoft Azure. Happy data managing! And good luck.