I've just recently been reading up on columnstore indexes. We are on SQL Server 2016, and given the original publication date of this article, I am really surprised that you don't cover the additional enhancements that Microsoft has made in 2016 regarding the use of columnstore indexes. Most of the limitations you mention are addressed in SQL Server 2016 (and even more-so in 2017).