Scripting Blog

A place to learn about PowerShell and share stories of automation

Use PowerShell to Get the SQL Server Error Log

 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

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

Use PowerShell Splatting to Simplify Parameter Sets

Summary: Microsoft Scripting Guy, Ed Wilson, illustrates step-by-step how to use Windows PowerShell splatting to simplify working with parameters. Weekend Scripter Microsoft Scripting Guy, Ed Wilson, is here. It is a perfectly lovely weekend, and things are finally beginning to settle back down after two weeks of travel. The SQL Rally in ...

Learn How to Use Description Attributes in PowerShell Functions

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

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