Tag Archives: SQL

Speaking at Nebraska Code Conference in March

Posted on January 23, 2015 by Boe Prox

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

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

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

Posted on October 9, 2013 by Boe Prox

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

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