Category Archives: powershell

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

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