Michael L John - Saturday, June 24, 2017 5:45 AM
Ya know... that sounds like it might be a good idea. I've done that in the past for my local chapter. I called it "Tool Time" but we could call it whatever you folks suggest. It had things like a couple of automated reports (Morning "Jobs" report, and Enterprise Wide disk report/warning system and it does NOT require SSRS!), a mail system that DOESN'T require you to setup mail in the database (if you're in a hurry), a killer blocking monitor system that captures and list any blocking in a very meaningful hierarchical order along with the code that's involved, backup code that auto-magically does backups even on new databases, a clickable PerfMon button that would display the last half hour of various performance indicators in real time, how to correctly setup xp_CmdShell for safe usage, and a couple of useful procs (sp_WhatsRunning and sp_ShowWorst) that help you quickly find your worst performing queries, which may not actually be your longest running queries. Might be good for the "So you wanna be a DBA track" that you have. Could easily cover 2 sessions if you want some useful details. Lemme know and I'll put the pieces together in a presentation along with an abstract.
I don't know if I'll have it ready in time but I'm working on one about why you don't ever have to rebuild/reorganize indexes and a great way to find used stats, which also lets you find and drop unused stats, which is all that you really need to do instead of a bunch of index maintenance that may actually cause slowdowns and blocking when it's done.
--Jeff Moden
Change is inevitable... Change for the better is not.