Scripting Blog

A place to learn about PowerShell and share stories of automation

May 2011 - Scripting Blog

Use PowerShell to Get the SQL Server Error Log

May 31, 2011 May 31, 2011 05/31/11
ScriptingGuy1
 Summary: Microsoft Scripting Guy, Ed Wilson, talks about different ways to use Windows PowerShell to get the SQL Server error log. Hey, Scripting Guy! I have recently inherited a Microsoft SQL Server 2008 R2 box, and I am concerned about the thing. I am not a DBA, and to be honest the server sort of frightens me a bit. When I look into ...

Use PowerShell to Work with Analysis Service Database Backups

May 30, 2011 May 30, 2011 05/30/11
ScriptingGuy1
Summary: Learn how to use Windows PowerShell to work with Microsoft SQL Server Analysis Service database backups. Microsoft Scripting Guy, Ed Wilson, here. Our guest blogger today is Muthusamy Anantha Kumar, a.k.a. “The MAK.” Muthusamy Anantha Kumar is a Microsoft Certified IT Professional database administrator (MCITP: Database...

Learn How to Use Description Attributes in PowerShell Functions

May 28, 2011 May 28, 2011 05/28/11
ScriptingGuy1
Summary: Microsoft Scripting Guy, Ed Wilson, teaches you how to use description attributes to enable a quick retrieval of Windows PowerShell functions. Weekend Scripter Microsoft Scripting Guy, Ed Wilson, is here. Well, the 2011 Scripting Games are nearly completely over. “What?” you may ask. “Is there more to come?” ...

Use a Simple PowerShell Technique to Create Random Numbers

May 27, 2011 May 27, 2011 05/27/11
ScriptingGuy1
Summary: Microsoft Scripting Guy, Ed Wilson, teaches you how to use a simple Windows PowerShell cmdlet to create random numbers. Microsoft Scripting Guy, Ed Wilson, is here. One of the questions I received when I was speaking at the SQL Rally in Orlando, Florida was whether I prefer working in the Windows PowerShell console, or do I prefer to ...

Use PowerShell to Data Mine Your Outlook Inbox

May 26, 2011 May 26, 2011 05/26/11
ScriptingGuy1
Summary: Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell to data mine your Microsoft Outlook Inbox.   Hey, Scripting Guy! I was talking to my boss the other day, and he made a rather interesting observation. He said that if I send four or five emails to a person within a four- or five-minute period, I should ...