Author Archives: Boe Prox

I’m a PowerShell MVP!

I received an amazing email this morning from Microsoft MVP Community stating the following: I am very humbled and honored to receive this honor and joining some amazing people in this community! To everyone that nominated me and those that … Continue reading

Posted in News, powershell | Tagged , | 17 Comments

Exploring SQL Databases Using SQL Server Management Objects (SMO) and PowerShell

Continuing with my little SQL and PowerShell series, I am going to talk about how you can use PowerShell to explore SQL databases using SMO. As shown in the previous articles, I will make my initial connection to a SQL … Continue reading

Posted in powershell, SQL | Tagged , , , | 5 Comments

Exploring SQL Server Using SQL Server Management Objects (SMO) and PowerShell

Continuing on from my previous article where I showed you how to make an initial connection to a SQL server using SMO, this article aims to dive deeper into the Microsoft.SqlServer.Management.Smo.Server object to view the configuration and available methods of … Continue reading

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

Video From Mississippi PowerShell User Group Presentation on WSUS and PowerShell Available

The video recording from my presentation on WSUS Administration with PowerShell has been posted and is now available to be viewed. The presentation materials from this are available at the link below. WSUS Administration Using PowerShell   PowerShell and WSUS … Continue reading

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

Connecting to a SQL Server Using SQL Server Management Objects (SMO) and PowerShell

In a previous article, I showed you how to find all of the SQL servers and instances using a function that queries the registry. Moving on from this, I will now show how you can connect to a SQL server … Continue reading

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