• In fact, I might argue that apart from Hekaton, this wasn't necessarily worthy of a full release. PowerBI, BPE, the cardinality estimator changes, some Azure improvements and AlwaysOn changes, all were included, but this felt like a bit of a mish-mosh of features. We didn't see many of the technologies from previous versions (Service Broker, Contained DAtabases, SSRS, SSIS, etc) enhanced or improved.

    I'm impressed by Clustered ColumnStore. It's completely not practical for OLTP databases, but for data warehouse applications with star schema or flat tables, it's a game changer. For flat, extremely denormalized table containing many columns and billions of rows, it's amazing how this new feature can compress down the size of the table and improve performance of queries that return a narrow range of columns.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho