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