Tag Archives: SQL

Speaking at Nebraska Code Conference in March

I’ll be speaking at  the Nebraska Code Conference in March and I’ll be talking Trend Reporting Using PowerShell and SQL. This will be my first in person speaking gig at a conference so I am both excited and a little … Continue reading

Posted in News, powershell | Tagged , , , , , | Leave a comment

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

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

In my next article on my SQL and PowerShell series, I will talk about using the SQL Server Management Objects (SMO) to back up a SQL database. If you recall in my previous article on SQL Databases, you saw how … 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

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

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 , , | Leave a comment