Author Archives: Boe Prox

About Boe Prox

Microsoft Cloud and Datacenter MVP working as a SQL DBA.

Dealing with Runspacepool Variable Scope Creep in PowerShell

Something that I had noticed a while back that I would receive some output values in my objects that shouldn’t have been there. Properties that should have been Null had values in them, and not just random values, but values … Continue reading

Posted in powershell | Tagged , , , | 6 Comments

2018 PowerShell Resolutions

This As I did last year, and the years before that, I wanted to review my last PowerShell resolutions and see how well I did and then take a look at the coming year and pick a few things that … Continue reading

Posted in powershell | Tagged , , | 3 Comments

Recent Articles on MCPMag

I’ve been busy working on some articles for MCPMag.com and wanted to share a couple of stubs to my most recent articles. Gathering Installed Software Using PowerShell If there is one thing an administrator finds themselves doing, it is probably … Continue reading

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

Quick Hits: Finding all Hyperlinks in an Excel Workbook

Recently, I had the need to pull out all of the hyperlinks from an excel worksheet that was given to me. While I could have gone the manual approach by looking through all of the cells in the worksheet and … Continue reading

Posted in powershell | Tagged , , | 2 Comments

PowerShell Server Inventory, Part 3: Viewing the Inventory using a UI

This post is part 3 in a 3 part series on building your own server inventory system using PowerShell. Staging the SQL database and tables (Part 1) Collecting server data and pushing to the SQL database (Part 2) Pulling the … Continue reading

Posted in powershell | Tagged , , , , , , | 2 Comments