Implementing Stretch Database

Learn how you can enable the Stretch Database feature in SQL Server 2016.

Introduction to SQL Server Stretch Database

In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.

Stretch Database in SQL Server 2016 RTM

Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.

Stretch Database Datatype Limitations

Stretch Database Pricing

Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2

Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.

SQL Server 2016 Stretch Database

SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.

Learning Stretch Database

References and links about the Stretch to Azure feature in SQL Server 2016.

SQL Server 2016 – Introduction to Stretch Database

Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. Tim Radney introduces Stretch Database by looking at the applications and limitations of the new feature.

RE: Altering Merge Replication Article

I'm watching your topic with interest, and hoping for replies from the gurus as well.  One key piece of info that would help your cause would be knowing what version of SQL server you are running.  We (still) only have Version 7 here and I know that the replication functions have been improved immensely starting […]