Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

May 2011 - Scripting Blog [archived]

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. (image) 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 ...

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