search

PureStorage-OpenConnect / powershell-toolkit-3

PowerShell Toolkit 3.x
Apache License 2.0
6 stars 1 forks source link

SQL Server Best Practices cmdlet #81

Open barkz opened 1 year ago

barkz commented 1 year ago

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 commented 1 year ago

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

aguzev commented 1 year ago

Desired State Configuration is an alternative to Pester.