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.