Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It

PASS Data Community Summit via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover the key enhancements in SQL Server 2017's Database Engine and learn why upgrading is beneficial in this comprehensive conference talk. Explore improvements in query processing, scalability features, and core relational database functionalities. Gain insights into TempDB optimizations, cumulative updates, new DMVs, online index rebuild limitations, and backup speed improvements. Understand the implications of CLR strict security and whitelisting, clusterless availability groups, and hybrid high availability. Delve into Query Store enhancements, automatic tuning, execution plan improvements, and adaptive query processing techniques. Learn about interleaved execution, table-valued functions, batch mode memory grant feedback, and graph database capabilities. Evaluate the advantages of upgrading to SQL Server 2017 over SQL Server 2016 and address potential risks and concerns.

Syllabus

Introduction
Overview
Agenda
Support Files
TempDB
Cumulative Updates
New DMVs
Online Index Rebuild Limitations
Backup Speed Improvements
CLR Strict Security
CLR Whitelisting
Clusterless Availability Groups
Clusterless Scale Replicas
Hybrid High Availability
Query Store
Query Store Weights
Automatic Tuning
Query Store Enhancements
Execution Plan Enhancements
Cumulative Update 3
Replication
Adaptive Query Processing
Interleaved Execution
Tablevalued Functions
Tablevalued Results
Adaptive Query Processor
Batch Mode Memory Grant Feedback
Batch Mode Adaptive Join
Graph Database
Scaleout
Parallelization
Questions

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.