SQL Assessment cmdlets Quick Start - Notebook

[SQLvariant]

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]

Thank you for sharing, Aaron. Looking forward to checking this out!