Azure PDW is generally available

Microsoft released Azure SQL Data Warehouse accompanying  with a bouquet of impressive distinct capabilities that can be found in the press-release.

An item attracted my attention was the next:

Save as you go, with fast pause and resume
Starting and shutting data warehouse clusters may take a considerable amount of time (especially if to take in to account that data is dropped). Leaving the data warehouse running continuously incurs potentially high and unnecessary costs, especially if you are running your jobs periodically and the data warehouse is sitting idle in-between for extended periods of time. Now you can pause your data warehouse for the required time, saving compute costs, and quickly resume it later when needed.

“When we learned about the pause and resume capabilities of SQL Data Warehouse and integrated services like Azure Machine Learning and Data Factory, we switched from AWS Redshift, migrating over 7TB of uncompressed data over a week for the simple reasons of saving money and enabling a more straight-forward implementation for advanced analytics. To meet our business intelligence requirements, we load data once or twice a month and then build reports for our customers. Not having the data warehouse service running all the time is key for our business and our bottom line,” – said Bill Sabo, managing director of information technology at Integral Analytics.

I will Bill and see this add-on very significant because of… enormous costs savings using PDW. If DirectQuery mode is not used and there is no need to keep Data Warehouse online all the time then it’s possible to save – probably up to 80% of costs – activating PDW only for load and processing time.

Advertisements

About fdtki

Sr. BI Developer | An accomplished, quality-driven IT professional with over 16 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 6.5-2014 | Tabular/DAX | SSAS/MDX | Certified Tableau designer
This entry was posted in Big Data, Business Capability, Business Delivery and tagged , , , , , , . Bookmark the permalink.

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