Category Archives: powershell

Restore a SQL Database Using SQL Server Management Objects (SMO) and PowerShell

Posted on November 2, 2013 by Boe Prox

At some point in your career with SQL, there may come a time to perform a restore of the database (and maybe transaction logs depending on your situation). Given that we covered how to back up a SQL database, we … Continue reading →

Posted in powershell, SQL | Tagged , , , , | 1 Comment

PowerShell 4.0 Now Available for Download

Posted on October 25, 2013 by Boe Prox

That’s right, Windows Management Framework 4.0 is now available to download for down-level OS’s. Some important things to know regarding this: New Features and Updated Versions Windows PowerShell Windows PowerShell Integrated Scripting Environment (ISE) Windows PowerShell Web Services (Management OData … Continue reading →

Posted in News, powershell | Tagged , | Leave a comment

Using the ESPN API with PowerShell

Posted on October 21, 2013 by Boe Prox

Being a sports fan, I wanted to see what the ESPN API (just started in March 2012) had to offer (not much unfortunately unless you are a premium member) and make use of what PowerShell has to offer to pull … Continue reading →

Posted in powershell | Tagged , , | 1 Comment

Guest Post on Hey, Scripting Guy! Talking PInvoke and PowerShell

Posted on October 19, 2013 by Boe Prox

Today my Hey, Scripting Guy! guest blog goes live. I am talking about using Pinvoke with PowerShell to handle the removal of files which may be locked by a process. Check it out and let me know what you think! … Continue reading →

Posted in News, powershell | Tagged , , , | Leave a comment

Fix Duplicate WSUS ClientIDs Using PowerShell

Posted on October 16, 2013 by Boe Prox

A common issue when using a ‘template’ or an OS image that hasn’t been sysprepped is that each client that has the same clientID will appear and disappear from the WSUS console (only 1 client will appear at a time). … Continue reading →

Posted in powershell, scripts, WSUS | Tagged , , , , | 6 Comments