Microsoft today announce the limited preview release of its new service the Azure SQL Data Warehouse.
The Azure SQL Data Warehouse, is to give businesses access to an elastic, data warehouse-as-a-service offering that can scale according to their needs meaning that enterprises can ensure that they only pay for the usage they need, when they need.
Tiffany Wissner, senior director of Microsoft’s Data Platform division, stated in a June 24 SQL Server Blog post that
"Unlike other cloud data warehouses that require hours or days to resize, the service allows customers to grow or shrink query power in seconds," Wissner continued. "As you can scale compute costs separately from storage costs, costs are easier to forecast than competitive offerings."
Coinciding with this release is the Azure SQL Data Warehouse connector for Power BI. This enables users of the PowerBI business intelligence (BI) tool to explore data stored in the new data repository and generate reports.
In total, 21 analytics companies support Microsoft Azure SQL Data Warehouse. The rest of the list includes Attunity, Bryte Systems, Brist, ClearStory Data, Coffing Data Warehousing, Dell Statistica, Dundas Software, Inbrein, InfoLibrarian, Informatica, Jinfonet, Logi Analytics, Looker, Qlik, Redpoint Global, SiSense, SnapLogic, SQL Sentry, Targit, Tableau and Yellowfin.
For now, the Azure SQL Data Warehouse preview is being limited to data warehouses ranging from 5 to 10 terabytes (TB) in size however we expect this to change as it comes to general release.