Shop Talk: 2022-08-15

The Recording

The Panelists

  • Kevin Feasel
  • Tracy Boggiano
  • Mike Chrestensen

Notes: Questions and Topics

Storing DMVs and Admin Data in Tables

The main topic for tonight started with a blog post Tracy wrote to store BlitzIndex results to a table. We expanded this to discuss a variety of other topics, like what else we might store in tables: wait stats, sp_whoisactive results, and other things which are transient. We also talked about cleanup strategies, the folly of not having a cleanup strategy, and long-term data retention. There was a bit of meandering and ranting here, as you’d expect.

Generating Text with NimbleText

Mike brought up a tool that he found useful: NimbleText. It looks to be quite useful for text manipulation. Mike used the free version, though pricing looks quite reasonable.

Leave a Reply

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