Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been added.

Now SQL Server appears to get the same treatment: SQL Server 2016 CTP 2.1 has just been released. There is nothing groundbreaking in this release – which can be considered as an upgrade of CTP2 – but there are some additional functionalities and improvements in the database engine.

If you have already installed CTP2, you can just upgrade it to CTP2.1 following the usual upgrade procedure. Just spin-up the SQL Server set-up, go to Installation and choose Upgrade from a previous version of SQL Server. Hit Next a few times, choose which instance and which features you want to upgrade and you’re all done.

Before:

version_1

After:

version_2

One of the new features for example is the ability to use computed columns in a temporal table. Exciting! (OK, I’m just using this as an example that I actually upgraded my system)

temporal_before

After the upgrade:

temporal_after

 

Anyway, I hope we can see more incremental releases of SQL 2016 soon and dare I say with more exciting Business Intelligence features.