Azure DW has been become more and more popular, and there is no doubt that Microsoft is putting all its efforts on the cloud. For those who wants to begin with this trend in Business Intelligence , simple questions can pop up our minds. This article will explain how to setup a simple data base in Azure DW and How to connect to Azure DW via SQL Server Management Studio.


Firstly, What is Azure SQL Data Warehouse?

Microsoft reference: Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.

SQL Data Warehouse:

  • Combines the SQL Server relational database with Azure cloud scale-out capabilities. You can increase, decrease, pause, or resume compute in seconds. You save costs by scaling out CPU when you need it, and cutting back usage during non-peak times.
  • Leverages the Azure platform. It’s easy to deploy, seamlessly maintained, and fully fault tolerant because of automatic back-ups.
  • Complements the SQL Server ecosystem. You can develop with familiar SQL Server Transact-SQL (T-SQL) and tools.

How to setup a new Azure SQL Data Warehouse

1) Click in New -> Data + Storage -> SQL Data Warehouse -> Create.
2) If you haven’t created a SQL server service before, you will have to. Just click in Server and then Configure required settings.

Create an Azure SQL Data Warehouse

Overview of all resources of Azure

You can click in all resources and have a look in your new SQL Data Warehouse description.

SQL Azure DW - All resources

 

How to Create a new Azure SQL DW Database

1) New > Data + Storage > SQL Database > Create
2) Server: Same thing here, select your SQL server service or create a new one.

Creating SQL Azure DW database

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You can also create a simple SQL Database, which has a slightly difference in syntax if compared to SQL DW database. I mean, in SQL DW database, some commands and properties don’t exist anymore, such as: creation of Primary Keys, Identity columns, etc.

Now, Let’s connect to Azure DW via SQL Server Management Studio.

How to access your database via SQL Server Management Studio (SSMS)

1) Open the SQL Server Management Studio (SSMS) and click in connect > database engine. Enter your SQL Service server name (you can find it at the second image above).

img4

 

 

 

 

 

 

 

 

 

2) You will have to add your IP in the Azure DW Firewall rule.
connecting to Azure DW via SSMS

 

 

 

 

 

 

 

 

 

 

 

3) You can see all IPs that you added in the page bellow and allow new accesses to your server. Sometimes you may face an error “The server specified does not exist any subscription”, I could solve this error adding manually my IP in the Firewall Setting and then trying to connect again.

Azure DW Firewall

 

4) Finally, here is your connection 🙂

ssms

Post here if you have any issue. It will be a pleasure to help you.

Leave a Comment

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