Microsoft Upgrades Azure SQL Database Service - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Cloud // Platform as a Service
12:25 PM
Connect Directly

Microsoft Upgrades Azure SQL Database Service

Microsoft cloud-database service nears parity with on-premises Microsoft SQL Server with support for larger databases and in-memory performance.

10 Cloud Analytics & BI Platforms For Business
10 Cloud Analytics & BI Platforms For Business
(Click image for larger view and slideshow.)

Microsoft announced Azure SQL Database upgrades on Thursday that promise to bring the cloud-based database service close to lock-step parity with on-premises Microsoft SQL Server capabilities.

Database services are only growing in adoption, with many companies now preferring database-as-a-service to the more labor-intensive route of deploying and administering database instances on cloud infrastructure.

The parity-with-SQL Server story boils down to supporting larger database deployments and higher performance than previously possible on the Microsoft's cloud. Tests show the new version of Azure SQL, V12, delivers a 5X boost in query performance as compared to the previous version. The service also now offers in-memory columnstore technology -- introduced as In-Memory OLTP in SQL Server 2014 last year -- that offers up to a 100X boost in transactional performance, according to Microsoft.

[ Want more detail on service capabilities? Read Microsoft Bolsters Azure SQL Database Services. ]

"After running both a benchmark and some close-of-business workloads, which are required by our regulated banking customers, we saw significant performance gains, including a doubling of throughput for large blob operations, which are essential for our customer’s reporting needs," stated Azure SQL customer John Schlesinger in a Microsoft blog. Schlesinger is chief enterprise architect at Temenos, a banking services firm that previewed the new service.

The latest version of Azure SQL service went live in Europe this week. It will roll out in the US on Feb. 9 and will reach the rest of the world by March 1. Microsoft says general availability pricing will take effect on April 1.

Microsoft is also beefing up Azure SQL security with new security features including Row-Level Security, Dynamic Data Masking, and Transparent Data Encryption. Complementing Azure SQL auditing capabilities, the new features are aimed at meeting corporate and industry compliance policies. Row-level security, now available in public preview, supports fine-grained access control over rows in database tables so admins can limit access at an atomic level.

Dynamic Data Masking, which is "coming soon" according to Microsoft, will support policy-based masking of selected data fields, such as credit card or Social Security numbers, so non-privileged users won't see that data along with other information in a larger query. Transparent Data Encryption, which encrypts data at rest, not just in transit, is also coming to Azure SQL Database V12. The row-level, masking, and encryption features will be available with Basic, Standard, and Premium Azure SQL Database service tiers.

Microsoft hasn't forgotten those who prefer to run SQL Server directly on Azure cloud VMs (rather than using Azure SQL Database services). Administrative improvements also announced Thursday simplify availability, setup, backup, and patching for SQL Server running on an Azure VM. New auto HA (high-availability) setup capabilities, for instance, quickly provision AlwaysOn VM clusters to meet HA and DR requirements. This advance shines in hybrid scenarios where on-premises SQL Server workloads might failover to cloud resources, according to Microsoft.

In a move aimed at better performance on cloud infrastructure, Microsoft has introduced Azure G-Series VMs, which it says are ideal for large SQL Server OLTP workloads. They're especially well-suited for SQL Server's In-memory OLTP feature, as the G-Series VMs offer up to 32 CPUs with 448 GB of available memory (6.59 TB on local SSD). In short, the VMs offer plenty of memory so you can make the most in-memory OLTP performance.

Microsoft has plenty of company in supporting SQL Server deployments in the cloud. Rackspace, for one, supports more than 10,000 compute instances running Microsoft SQL Server on its private and public clouds. This week Rackspace introduced support for Microsoft SQL Server 2014 In-Memory OLTP and AlwaysOn HA and DR capabilities.

Attend Interop Las Vegas, the leading independent technology conference and expo series designed to inspire, inform, and connect the world's IT community. In 2015, look for all new programs, networking opportunities, and classes that will help you set your organization’s IT action plan. It happens April 27 to May 1. Register with Discount Code MPOIWK for $200 off Total Access & Conference Passes.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
D. Henschen
D. Henschen,
User Rank: Author
1/31/2015 | 11:40:47 AM
Re: Database optimized in the cloud
I guess the counter perspective might be that an on-premises deployment still makes sense if you know you have fixed, high-capacity, high-demand workloads and a scale, diversity of apps, and regulatory world that demands on-premises data centers. It might also makes sense if have an investment in a data center that you don't want to walk away from. Amazon says its services cost less than what even large enterprises might be able to replicate on-premises, but I haven't seen exhaustive studies that consider all the costs of the many services you have to tap to run all there is within an enterprise. Given hybrid-deployment realities, I'm sure it's very hard to do an apples-to-apples, all-cloud vs. all-on-premises TCO comparison.
Charlie Babcock
Charlie Babcock,
User Rank: Author
1/30/2015 | 6:12:54 PM
Database optimized in the cloud
Renting a big server loaded with SSDs as well as RAM for a few hours in the cloud makes a lot more sense than buying such a server, purchasing a lifetime license for SQL Server and operating them on premises. By t he time you get the system set up, something bigger and better will be available at a comparable price in the cloud. Database systems are natural residents of the cloud.
2021 Outlook: Tackling Cloud Transformation Choices
Joao-Pierre S. Ruth, Senior Writer,  1/4/2021
Enterprise IT Leaders Face Two Paths to AI
Jessica Davis, Senior Editor, Enterprise Apps,  12/23/2020
10 IT Trends to Watch for in 2021
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/22/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
Flash Poll