SQL Server 2016 Advanced Features

In this learning path, you will learn about some of the advanced features in SQL Server 2016.

4 (8)
1 Lectures
4 Labs
Intermediate
5h 24m
Jul 8 2018
Feb 23 2017
4 (5)

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

0%
Skill Me UP
Jan 10 2018
5 (1)

In this lab, you will explore the new SQL Server 2016 real-time operational analytics feature. You will evaluate the performance improvements you will get when you add updateable nonclustered columnstore indexes on top of disk-based tables as well as memory-optimized tables.

0%
Skill Me UP
Jan 10 2018
4 (1)

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

0%
Skill Me UP
Jan 10 2018
5 (1)

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

0%
Skill Me UP
Jan 10 2018
0 (0)

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries ...

0%
Get to know the authors