What’s New in SQL Server Performance, Scalability, and Availability

Instructor-Led 5 Agenda

Description

This course describes new and enhanced features in SQL Server Performance, Availability, and Scalability.

This course describes new and enhanced features in SQL Server Performance, Availability, and Scalability.

Please refer to Overview

Database professionals with experience of SQL Server 2016 who want to learn about the new features in SQL Server 2017.

Course Introduction Lesson Id 1

Course Introduction

Adaptive query processing Lesson Id 2

Adaptive query processing

Automatic tuning Lesson Id 3

Automatic tuning

Availability Scalability Lesson Id 4

Availability Scalability

Next Steps Lesson Id 5

Next Steps

Lesson Id	Title	Description
1	Course Introduction
2	Adaptive query processing
3	Automatic tuning
4	Availability Scalability	Lab: Performance and availability – adaptive query processing<br />Interleaved execution<br />Batch mode memory grant feedback<br />Batch mode adaptive joins
5	Next Steps