HRSSUG January 2019 Meeting

This Month’s Speaker :

Speaker: Joseph D’Antoni

Principal Consultant, Denny Cherry and Associate

Bio:

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Title:

Automagic Tuning – SQL Server 2017 and Beyond

Abstract:

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2017 takes that power a few steps further. Have you ever:• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish? Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.

This entry was posted in Meetings. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *