This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small Changes Can Make a World of Difference”, talking about a bunch of “small” features that were introduced in SQL Server 2012 and 2014, and can help DBAs a lot.
Among of the topics I’ll cover:
IO throtteling with SQL Server 2014 Resource Governor
Buffer Pool Extension to SSDs
Online schema changes
Partition Switch and Online Index Operations improvements
Features that can boost productivity when working with SSMS
SQL Server 2014 Delayed Durability
What is sys.dm_exec_query_profiles and why it’s so revolutionary?