Tag Archives: Powershell

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

Posted on September 21, 2013 by Boe Prox

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

Posted on September 17, 2013 by Boe Prox

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

Posted on September 16, 2013 by Boe Prox

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

Find All SQL Instances Using PowerShell Plus A Little More

Posted on September 15, 2013 by Boe Prox

A while back I saw this the following post on the PowerShell Magazine that showed how to get all of the instances of a SQL server. This was pretty cool, but only listed the instances and nothing else (well it … Continue reading →

Posted in powershell, scripts | Tagged , , , | 19 Comments

Presentation Materials from the September 2013 Mississippi PowerShell User Group Meeting on ‘WSUS and PowerShell’

Posted on September 11, 2013 by Boe Prox

For those of you who were unable to attend my talk or for those who want check out my scripts on WSUS and PowerShell that I gave at the Mississippi PowerShell User Group last night, I have my slide deck … Continue reading →

Posted in powershell, WSUS | Tagged , , , , | 3 Comments