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

Getting Information from the SQL Server Provider with PowerShell

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

Doctor Scripto

Summary: Guest blogger, Mike Fal, talks about using the SQL Server provider with Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. We have a new guest blogger today. Please welcome Mike Fal. Mike Fal. Mike has over 15 years of experience as a database administrator. He has worked for many different industries, including ...

Scripting Blog [archived]

Mike Fal - Scripting Blog [archived]