Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! How Does Windows PowerShell Make It Easier to Work with SQL Server 2008?

Hey, Scripting Guy! I am a SQL database administrator, and in the past I have enjoyed using VBScript for many tasks related to my computers that are running SQL Server. What capabilities does Windows PowerShell provide to make working with SQL Server 2008 easier?- OS Hi OS, Ed is neck deep in work for the 2009 Summer Scripting Games. He is ...

Hey, Scripting Guy! Why Should I Use Windows PowerShell with SQL Server 2008?

Hey, Scripting Guy! I recently saw that SQL Server 2008 has Windows PowerShell built into it. I looked at, but I am not really impressed. Why should I be interested in using Windows PowerShell with SQL Server 2008?- JJ Hi JJ, For some unknown reason, it has turned cool down here in Charlotte, North Carolina, in the United States. Not that ...

How Can I Prompt a User for Input?

Hey, Scripting Guy! I need my script to prompt users to enter some information, like the name of the file they want to create. How do I do that?-- RW, Williamsport, PA Hey, BN. The simplest - and most foolproof - way to do this is to use an InputBox; when you do that users will be presented with a graphical dialog box similar to this: ...

How Can I Determine the Day of the Week?

Hey, Scripting Guy! I have a script that does certain management tasks based on the day of the week. I know how get the date in a script, but how can I tell whether it’s a Monday or a Tuesday or whatever? -- CT, Tallahassee, FL Hey, CT. This is actually much easier then it might sound; that’s because VBScript ...