Monday, July 3, 2017

Webinar "SQL Server 2017 Community-driven Enhancements" PASS DBA Virtual Group

On July 28th 2017 I have presented the webinar "SQL Server 2017 Community Driven Enhancements" for PASS DBA Virtual Group

These are te topics I have covered

Introduction
Smart Differential Backup
Smart Transaction Log Backup
SELECT INTO …. ON Filegroup
Tempdb Setup improvements
Tempdb monitoring and planning
Transaction log monitoring and diagnostics
Improved backup performance for small databases on high-end servers
Processor information in sys.dm_os_sys_info
Capturing Query Store runtime statistics in DBCC CLONEDATABASE
Resumable Online Index Rebuild
Automatic plan correction

Here is a link to the slides and demos


Here is the recording


Please send me your feedback