Scripting Blog

A place to learn about PowerShell and share stories of automation

Jonathan Allen - Scripting Blog

PowerTip: Identify if SQL Servers are configured to best practices

August 21, 2019 Aug 21, 2019 08/21/19
Doctor Scripto
Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers 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 ...

Executing SQL Server Assessments from PowerShell

August 21, 2019 Aug 21, 2019 08/21/19
Doctor Scripto
Summary: Using the SQLServer module cmdlets to review and monitor SQL Server instance and database configuration Q: Hey, Doctor Scripto! I have loads of SQL Servers in my area of responsibility and I know they all need certain configuration settings but I'm never confident that they are all set just right so I spend a long time every ...