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

  • RAMBleed Side-Channel Attack Method Disclosed by Researchers

    Academic researchers this week published information about another side-channel attack method, called "RAMBleed," that can expose information from memory chips, including encryption key information.

  • Penguin

    Windows 10 Preview Build 18917 Shows Off New Linux Integration

    Microsoft's latest Windows 10 "fast-ring" preview release is showcasing a coming Delivery Optimization enhancement, along with the ability to try the newly emerged Windows Subsystem for Linux version 2.

  • Customizing Microsoft Office 365

    While the overall look and feel of Office 365 is pretty standard across organizations, there are several ways to personalize it and make it fit better with your company's specific needs.

  • Microsoft 365 Business Tenants Getting Conditional Access and Trouble-Ticket Features

    Microsoft added its conditional access security service to Microsoft 365 Business subscriptions, according to a Wednesday announcement, and it also added new trouble-ticket features for Microsoft 365 administrators.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.