Roger's BI Blog

One of the new options in SQL Server 2016 is to store cold data in Microsoft Azure. The idea behind it is that doing so could be far less expensive than storing the data locally. It sounds great but the reality is a bit different. in this blog post I will share my experiences with this feature.   Stretch database or the first steps versus "Distributed database" Looking closer at the feature of Stretch Database it incorporates actually the separation of data in a table over multiple servers. There is a main server and a back-end server that both contain a part of the data in your table. The back end server has currently to be in the Azure cloud. The front end can be in the Azure cloud to. When a query is fired on the table both front end and back end servers work together to get the data.  The MSDN Library shares an interesting picture: What this picture shows is that in the Azure cloud a SQL Server Database is created that stores all or a part of the cold data. The da...