Finally getting around to posting these, sorry about the delay.
My powerpoint slides can be downloaded here.
Some of the slides included simplified queries so the text would fit on a single screen and remain legible.
To find who is using temp, a more functionally robust query can be found here:
/2018/03/08/who-is-using-temp-and-what-are-they-doing/
Similarly, the who is blocking whom query has a fuller version here:
/2018/03/04/who-is-blocking-whom-and-what-are-they-doing/
Thanks to all who attended and special thanks for the follow up questions.