It was a pleasure to host SQL Server 2016 community launch event for the full day. We had a great support from both speakers and attendees. It was an occasion of learning for everyone where attendees learnt about SQL Server 2016 features and speakers learnt about the various SQL Server solutions from the attendees. The whole intent of this event was to make attendees aware of the new and enhanced capabilities of SQL Server 2016.
The agenda of the event was:
- Enhanced Security – Always Encrypted| Row Level Security| Dynamic Data Masking – Udhay Bhanu Pathania
- Performance and Scalability – Live Query Statistics| In-memory OLTP– Anil Sharma
- HADR – Hybrid DR on Azure VMs using SQL Server 2016 AlwaysON and Enhancements – Harsh Chawla | Twitter , Blog
- HyperScale Cloud – Stretch DB | Managed Backups – Gaurav Srivastava
- Advanced Analytics | Leverage R and PolyBase Queries in SQL Server 2016 – Sourabh Agarwal
Let me share the learning references for these topics:
AlwaysON SQL 2016 AG – http://searchsqlserver.techtarget.com/feature/Whats-new-in-2016s-SQL-Server-AlwaysOn-Availability-Groups
https://www.youtube.com/watch?v=vG8H7hTNfdY&index=7&list=PL8nfc9haGeb6T3HaGhQWvBz1AqS9d6Zv_
AlwaysON Encrypted – https://www.youtube.com/watch?v=EPIq70NzQ4k
http://blogs.microsoft.com/next/2015/05/27/always-encrypted-sql-server-2016-includes-new-advances-that-keeps-data-safer/#sm.0018nh41016q6epnxzk2rrogl856l
Dynamic Data Masking – https://www.youtube.com/watch?v=7ch8tbstkyM
Live Query Statistics – https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/
Query Store – https://www.youtube.com/watch?v=HxBRjZXi3L0
In-memory OLTP – https://www.youtube.com/watch?v=l5l5eophmK4
https://msdn.microsoft.com/en-us/library/dn133186.aspx
R-Integration with SQL Server 2016 – https://www.youtube.com/watch?v=8Sly49zDZEw
Polybase in SQL Server 2016 – https://www.youtube.com/watch?v=lBxSB0UY4wA
HTH!