SQL Server Best Practices cmdlet

[barkz]

Pinged Anthony Nocentino about creating a SQL BP cmdlet.

I think that would be exceptionally useful! SQL BP is a deep topic. We could hitch our wagon to this Microsoft project...and add in our own tested BPs for SQL on Pure. That framework from MS enables folks to develop their own customized rules.
https://learn.microsoft.com/en-us/sql/tools/sql-assessment-api/sql-assessment-api-overview?view=sql-server-ver16
https://github.com/microsoft/sql-server-samples/tree/master/samples/manage/sql-assessment-api

We could use their rules as a starting point for BPs.
Preference to use Pester and dbatools to get the info.

[aguzev]

Additionally, a SQL Assessment API ruleset for PureStorage solutions could be handy for some users.

[aguzev]

Desired State Configuration is an alternative to Pester.