Monthly Archives: September 2013

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

Posted on September 27, 2013 by Boe Prox

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

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