This is the 13 part newsletter series for users of Minion Enterprise, the SQL Server management solution.
In this introductory newsletter:
- Pointing out what “Quick Start” sections to walk through to complete your ME setup
- Introducing the Collector schema, which holds all the goodies
- Your first module: Index Stats, which allows you to research index issues across the whole enterprise
- The Database Files Module, which you can use for tracking and projecting file growth over time, among other things
- The Script Schemas Module, which will save you at some point, from objects dropped or modified or somehow lost
- The Logins module, which is the basis for a lot of amazing security functionality
- The Clone Users utility, which makes account creation and management effortless
- Minion Enterprise Schemas, which (as we explain) logically group ME functionality
- The Drive Space Module, which allows you to deeply customize “drive space is running out” alerts
- The Service Properties Module, which is super cool. It gathers information on SQL services on all your servers! Service down alert, anyone?
- The Instance Config Module, which collects and manages sp_configure settings centrally
- The Error Log Search Module, which lets you set up error log search terms and find them wherever they occur in your SQL environment
- The Wait Statistics Module, which gathers wait stats info for your research and alerting purposes
- Frequently Asked Questions, which we answer
- The Database Module, and along with that the New/Retired Database alert
- Custom Objects, and whether you should create them in ME (spoiler answer: Heck yes.)
- The Database Properties Module, which gets a ton of information, including the date of the last full, log, or differential backup
- To Autogrow or Not?, which is a blog of Sean’s discussing autogrow, especially in the context of Minion Backup and Minion Enterprise
- The Objects, Tables, and Columns modules, which are three separate but similar modules that collect data on…can you guess what?
- Top 20 Features, which is a pretty subjective, but pretty good, list
- The AD Group Members Module, with which you can audit your servers, see who has access where, and on and on
- Utility: Login Access Method Audit, which shows you how users are gaining access to SQL, and whether they are getting in through multiple methods
This last newsletter explains why “Work like a DBA” is the ME motto, and introduces you to the idea of the set-based enterprise.