SQL On The Edge #4 - SQL 2016 Stretch Database
As the Microsoft SQL Server team continues to build very interesting integrations between the full SQL Server box product we all know and the Azure cloud platform. Stretch database is another integration that will be included as part of SQL Server 2016 and it will help customers solve these issues:
Running out of space in your own data center?
Have long archival requirements for your data?
Users still query data from many years ago on occasion?
You don't want to do code changes to deal with these scenarios?
Stretch database attacks those problems by allowing us to "stretch" tables from on-premises (or full VM) SQL Servers into a table living in Azure SQL Database. Your users and applications will not be aware of where the data is coming from, they just have to query and let SQL Server handle the behind the scenes magic to either go to the local data files or go to the cloud to get the records.