Learn dbatools in a Month of Lunches

26 Validating your estate with dbachecks

For decades, most of the team writing this book had our own daily/weekly/monthly checklists to validate our SQL Server environments. At least once each day, we’d ensure that backups were scheduled and working as required. We’d check to see whether all of our integrity checks passed. We’d even spend a lot of time keeping our checklists up to date as our environment grew, and we learned more about managing SQL Server. Some of us performed this validation manually, whereas others created an automated routine that would perform the checks automatically.

What we didn’t have for all those years was a single, community-wide checklist—nor did we have have a free and open source framework to make our checks easier. ...