This page is where I will place presentations that I offer to SQL Saturday events and User groups meetings. Please feel free to download and use for your own purposes. All is ask is that you give proper credit to me.
Visit here is you are looking for the files for a specific event.
This session focuses on how to create Extended Event sessions and how to use them to find performance problems. This session was presented at a number of SQL Saturday events, including Dallas, Chicago, Columbus, Iowa City, Madison, Boston and Indianapolis. All in 2018.
Presentation: Extended Events
Demo Code: ExtendedEvents
SQL Server Statistics
The focus of this session is to go over the basics of SQL Server statistics, how to find information about them and the importance of keeping them up to date. This session was presented at several user groups in 2018 as well as the SQL Saturday event in Cleveland.
Presentation: SQL Server Statistics
Demo Code: Statistics
This session was one I really enjoyed presenting. The primary goal of this session is to expose the learner to the various aspects of an execution plan as well how to read them.
Presentation: Execution Plans
Demo Code: Execution Plan Session Files
SQL Server Analysis Services can be a bit overwhelming for someone who has never used it before. This session is intended to help make learning the basics of SSAS. Over the last few years, this sessions was presented several times a SQL Saturday events.
Presentation: SQL Server Analysis Services Fundamentals
Sample Code: SSAS Overview
SQL Server Change Data Capture
This is from my first SQL Saturday presentation in Indy in 2014. It offers a high level overview of why to use CDC, how to set it up and to read the CDC data.
Presentation: SQL 2014 ChangeDataCapture Indy