Главная
Study mode:
on
1
Introduction
2
Overview
3
Agenda
4
Support Files
5
TempDB
6
Cumulative Updates
7
New DMVs
8
Online Index Rebuild Limitations
9
Backup Speed Improvements
10
CLR Strict Security
11
CLR Whitelisting
12
Clusterless Availability Groups
13
Clusterless Scale Replicas
14
Hybrid High Availability
15
Query Store
16
Query Store Weights
17
Automatic Tuning
18
Query Store Enhancements
19
Execution Plan Enhancements
20
Cumulative Update 3
21
Replication
22
Adaptive Query Processing
23
Interleaved Execution
24
Tablevalued Functions
25
Tablevalued Results
26
Adaptive Query Processor
27
Batch Mode Memory Grant Feedback
28
Batch Mode Adaptive Join
29
Graph Database
30
Scaleout
31
Parallelization
32
Questions
Description:
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.

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

PASS Data Community Summit
Add to list