Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

PowerTip: Identify if SQL Servers are configured to best practices

Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers (image) How can I easily check that my SQL Servers are all configured to meet best practices? (image) You can use SQL Server Assessments – the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment...

Executing SQL Server Assessments from PowerShell

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 ...