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

Use PowerShell to Troubleshoot SQL Server via the Error Log

June 29, 2012 Jun 29, 2012 06/29/12

Doctor Scripto

Summary: Guest blogger, Laerte Junior, discusses using Windows PowerShell to troubleshoot SQL Server by parsing the SQL error log. Microsoft Scripting Guy, Ed Wilson, is here. Today we have another guest blogger, Laerte Junior. Here is a little bit about Laerte. (image) Laerte Junior is a SQL Server specialist and an active member of WW...

Four Easy Ways to Import CSV Files to SQL Server with PowerShell

November 28, 2011 Nov 28, 2011 11/28/11

Doctor Scripto

Summary: Learn four easy ways to use Windows PowerShell to import CSV files into SQL Server. Microsoft Scripting Guy, Ed Wilson, is here. I was chatting this week with Microsoft PowerShell MVP, Chad Miller, about the series of blogs I recently wrote about using CSV files. He thought a helpful addition to the posts would be to talk about ...

BATCHman Uses PowerShell to Import a CSV File into His SQL Server

September 4, 2011 Sep 4, 2011 09/4/11

Doctor Scripto

Summary: Windows PowerShell superhero BATCHman quickly imports CSV data into his SQL Server. Microsoft Scripting Guy Ed Wilson here. Sean Kearney is back today with Episode 6 of the BATCHman series. Note You can read all gripping, engaging, informative, and downright funny BATCHman episodes. (image) Whenever trouble ...

Capture Performance Counter Data and Write to SQL Server

July 27, 2011 Jul 27, 2011 07/27/11

Doctor Scripto

Summary: Learn how to use Windows PowerShell to capture performance counter information and write the saved data to a SQL Server database. (image) Hey, Scripting Guy! I have been enjoying your PoshMon articles this week, but I have found them to be of limited value. I would love to see how I could store this performance data in a SQL ...

Use PowerShell to Monitor Your SQL Server Performance

July 25, 2011 Jul 25, 2011 07/25/11

Doctor Scripto

Summary: Guest Blogger Kevin Kline talks about using Windows PowerShell to monitor SQL Server performance. (image) Hey, Scripting Guy! I am wondering about using Windows PowerShell to work with SQL performance counters. Is this something that can be done? —SH (image) Hello SH, Microsoft Scripting Guy Ed Wilson here. We have...

Scripting Blog [archived]

SQL Server - Scripting Blog [archived]