Open In App

How and Why To Create an SQL Database on Azure

Last Updated : 06 Feb, 2018
Improve
Improve
Like Article
Like
Save
Share
Report

How do you benefit by creating an SQL database on Microsoft Azure? For one thing, moving databases between machines and cloud environments becomes easy and fast. What’s more, you can manage this without making changes to your apps, and while maintaining your on-premises infrastructure intact. Your app logic also benefits from having a quick access to centralized data storage, especially when your app is expected to run on multiple machines and locations. Set up an SQL Database on Azure and you no longer have to set up machines in geographically dispersed locations. Just store multiple databases as MS Azure Blobs and creates local and virtual databases by executing Transact-SQL scripts. Check out the other benefits of creating an SQL database on MS Azure:

  • Limitless storage
  • Lowered costs (due to reduced hardware overhead)
  • High availability
  • Quick, easy and reliable disaster recovery
  • Separation of storage from computing brings enhanced security benefits
  • Instant backups and restores for databases via the Azure Snapshot feature

Steps To Set Up An SQL Database On Azure Portal

In this tutorial, we’ll be teaching you how to:

  • Set up an SQL database on Azure, SQL Database
  • Set up a database firewall on the Azure portal.

Perform the following steps:

  1. Sign in to the Azure portal with your account details (you can sign up for a free trial account)
  2. To create a new SQL database with Azure, click New à (Data + Storage) àSQL Database. As you set up a database, you can also create and set up the server that will host it, or use an existing one. We’ll set up a new one.
  3. In the SQL Database settings window, under the Server àConfigure required settings option, configure your database and server details. You can either create a brand new database server if you like. We’ll go with an existing server for the purposes of the tutorial.
  4. Now, under Select source à Blank Database option, select Sample. Provide a name for your new database – we’ll go to Azure Database. Revert to the SQL database window, where you’ll see your new database’s name under the Select sample
  5. Now open the Azure Startboard and click Browse all to confirm that your new Azure Database is listed online.

Note: Your SQL database creation is not complete until you configure the settings for Collation, Resource group and Pricing tier. Please check the Azure Resource Manager Overview to know more about configuring Azure resource groups. As for Collation, refer to the Unicode Support for more information. You can scale the Pricing tier up and down for your database at any time later.

Steps To Configure Firewall Settings

You’ll need to configure firewall settings in order to connect to your new Azure Database from your client PC. To do so:

  1. On the Azure Startboard, select the Browse All options from the left-hand pane
  2. Scroll down the options you see on the right-hand pane, and select SQL servers.
  3. Select the database server you’re using for your project
  4. Under the Database Properties window, select the Settings à Firewall You’ll see your current Client IP address displayed in the Firewall settings pane.
  5. Now click the Add Client IP option to create a rule for your client IP address on Azure.
  6. Click Save to save your settings.

Now that you’ve configured your SQL database for Azure cloud, you’re ready to run queries and use other SQL tools. If you are unable to connect, check if your client IP has changed. If it’s changed, you can set up a new firewall rule with multiple IP addresses.

About the Author:

Vaishnavi Agrawal loves pursuing excellence through writing and have a passion for technology. She has successfully managed and run personal technology magazines and websites. She currently writes for intellipaat.com, a global training company that provides e-learning and professional certification training.


Similar Reads

Time Series Database vs Relational Database: Top Differences
Choosing between a time-series database and a relational database isn't merely a matter of data storage location. It's pivotal for shaping your organization's data handling practices — it's about enhancing how you extract insights from your data. This decision significantly impacts speed, efficiency, and the precision of your operations. Consider t
10 min read
MySQL vs CockroachDB: Which SQL Database is Better in 2024
It is important to choose the right relational database management system (RDBMS) for your application so that it scales, performs, and maintains data integrity. In today’s data-driven world, there are two key players: MySQL and CockroachDB. SQL-based, both of them offer powerful ways to interact with data from within the software. However, under t
9 min read
7 Reasons Why You Should Learn SQL in 2024
SQL is pronounced as "sequel" by some while "S-Q-L" by others. SQL is an acronym for Structured Query Language, a standard and widely accepted language used for database maintenance by performing operations such as retrieval and manipulation of data stored in a database. SQL has been in existence since the 1970s. Now a question arises: what made SQ
7 min read
5 Tips to Prepare for Microsoft Azure Cloud Certification Exam
For the last few years, the cloud has become a crucial part of almost every IT organization due to various benefits that come along with it. There are various IT giants that offer cloud services such as Google, Amazon, Microsoft, and various others. However, like all other tech-related fields, Microsoft is leading the cloud domain also with its mos
5 min read
Top 10 Azure Skills That Are In-Demand in 2024
In today's rapidly evolving tech landscape, Azure skills have become a hot commodity, fueling innovation and driving business growth. Azure skills are skills that are mainly referred to as the knowledge and the proficiency which is required to work with Microsoft’s cloud computing platform, Azure. These are special types of skills that are required
8 min read
AWS vs Azure: Which One Should You Choose in 2024
Today, most businesses and startups use on-demand cloud services rather than physical storage devices. Public clouds offer various resources to these companies over the Internet, which can be accessed remotely on a pay-as-you-go basis. It is a much more feasible alternative to purchasing a physical desktop since the company can purchase a virtual d
8 min read
Firebase vs Azure: Top Differences
Firebase and Azure stand out as two leading platforms, each platform presents a wide collection of tools and services important for both developers and businesses. Firebase supported by Google, and Azure developed by Microsoft, both aim to empower users to create, deploy, and manage applications smoothly in the cloud. Firebase, well-known for its s
9 min read
Top 10 AI Tools To Optimize Azure Cloud Setup
In recent years, the use of AI has brought a significant impact around the whole world on cloud optimization by introducing advanced predictive analytics and anomaly detection. Thus AI plays an important role in improving data management and when combined with cloud computing it also maximizes information security. Hence by this means it is possibl
9 min read
Top 5 Free, Cross-Platform, and Open-Source Database System in 2020
Data is the most valuable and important thing in this 21' st century. This virtual world is completely built and running with numerous amount of data. Without proper management of this huge amount of data, every single system would get crashed and broke-down. Now here comes the savior, a software that stores, organizes, and manages a large amount o
5 min read
10 Best Books for Database Administrators and Developers
Database Administrators create databases as per the needs of the company and make sure they function effectively and efficiently. This is a grooming career path that is continuously growing with a rise of nearly 10 percent and an unemployment rate of just around 1.7 percent. In today's fast-paced and media-driven life, information is so easily avai
7 min read
Article Tags :