The SQL Server Stretch Database Service was released on March 2nd.
One of this new service’s most striking features is that it enables database administrators to create tables which stretch from on-premises infrastructure to Azure, whilst still allowing applications access to all data across both these environments.
The Microsoft Azure website notes the main benefits of SQL Server Stretch Database as:
“– Scale SQL Server 2016 using bottomless cloud storage
– Make warm and cold data available to users at low cost
– Access and query stretched data online
– Move data easily—no query or application changes required
– Use with advanced security features like Always Encrypted
– Reduce maintenance and storage costs for on-premises data.“
Highlighting the value of this release, Forbes listed this in first place in its article “5 Biggest Things In Tech You Missed This Week: 5/3/16“. Of the importance of the service for businesses the article says, “While the cloud is hugely popular, many of my clients still have on-premise applications due to security and performance reasons. On-premise has proved to be more expensive to maintain, so now Microsoft is giving its customers the ability to ‘stretch’ (move) older, lesser-used data to its less expensive Azure platform while still being able to be viewed and shared. This way, storage and maintenance costs would be lower.“
Full details about the SQL Server Stretch Database are available via Microsoft here.
Sources: Forbes.com, Microsoft