SQL Server 2016 Stretch Database

One of the features in SQL Server 2016 that you will want to explore is the ability to store your historical data in the Azure cloud.  By leveraging the Stretch Database feature your applications can silently migrate data to the cloud without having to change your existing code.  Stretch Database is enabled on a table by table basis.  For example, if you have millions of records in a sales details table that includes current and historical data.  Performance on the application could be impacted by having the less frequently queried historical data in the same table as current data.  By off loading the old records to Azure and limiting the local table to more current data, performance would improve and administration time would decrease.

For complete information see: MSDN: SQL Server 2016 Strech Database

The post SQL Server 2016 Stretch Database appeared first on BI and Predictive Analytics.