Scripts to update SQL Server config settings with Pester & dbatools
Use with caution! This will update the settings of the SQL instance that it is pointed at.
- Pull down all files to the same directory
- Open up Run-PesterTest.ps1 in VS Code
- Alter the ExampleServerConfigValues.csv with the settings and desired values that you wish to check and set
- Enter the name of the SQL instance
- Run script