SQL Server Inventory using PS dbatools ~ Matt Andreson

Do you know what your SQL Server environment looks like? Using PowerShell along with dbatools (https://dbatools.io/) and PowerBI we will cover how to collect, store, and document this information.

Data collection includes:
● CPU
● Memory
● Database file sizes
● Disk information
○ Disk size
○ Consumed space
○ Free space
● SQL backups
● OS information

Speaker:
Matt is a Microsoft SQL Server DBA with over 10 years of experience. He has managed databases for healthcare, manufacturing, and entertainment companies on traditional DBA teams and on BI teams.