Tag Archives: database

Restore a SQL Database Using SQL Server Management Objects (SMO) and PowerShell

Posted on November 2, 2013 by Boe Prox

At some point in your career with SQL, there may come a time to perform a restore of the database (and maybe transaction logs depending on your situation). Given that we covered how to back up a SQL database, we … Continue reading →

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

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

Using the WSUS API and PowerShell to Perform Maintenance on the SUSDB Database

Posted on July 7, 2013 by Boe Prox

In my previous article, I showed how you can utilize the Windows Server Update Services (WSUS) API to connect to the SUSDB database that is being used by the WSUS server to perform T-SQL queries against the database for information. … Continue reading →

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

Use the WSUS API and PowerShell to query the SUSDB Database

Posted on July 7, 2013 by Boe Prox

While we know that the WSUS API can be used to perform a multitude of WSUS tasks from approving patches, removing clients to creating automatic approval rules. Diving deeper into the API reveals that we can also find out the … Continue reading →

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