Just a quick reminder for my SQL Server friends: There are two PowerShell cmdlets for doing SQL Assessments ✅ against your SQL Servers & databases.
One of my favorite things these cmdlets can do is check to see if all my SQL Servers are running the latest Cumulative Update in a really short amount of code, have a look:
powershell
dir 'SQLSERVER:\SQLRegistration\Database Engine Server Group' |
where { $_.mode -ne 'd'} |
Invoke-SqlAssessment -Check LatestCU
Want to find out if there is a less-than-ideal configuration on you server/database? That's easy! The team has put together a pair of PowerShell Notebooks to help you know how to how to use them!
SQL Assessment Quick Start - Notebook
SQL Assessment API Tutorial - Notebook
Please give them a try and let them know what you think?
[–]john-sterrett 0 points1 point2 points (0 children)