PowerTip: Identify if SQL Servers are configured to best practices

Doctor Scripto

Dr Scripto

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

 

Doctor Scripto
Dr Scripto

Scripter, PowerShell, vbScript, BAT, CMD

Follow Dr Scripto   

0 comments

    Leave a comment