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

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.

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