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