My curiosity is to know more about the features which Microsoft has provided in the SQL server 2016 version which also allows the Sitecore to implement the xDB on the SQL Server 2016 itself, which was not possible before.
I totally agree, of having the advantage of Microsoft only infrastructure in the Sitecore solution, so we don’t have to maintain the 2 database administrators and infrastructure.
It would be great if someone can explain what’s was the problem/bottleneck of the older version of SQL server(prior to 2016 ), which could not handle the xDB requirement and what exactly they introduce in SQL server 2016, which makes it possible for Sitecore xDB to handle the high performance when data is growing at fast rate.
Any documentations on the gaps which Microsoft SQL server has had before, which they filled in the version 2016 from Sitecore xDB points of view?