Tag Archives: SQL

Updated Function: Get-SQLInstance

One function of mine that I use quite a bit to get information about SQL servers is Get-SQLInstance not only because it provides most of the information that I am looking for but it also is a great way to … Continue reading

Posted in powershell | Tagged , , , | 2 Comments

Slides and Example Code From Nebraska.Code() Conference Session Available

I had the great opportunity to speak at Nebraska.Code() over the weekend in which I talked about Trend Reporting using PowerShell and SQL. This was a great opportunity and my 1st conference speaking gig that I have done. I appreciate … Continue reading

Posted in powershell | Tagged , , , | 1 Comment

Trend Reporting using PowerShell and SQL on MCPMag.com

I have a new series of articles that will be focusing on trend reporting using PowerShell and SQL. Be sure to check them out and let me know what you think! PowerShell Trend Reporting, Part 1: Data Gathering PowerShell Trend … Continue reading

Posted in powershell | Tagged , , , , | 4 Comments

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