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: Use PowerShell 3.0 to Find Updatable WMI Classes

October 19, 2012 Oct 19, 2012 10/19/12

Doctor Scripto

Summary: Use Windows PowerShell 3.0 to find updatable WMI classes. (image) How can you use a Windows PowerShell 3.0 cmdlet to easily find WMI classes that support updating? (image) Use the Get-CimClass cmdlet and specify the SupportsUpdate qualifier: Get-CimClass -QualifierName supportsupdate (image...

Use PowerShell to Work with the SQL Server Object

October 19, 2012 Oct 19, 2012 10/19/12

Doctor Scripto

Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to examine the SQL Server object. Microsoft Scripting Guy, Ed Wilson, is here. Today I want to continue exploring the SQL Server provider for Windows PowerShell. We will dive into the named instance node of SQL Server. Note Yesterday I introduced...

PowerTip: Save PowerShell Help Files

October 18, 2012 Oct 18, 2012 10/18/12

Doctor Scripto

Summary: Save Windows PowerShell Help files for use on other machines. (image) How can you download Windows PowerShell 3.0 Help files to update Help on other computers? (image) Use the Save-Help cmdlet and specify a network share as the destination: save-help -Module * -Force -Verbose -DestinationPath \\server1...

Introduction to the SQL Server 2012 PowerShell Provider

October 18, 2012 Oct 18, 2012 10/18/12

Doctor Scripto

Summary: Microsoft Scripting Guy, Ed Wilson, provides an introduction to the SQL Server 2012 provider for Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. One of the really cool things about SQL Server 2012 is the SQL Server provider for Windows PowerShell. By using the SQL Server provider, you gain access to a driver...

PowerTip: Find PowerShell Cmdlets Related to Jobs

October 17, 2012 Oct 17, 2012 10/17/12

Doctor Scripto

Summary: Find Windows PowerShell cmdlets that support the Job or the AsJob parameters. (image) How can you find Windows PowerShell cmdlets that relate to jobs? (image) Use the Get-Command cmdlet and the ParameterName parameter to search for parameters with the name Job or AsJob...