Data Cleanup

Steve wishes we could do some data cleanup and archival every year. Or even more often.

Stretch Database limitations

Configuring Stretch Database

Azure Stretch Database, Part I: Getting Going

With most innovative new technologies, Azure Stretch Database demos make it look completely easy. Here is a step by step to get going, with examples. Part One of a Two-Part series.

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.