Azure SQL Data Warehouse – First Notes

Difficulty Level:    

I finished my super busy week with many excited and positive information:

  • Good signature for big cloudification project with huge customer. Thank you (Thang Bui, Viet Pham and Quang Nguyen) for my new experience in this domain.
  • The approval to start review Azure SQL Data Warehouse from Microsoft.

Cloudification is my job now, it’s confidential and cannot be shared at this moment. So in this article, I will share my first feeling of SQL Data Warehouse only. I hope this information can bring something helpful to you.

  • Fast (it takes about 15 minutes) and easy (few steps) to initiate new SQL Data Warehouse resource;
  • Good performance and cheap price. The smallest option is 100 DWU can provide the capability to scan 1B rows in 279 seconds with the price at $0.7 per hour. That cool;

01 - let's start

  • Azure SQL Data Warehouse doesn’t support old SQL Database servers. It’s the first limitation I found;

02 - old database server

  • Almost of regions already supported, including US, Europe, Southeast Asia and Japan;

03 - create new database server

  • Supports to integrate with PowerBI and Visual Studio 2013 (I’m using VS 2015 so need to prepare new VM to review VS integration feature later);

04 - main menu

  • Supports to create Data Warehouse with sample database (AdventureWork database). It’s good enough for some one to study;

04 - select database

  • Easy to scale up or down by changing DWU option;

06 - scaling

  • Support up to 10TB, it’s good enough for almost of Data Warehouse;

08 - some properties

  • Robust auditing and integrate with Azure storage account;

09 - audit

  • Data protection (data encryption) is built-in feature;

10 - encryption

  • Supports to integrate with multiple programming languages;

12 - connection string

  • Built-in monitoring to show DWU usage, storage information and query activity;

11 - monitoring

From my perspective, Azure SQL Data Warehouse is good service and I’ll have other articles to discuss about it in more detailed level.

Son Nguyen

Son Nguyen

Son Nguyen is a Cloud Consultant working for FPT Software’s Cloud Innovation team. With deep knowledge in AWS and MS Azure, Son acts as a cloud consultant in various areas, ranging from assessment to architecture design, supporting customers from Japan, EU to US.

You may also like...

Leave a Reply

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