SQL Server 2016 Advanced Features
Joseph D'Antoni
2 h 44 m
Lecture Overview
This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

Related Learning Path(s):
SQL Server 2016 Advanced Features
  • Implement In-Memory OLTP
  • Understand patterns for columnstore indexing
  • Implement real-time analytics
  • Configure and manage query store
  • Manage JSON data
  • Troubleshooting availability groups
Lecture Modules

In this module, students will learn how to implement In-Memory OLTP. We will cover Memory-Optimized Table architecture, accessing memory-optimized tables, indexing, concurrency, checkpointing, and native compilation.

In this module, the student will learn the architecture and usage of Columnstore Indexing in SQL Server 2016. We will start with an architectural overview of columnstore indexing. We will discuss the different access patterns for columnstore indexes and best practices for loading data into columnstores including columnstore maintenance. We will finish up with a look into ideal use cases and anti-patterns for columnstore indexing.

In this module, students will combine the skills learned in the previous modules to implement real-time analytics in SQL Server 2016.

In this module, students will learn how to use Query Store in SQL 2016. We will cover configuration and management of the Query Store. We will also look into key use patterns such as identifying query regression and forcing query plans.

In this module, the student will learn how to manage and work with JSON data in SQL Server 2016. This module will cover DML processes with JSON data. We will look at import and export of JSON and indexing JSON data.

This module will focus on troubleshooting Availability Groups using Extended Events traces. We start off with a review of extended event architecture then jump into a review of several key scenarios for leveraging extended events to troubleshoot Availability Groups.

Try Risk Free

Start a free trial

Skill Me Up subscriptions include unlimited access to on-demand courses with live lab lab environments with our Real Time Labs feature for hands-on lab access.

Subscription Benefits
  • Access to Real Time Lab environments and lab guides
  • Course Completion Certificates when you pass assessments