>>>in-memory optimized tables/columnstore indexes is definitely a big direction Microsoft is going with SQL Server.
>
>I heard that SQL Server 2019 will have the most amazing new ability: spooling those in-memory optimized tables to disk. ;-)
Well, I doubt that. :)
First, the last five releases have been in even numbered years. 2008, then 2008R2 (released in 2010), 2012, 2014, and 2016. They have consistently released roughly every two years for quite some time now.
Second, the direction of enhancements in the last 3 releases (and the architectures they recommend for Parallel Data Warehouse) definitely points towards in-memory. Corporate org charts with senior executive references are being re-written as we speak :)