August 21st, 2019

PowerTip: Identify if SQL Servers are configured to best practices

Doctor Scripto
Doctor Scripto
Scripter

Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers

A picture containing scissors Description automatically generated

How can I easily check that my SQL Servers are all configured to meet best practices?

You can use SQL Server Assessments – the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment on your SQL Server as seen below

Get-SqlInstance  “DemoSQLServer” | Invoke-SqlAssessment

PowerShell, Doctor Scripto, PowerTip, Johnathan Allen, SQL Server

 

Category
Doctor ScriptoPowerShellPowerTip
Topics
Doctor ScriptoJonathan AllenPowerShellPowerTipSQL Server

Author

Doctor Scripto

The "Scripting Guys" is a historical title passed from scripter to scripter. The current revision has morphed into our good friend Doctor Scripto who has been with us since the very beginning.

0 comments

Discussion are closed.

Read next