Azure SQL

How to Create Sample SQL Server database in Azure

Azure is a cloud computing platform provided by Microsoft. It helps organizations of any size meet their business challenges. It provides various services that can be utilized on the cloud. In this tutorial, we will learn how to create a sample SQL Server database in Azure.

Install SQL Server on Windows 10.

 Create a Sample SQL Server database in Azure

  1. Create a free or paid Azure account.
  2. Login to Azure portal using your Azure credentials.
  3. On the portal, under Azure Services, click on SQL databases. If you don’t see SQL databases, click on More Services.

Azure Services

4. Under SQL databases click on Add

Sql Database

5. Enter information under Project details. If you already have an existing Resource group, you can select from the drop down list or Create new. Resource group is just a bucket of related items. For this example, I named it SQLDatabase.

Project Details-ohio Computer

6.  Enter the Database name and Create a new Server. I specified AdventureWorksLT as I will be importing this database.

I have created a new server – sqldemooca.

Database Details

SQL elastic pool option is used if you want to manage the performance and cost of multiple databases. I will set this to default No as I am just creating a sample database.

7. Next, select Networking and specify network connectivity and firewall rules.

Networking

7. Next select Additional Settings.

Here you will specify how you will populate the database. You can choose None to create a blank database, or Backup is used to restore database from an existing Backup. I will select Sample.

Additional Settings

8.  Next option is Tag. Tags are used to view consolidated billing by providing the same tag to multiple resources. You can skip if you are not using  multiple resources.

9.  Next click on Review + Create. This will create your database. It will also specify the pricing for your resource.

Networking

Want to learn more about storing data in Azure, visit How to load data in Azure Data Lake.


Author:

Chandraish sinha

Chandraish Sinha has  20+ years of experience in Information Technology. He is an accomplished author and published multiple IT books. Please visit Author’s profile.

He has implemented IT solutions in various industries viz: Pharmaceutical, Healthcare, Telecom, Financial and Retail.

He coaches Organizations and Consultants in various Technologies.

He blogs regularly on Business Intelligence : http://www.learntableaupublic.com/   , http://www.learnallbi.com/

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.