This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch.
In part 1, the first hour, I write the proof-of-concept query:
In part 2, the second hour, I move the query into sp_BlitzFirst, test it, debug it, and check it into Github:
And finally in the third hour, I switch to open Q&A and do a few live demos:
And now, I’m enjoying the well-earned bagel that I discussed on the webcast: