How to provision a new Azure SQL database ?

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.

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.

Connect to the Azure portal and select create a resource.
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

  1. In the search bar type azure SQL
  2. And click on the Azure SQL button.
How to create a 12 months trial Azure Account ?

3. Select the Azure SQL resource

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

4. Select the Single database option

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

  1. Check that the option is on Single database
  2. 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
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.

  1. Select the Subscription, it is the first one available one by default
  2. Under Resource group, select Create new
  3. And enter a valid name, here it is SQLTraining
  4. Then enter the Database name
  5. For the Server, you need to select the create new link (not visible on the screenshot)
  6. Select No for the elastic pool option
Create a new Azure resource group and server
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.

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

7. Set up the backup storage options

  1. Select the the Locally-redundant backup storage option
  2. 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:

  1. Select the Public endpoint as Connectivity method
  2. Activate the options to grant the Azure services access and to add the current IP address in the firewall rules.
  3. Then validate to go the Security section.
Grant the Azure services access and to add the current IP address in the Azure firewall rules
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:

  1. Use the Sample option
  2. Validate to create the AdventureWorksLT database in your set up.
  3. 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

  1. Review the options in the Basics section
  2. And in the Networking one
  3. 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
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.

Leave a Comment

Your email address will not be published. Required fields are marked *