Azure SQL Datawarehouse


Documentation on Azure SQL Datawarehouse, the new Azure Datawarehouse managed service, is quite thin.

The online documentation, as of today (24/07/2015), consists of 3 videos and a blog post.

Here is what I gathered.

db[1]One of the great characteristic of the offering is the separate Storage & Compute billing.

You can indeed have data crunches on periodic basis (e.g. end-of-months) and pay only for those, while keeping your data up-there at the competitive price of Azure Storage.

Compute is said to be ‘elastic’, although it isn’t automatic. You can change the number of compute horsepower associated to your Datawarehouse instance without having to rebuild it, so it’s done on the fly, very quickly.  Nevertheless, for that you need to manipulate the portal (or Powershelling it), so it’s not auto-elastic on-demand.

There is a nice integration with Azure Data Factory to import data into it.

The service already is in preview, you  can access it on the new portal.
Azure SQL Datawarehouse looks very promising although the documentation available is slim at this point in time.

The most details I found was actually through SQL Server Evolution video which is a nice watch.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s