Microsoft continues hybrid push with stretchable SQL Server

A new feature lets enterprises keep hot data on-premises and move cold data to the cloud

Microsoft is keeping up its push to provide businesses with hybrid cloud tools by offering a new feature that lets companies stretch their database tables from on-premises infrastructure to its Azure storage service. 

Microsoft is launching its SQL Server Stretch Database Service Wednesday, along with the first release candidate beta of SQL Server 2016. The new feature allows database administrators to set up certain tables to stretch from their on-premises infrastructure to Microsoft's cloud, while still allowing applications to access all the data across both environments. 

When a table is set up to use SQL Stretch Database, administrators can specify a length of time after which data is automatically moved from their on-premises SQL Server instance to Azure. Applications querying that database table will be able to see both the data stored on-premises and the data stored in Azure.

That functionality is key because it means that application developers shouldn't have to modify their work in order to take advantage of the feature -- administrators just need to enable it. 

The feature is designed to take advantage of the flexibility of the cloud to save enterprises money and allow them to use more costly on-premises resources for data they want to keep there, while still being able to hold onto data for long periods of time. 

The feature would be useful for organizations like retailers that want to keep years of customer purchase data on hand, but don't want to store all of it on premises, Mark Jewett, Microsoft's director of enterprise cloud and integrated systems marketing, said in an interview.

In the future, businesses can expect to use parameters other than the age of data to have the service move it automatically to the cloud.

Enterprises can also take advantage of SQL Server's Always Encrypted feature to ensure that their data is encrypted with a key that remains on-premises before the data is sent up to the cloud. That should help alleviate some concerns that administrators may have around the security of their data as it moves back and forth between their data centers and Azure. 

The new service is part of Microsoft's continuing push to attract companies looking to move to the cloud without jumping all the way into the deep end. Last month, the company released its first technical preview of Azure Stack, a software package that will allow businesses to run an Azure environment inside their own data centers. 

Microsoft has emphasized its hybrid cloud capabilities in an effort to capture the business of organizations that are gradually moving to the cloud. That strategy makes sense for the company because Amazon and Google, its competitors in the hyperscale cloud market, don't have the same investments in providing on-premises server software. 

Join the PC World newsletter!

Error: Please check your email address.

Tags Microsoft

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Blair Hanley Frank

IDG News Service
Show Comments

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?