New Features in SQL Server 2016 for Developers

Offered By: LinkedIn Learning

Course Description

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

Taught by

Anton Delsink

Related Courses

Scaling Your SQL Server Application
LinkedIn Learning SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data
PASS Data Community Summit via YouTube SQL Server 2014 In-Memory OLTP Management
PASS Data Community Summit via YouTube AlwaysOn in Microsoft SQL Server 2014
PASS Data Community Summit via YouTube SQL Server 2014 - In-Memory OLTP End-to-End - Preparing for Migration
PASS Data Community Summit via YouTube