Create the perfect morning checks report with dbatools

There’s often a few things we like to check on every morning with our first cup of coffee\tea\juice. Depending on your role this list might be different – but with this session I’ll teach you how to automate a list of checks, and have them auto-magically delivered to your inbox every day.

In this session I will show you my standard morning checks as a DBA, checking for the following with dbatools.

- Any databases missing backups?
- Any jobs (or job steps) that have failed overnight?
- Any worrying messages in the error log?
- Any disks about to run out of space?
- And many more…

I’ll then generate a beautiful HTML email and status page that shows you the results, and highlights any issues that you should work on first.

This session will give you the structure needed to check anything that you can write a script for, the possibilities are as wide as your imagination.

Join me as we automate our morning checklists.

- teach attendees how to gather information with PowerShell - teach attendees how to present that information with the PSHTML module - give attendees a flexible toolset for creating their own reports