Scripting Blog [archived]

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

PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

Summary: Using PowerShell and a very simple Regular Expression to convert Random counts of spaces to a Comma (image) Hey Doctor Scripto! I have some string based output from a non PowerShell application. The output is good but I need to easily parse it. Is there a way to convert that data to something consistent like "Comma Separated...

Automating Quser through PowerShell

Summary: Using PowerShell to automate Quser to identify users to Logoff systems in Windows Hey Doctor Scripto! I need to log a user off every computer they’re logged into. The problem is, I don’t know which ones. How can I discover which computers they’re logged into and then log them off? That's a most excellent question!  I know...

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