Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
SQL Server 2016 Advanced Features
Lecture
Joseph D'Antoni
Advanced
2 h 44 m
2017-02-23
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.
Objectives
  • 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
  • MUCH MORE!