Scripting Blog [archived]

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

guest blogger - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Use the SQL Server Mini-Shell Version of Windows PowerShell?

May 28, 2009 May 28, 2009 05/28/09
ScriptingGuy1
(image) Hey, Scripting Guy! One thing I do not understand is why the SQL Server team wrote its own version of Windows PowerShell. I thought Windows PowerShell was supposed to standardize things. But the SQL Server team has one version of Windows PowerShell, the Exchange team has another, and then of course there is the Windows PowerShell ...

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

May 27, 2009 May 27, 2009 05/27/09
ScriptingGuy1
(image) 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(image) (image) Hi OS, Ed is neck deep in work for the 2009 Summer...

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

May 26, 2009 May 26, 2009 05/26/09
ScriptingGuy1
(image) 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 (image) (image) Hi JJ, For some unknown reason, it has turned cool down here in Charlotte, North Carolina, in the ...

How Can I Prompt a User for Input?

August 31, 2004 Aug 31, 2004 08/31/04
Doctor Scripto
(image) 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(image) (image) (image) 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...

How Can I Determine the Day of the Week?

August 27, 2004 Aug 27, 2004 08/27/04
Doctor Scripto
(image) 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 (image) (image) (image) Hey, CT. This is actually much easier then it might ...