From the course: Automating SQL Server with dbatools

Unlock the full course today

Join today to access over 24,100 courses taught by industry experts.

Review SQL Server Configuration Settings

Review SQL Server Configuration Settings - SQL Server Tutorial

From the course: Automating SQL Server with dbatools

Start my 1-month free trial Buy for my team

Review SQL Server Configuration Settings

“

- [Instructor] SQL Server has many configuration options available, and it's very likely, either from following best practices, or from experimentation in your own estate, a lot of these settings won't be set to the defaults. Let's take a look at what our configuration options are set to, how we can reconfigure our systems, and also how we can export and import settings. Once again, let's use Get-Command to find all of the commands dbatools has, that matches the pattern configure. The naming of these commands should be starting to feel familiar at this point. The verb tells us what the action will be, either getting or setting, for example, and the noun tells us what we're acting on. In this case, SpConfigure options. Let's run Get-DbaSpConfigure for our SQL instances. This will return all of the available configuration options, and I'm hoping this to format table, so it's a little easier to review. We can also filter…

Contents