See my article about what makes me the fastest DBA you will ever encounter. This is a collection of some of the hundreds of snippets I use in my SSMS Tools Snippet collection. having these at my fingertips, where i type six or so characters and have the Snippet Manager paste hundreds of lines of code is one of the many things that make me such an incredible benefit to any company or consulting initiative.

Client Only snippets that are instantly available in SQL Server Management Studio at fingertips makes sense. things like envwho or envspace, that select data that is relevant to a developing DBA makes sense. That is what this massive collection of procedures are.

The design pattern is that the snippets only report information, and provide a helpful script to save time, but never actually change the data.