The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Scripting Blog [archived]

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

PowerTip: Combine Arrays in PowerShell

October 31, 2015 Oct 31, 2015 10/31/15

Doctor Scripto

Summary: Learn how to combine two arrays in Windows PowerShell. (image) How can I use Windows PowerShell to combine two arrays stored in two different variables? (image) Use the + operator, for example: [array]$a = @('a','b','c') [array]$b = @(1,2,3) [array]$c = $a + $b (...

PowerShell Spotlight: November 2015

October 31, 2015 Oct 31, 2015 10/31/15

Doctor Scripto

Summary: Guest blogger and PowerShell MVP, Teresa Wilson talks about Windows PowerShell community events.Microsoft Scripting Guy, Ed Wilson, is here. It is the last Saturday of October, and that means it is PowerShell Spotlight day with guest blogger, Teresa Wilson.Hello everyone. I hope you are having a scriptastic day! The MVP Summit starts ...

PowerTip: Use PowerShell to Back Up System Databases

October 30, 2015 Oct 30, 2015 10/30/15

Doctor Scripto

Summary: Use Windows PowerShell to back up system databases. (image) How can I use Windows PowerShell to dynamically back up all of the system databases on my servers? (image) Combining provider lookups with the Backup-SqlDatabase cmdlet makes this simple: $instances = @(‘KIRK’,’SPOCK’,’PICARD’,&...

Use SQL Server PowerShell Provider for Fun and Profit

October 30, 2015 Oct 30, 2015 10/30/15

Doctor Scripto

Summary: Guest blogger, Mike Fal, talks about leveraging the SQL Server PowerShell provider. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Mike Fal. He blogged yesterday (see Getting Information from the SQL Server Provider with PowerShell), and he continues today... In my previous post, I covered how to gather and ...

PowerTip: Use PowerShell to Find Versions of SQL Server

October 29, 2015 Oct 29, 2015 10/29/15

Doctor Scripto

Summary: Use Windows PowerShell to find versions of SQL Server.(image) How can I use Windows PowerShell to see all the versions of SQL Server I have installed?(image) Use the provider and a list of instances to look them up as if they were files in a directory:$instances = @(‘KIRK’,’SPOCK’,’PICARD&...

Scripting Blog [archived]

October 2015 - Scripting Blog [archived]