How to create azure sql database

Table of Contents

  1. What is Azure SQL Database
  2. Creation of Azure SQL
  3. Creation of Single Database
  4. Query Editor
  5. Video Tutorial

Azure sql database

Azure SQL Database is a general purpose relational database provided as a managed service.

The first step is to log into the Azure portal using the user’s credentials. Once on the page that contains the list of services offered by Azure, the ‘Create Service’ option must be clicked and then search for the Azure SQL option.

Microsoft provides various different varieties of SQL database offerings, platform as a service offering, and infrastructure as a service offering. The user will be able to create a single database and create and manage instances. Manage Instances provide the PaaS benefits of SQL database with additional capabilities that were previously available only in SQL virtual machines. Apart from this, SQL virtual machines can also be created using the same platform.

Creation of azure sql

The first step in this process is to choose the SQL deployment option that are divided into three parts as following

  1. SQL Databases – There are three available varieties in this option such as Single Database, Elastic Pool, or Database Server. The single databases are a great fit for the modern cloud-born applications that need a fully managed database with predictable performance. A more cost-effective solution can be achieved by using an elastic pool. Elastic pools provide a cost-effective solution for managing the performance of multiple databases with variable usage patterns. Database servers are used to manage groups of single databases and elastic pools.
  2. SQL Managed Instances
  3. SQL Virtual Machines

Creation Of Single Database

There are various tabs that need to be completed for the creation of a single database which is divided into Basics, Networking, Additional Settings, Tags, and Review & Creates.
BASICS – The basics tab contains the following subsection of information that need to be filled out by the user

Project Details – This includes the Subscription Type and the Resource Group that should also be given a name.

Database Details – This includes the Database Name, Server, whether the user desires to use an SQL Elastic Pool and Computation & Storage. If there is no server that already exists, a new one must be created for the same. The information asked on the creation of a new server is Server Name, Server Admin Login, Password, and the Location. If selecting an elastic pool, it will need to be added. The configuration of the database can be changed if the user desires from General Purpose, Hyper-Scale, and Business Critical based on the data requirements. The costs will vary depending on the type chosen.

NETWORKING – The networking tab contains the following subsection of information that needs to be filled out by the user

Connectivity Method – The user may choose from either – No Access, Public Endpoint or Private Endpoint.

Firewall Rules – To allow Azure services and resources to access the server (Yes / No) and to add current client IP address (Yes / No)

ADDITIONAL SETTINGS – The additional settings option contains the following subsections of information that need to be filled out by the user –

Data Source – The user must choose whether they would like to use the existing data.

Database Collation – Collation

  • Advanced-Data Security – The user has the option to enable/disable this feature.
    • TAGS – The tag option contains the following subsections of information that need to be filled out by the user –
  1. Name
  2. Value
  3. Resource

The final step in the process is the Review & Create. Once the information has been reviewed and all the errors have been corrected, the ‘Create’ option must be clicked. Once the deployment has been imported after validation, it will be reflected in the SQL server and the status will be ‘Online’.

Query Editor

The ‘Query Editor’ option is located on the dropdown menu on the left-hand side of the screen. It can be logged into the database which requires the login name and password. The client IP address must authenticate the Public IP Address in order to log in, otherwise, it will fail and show an error and the database can’t be accessed.

The solution for this is to go to the Firewall Settings and allow Azure services and resources to access the server. The client IP address must be enabled. The SQL server can now be logged into. It will contain all the tables that had been created. Queries can be submitted to retrieve data.


Video Tutorial

Leave a Reply

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