New Features in SQL Server 2016 for Developers

Go to class
Write Review

Free Online Course: New Features in SQL Server 2016 for Developers provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. New Features in SQL Server 2016 for Developers is taught by Anton Delsink.

Overview
  • 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.

Syllabus
  • 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