PowerTip: Identify if SQL Servers are configured to best practices

Doctor 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



Discussion is closed.

Feedback usabilla icon