New Features in SQL Server 2016 for Developers

Take a developer-focused tour of SQL Server 2016. Learn how to use new features to write less code and bring increased security, performance, and reliability to your applications.

Introduction

• Introduction
• What you should know

1. Developers! Developers! Developers!

• Query store
• Developer Edition license is now free
• Consistent programmability surface area
• StretchDB
• Temporal tables
• Backup to Azure BLOB
• PolyBase
• SQL Server on Linux

2. Database Engine: Security

• Row-level security
• Dynamic data masking
• Always encrypted
• Pool blocking period

3. Database Engine: Programmability

• STRING_SPLIT
• CREATE or ALTER
• JSON Support
• SQLClient on .NET Core
• Visual Studio and Entity Framework

4. Database Engine: Performance

• In-memory OLTP enhancements
• Operational analytics
• XEvent library performance improved

Conclusion

• Next steps