SQL with Manoj

Microsoft announced the next update of the recently released Community Technology Preview (CTP) 2.2 version of SQL Server 2016, the CTP 2.3, link.
 

[Register and Download the CTP 2.3 Evaluation version (180 days) here]
 

Direct download link for ISO: SQLServer2016CTP2.3-x64-ENU.iso ~ 2.6 GB
 

Check version and SQL build: select @@version
Microsoft SQL Server 2016 (CTP2.3) – 13.0.500.53 (X64) Aug 24 2015 03:51:16 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows 10 Enterprise 6.3 (Build 10240: )
 
–> Enhancements and Issues fixed in this release:

1. Row Level Security support for In-memory OLTP tables, with Natively Compiled UDF support, demo video.

2. In-memory DW (Data Warehouse) ColumnStore performance optimizations. NCCI can now be created on tables with triggers, enabled with CDC/Change Tracking, demo video.

3. Performance improvements to SSAS, including DAX query performance, DirectQuery enhancements, support for variables in DAX.

4. Enhancements to SSRS, including an updated Report Builder with a modern theme and report rendering for modern browsers built on HTML5 standards.

5. Enhancements to SSIS, by releasing oData v4 protocol support, SSIS Error Column support, and advanced logging levels.

6. Improvements to MDS, Many to many derived hierarchy, Excel Add-in Business rule management, and Merge conflicts.

7. Core engine scalability improvement, dynamically partitioning thread safe memory objects by NUMA or CPU, which enables higher scalability of high concurrency workloads running on NUMA hardware.

8. Improvements to the Query Execution with improved diagnostics for memory grant usage.

9. DBCC CHECKDB includes Performance improvement with Persisted computed columns & filtered indexes validation, and Validating a table with thousands of partitions.
 

For all other new features released in SQL Server 2016, please check my blog posts here.
 

So, download the Preview today and start playing with the new features and plan your DB migration/upgrade.
 

Check the [SQL Server blog] for all these updates in detail.
 

Check & Like my FB Page.