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.
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
(...
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 ...
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’,&...
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 ...
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&...