Tag Archives: database

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

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

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

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 , , , | 4 Comments

Use the WSUS API and PowerShell to query the SUSDB Database

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