What's New in SQL Server 2016

1. Advanced Analytics (RRE integration)

- Data exploration and predictive modeling with R over SQL server data
- Operationalizing R code using T_SQL

2. Transnational replication from SQL server to Azure SQL DB

3. Per Session Wait Statistics

4. Instant File initialisation configuration during initial setup

5. Enhanced backup to Azure

6. In-memory OLTP Enhancement

7. Always Encrypted

8. Query Store and Live Query Statistics

9. Row-Level Security

10. Stretch Database

11. AlwaysOn Enhancements

12. PolyBase

13. JSON Support

14. TempDB Enhancements