News

Azure SQL Data Warehouse Hits General Availability

Microsoft today announced that its elastic cloud computing platform Azure SQL Data Warehouse is now generally available.

Billed as a database-as-a-service offering, Azure SQL Data Warehouse is Microsoft's enterprise-focused storage solution that scales both computing power and storage space based on need. According to the company, both provisioning the service and scaling up to 60 times the current computing power occurs within seconds.

"With a few clicks in the Azure Portal, you can launch a data warehouse, and start analyzing or querying data at the scale of hundreds of terabytes," wrote Joseph Sirosh, corporate VP for Microsoft's Data Group, in the announcement posted to the SQL Server Blog. "Our architecture separates compute and storage so that you can independently scale them, and use just the right amount of each at any given time. A very unique pause feature allows you to suspend compute in seconds and resume when needed while your data remains intact in Azure storage."

The ability to scale on the fly saves both on cost and can aid a growing business, as evident by an example given by mobile game developer PoundSand. "Getting featured in the iOS App Store was a big deal for a small company like ours as our users increased from 3,000 to 300,000 in 48 hours," said Paul Ohanian, CTO of PoundSand. "To keep up with this 100x increase in workload, we simply added data warehouse compute capacity by moving a slider and our services just scaled in minutes -- we didn't miss an insight."

Azure SQL Data Warehouse was built on a similar elastic massively parallel processing (MPP) architecture that is found in its SQL Server 2016 database to provide column stores for storage compression and instant analytics. It also ties in closely with Azure Machine Learning and Power BI to provide deep analytics reporting.

Microsoft is also touting the strong security features of the cloud-based database offering, including built-in auditing and threat detection, protection for data at rest with Microsoft's Transparent Data Encryption service offered in many of its other cloud-based services and advanced machine learning to detect and alert to potentially malicious query patters. The close integration with Azure Active Directory also provides stronger authentication control through the use of Single Sign-On and granular permissions capabilities to allow custom access on a per-user basis.

Azure SQL Data Warehouse entered a limited preview in late June of 2015 and opened up to a wider audience in October 2015, with thousands of customers already on board before today's general availability announcement. Microsoft is offering new customers a chance to evaluate the service with a free $200 credit trial, available here.

About the Author

Chris Paoli is the site producer for Redmondmag.com and MCPmag.com.

Featured

  • Gears

    Top 10 Microsoft Tips and Analyses of 2018

    Here are the year's most popular explainers and how-to columns -- along with some plain, old "Why did Microsoft do that?" musings thrown in.

  • Sign

    2018 Microsoft Predictions Revisited

    From guessing the fate of Windows 10 S to predicting Microsoft's next big move with Linux, Brien's predictions from a year ago were on the mark more than they weren't.

  • Microsoft Recaps Delivery Optimization Bandwidth Controls for Organizations

    Microsoft expects organizations using its Delivery Optimization peer-to-peer update scheme will optimally see 60 percent to 70 percent improvements in terms of network bandwidth use.

  • Getting a Handle on Hyper-V Virtual NICs

    Hyper-V usually makes it easy to configure virtual network adapters within VMs. That is, until you need to create a VM containing multiple virtual NICs.

comments powered by Disqus
Most   Popular

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.