Presentation Materials

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.

Extended Events

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

Execution Plans

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

SSAS Overview

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