Skip to content

What’s new for In-Memory OLTP in SQL Server 2016 since CTP3

'SQL Server 2016 is making a lot of enhancements to In-Memory OLTP to make it easier to use and perform even better. In a previous post I listed all the new features that had been included in SQL Server 2016 up to and including CTP3. But we have added a lot of new features since then, including NULLable index key columns, LOB types and auto-update of statistics. Below are all the new features for In-Memory OLTP that we added between CTP3 and RC0. Underneath the list of new features you will find more detailed descriptions of LOBs and other off-row columns, ALTER TABLE improvements, and statistics improvements.'...

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/25/whats-new-for-in-memory-oltp-in-sql-server-2016-since-ctp3/

SQL Client Tools update for SQL Server 2016

'In SQL Server 2016 there have been several significant changes to the SQL Client Tools. Central to these changes are two primary goals:

  • The ability to ship tooling updates on a regular, monthly cadence

  • A single version of tools that work with all supported SQL Server versions on-premises or in a Virtual Machine, Azure SQL Database, and Azure SQL Data Warehouse

In addition to numerous new feature enhancements such as supporting Always Encrypted, Stretch Database, two-node basic availability groups for Standard Edition, PolyBase, Temporal Databases, and many more. There are also fundamental changes to SQL Server Management Studio (SSMS) and the other tools included in the SQL Server Client Tools package. These changes help align the release and distribution of the SQL Client Tools with the processes currently used by the SQL Server Data Tools.

Note: The SQL Client Tools package contains tools such as SQL Server Management Studio, Profiler, Database Engine Tuning Advisor, SQL Server PowerShell and several other management tools.'...

https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/25/sql-client-tools-update-for-sql-server-2016/

Microsoft: Announcing updates to the SQL Server Incremental Servicing Model (ISM)!!!

'As of January CU releases...we now recommend ongoing, proactive installation of CU’s as they become available. You should plan to install a CU with the same level of confidence you plan to install SPs (Service Packs) as they are released. This is because CU’s are certified and tested to the level of SP’s. Also, Microsoft CSS data indicates that a significant percentage of customer issues are often previously addressed in a released CU, but not applied proactively.  More so, CU’s contain added value over and above hotfixes. These also may contain supportability, logging, and reliability updates enhancing the overall experience.

In addition to messaging and guidance updates, we have made updates to the CU acquisition model.'...

https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-updates-to-the-sql-server-incremental-servicing-model-ism/