Great article series. We're now looking into an upgrade to sql 2016 in order to take advantage of column store indexes and in-memory-oltp. Currently we have one main customer database of about 5.5 TB which has a mix of perhaps 75% OLTP and 25% reporting-style queries.
What I'm looking for first is documentation on "gotchas" in either of those technologies for our situation.
Currently on sql 2012 Enterprise.
This stairway series was started before SQL 2016 was out, and I made the choice to not shift focus half-way. All levels currently out, as well as level 12 (that I am currently writing on), focus on SQL 2012 and SQL 2014.
Instead of shifting halfway to include SQL 2016, I have chosen to add one extra level (probably going to be level 13), which will cover all changes in SQL Server 2016. However, these changes are very manifold, so I will only be able to scratch the surface in that single level.
A very exhaustive and in-depth coverage of columnstores can be found in the blog series written by Niko Neugebauer, the technical editor for this stairway. See http://www.nikoport.com/columnstore/[/url]. It is an extremely long series. Starting from part 54 the improvements and changes in SQL 2016 are explained. (The 53 levels before that focus mainly on SQL 2014 and generic architecture; they were written before previews of SQL 2016 were available)