Scripting Blog [archived]

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

Use PowerShell to Administer SQL Server 2008

  Summary: Microsoft MVP Sean McCown shows how to use Windows PowerShell to administer remote SQL Servers using easy commands.   (image) Hey, Scripting Guy! I am an extremely busy database administrator (DBA), and at a recent SQL Saturday event, I heard several people talking about Windows PowerShell. I did not, however, attend any ...

Hey, Scripting Guy! Weekend Scripter: Using the Windows Search Index to Find Specific Files

(image)   Microsoft Scripting Guy Ed Wilson here. One of the cool things about using Windows PowerShell is the different objects with which you can interact. Windows Search is an example of this. By using ADO, you can query the Windows Search index and retrieve information about files. This technique can have some very interesting ...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Run Daily Checks on My SQL Server 2008 Servers?

(image) Hey, Scripting Guy! I have several items I have to check daily on my SQL 2008 servers. I currently have some VBScripts that do many of my tasks, but there are some new things I want to do. I figure that Windows PowerShell would be easier. Do you have any pointers?- SC(image) (image) Hi SC, It is becoming late as Ed continues ...

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

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