Scripting Blog [archived]

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

Use PowerShell to Retrieve a Weather Forecast

  Summary: Microsoft Scripting Guy Ed Wilson shows how to use Windows PowerShell to get a weather forecast from inside the Windows PowerShell ISE.   Microsoft Scripting Guy Ed Wilson here. It is amazing how quickly things change on the Internet. A couple of years ago I found a website that hosted several web services. It was really ...

Weekend Scripter: Clean Up Your PowerShell ISE Profile by Using a Module

  Summary: Microsoft Scripting Guy Ed Wilson shows how to clean up your Windows PowerShell ISE profile by creating a module.   Microsoft Scripting Guy Ed Wilson here, it is getting cold here in the Deep South. It is nearly 50 degrees Fahrenheit (10 degrees Celsius). The smell of hot chocolate permeates the early morning atmosphere in...

Using PowerShell to Add a Group of Users to a SQL Database

  Summary: Learn how to use Windows PowerShell to add a group of users to a SQL Server database.   Today is the final day of SQL guest blogger week. It was great to enter the SQL side of life. Sean McCown is our guest blogger for today. Sean McCown holds a double MCITP in SQL Server 2008 for both Administration and Development. He is...

Use PowerShell to Script SQL Database Objects

  Summary: Learn how to use Windows PowerShell to automate creation of SQL Database objects such as tables, stored procedures, and functions.   (image) Hey, Scripting Guy! How can I use Windows PowerShell to script out SQL Server database objects? -- AA   (image) Hello AA, Microsoft Scripting Guy Ed Wilson here. Today we have ...

Use PowerShell to Change SQL Server Service Accounts

  Summary: Learn how to use Windows PowerShell to change SQL Server service accounts.   (image) Hey, Scripting Guy! How can I use PowerShell to change SQL Server service accounts? -- NM   (image) Hello NM, Microsoft Scripting Guy Ed Wilson here. This week I am hosting guest bloggers from the SQL side of life. This is in honor of...