Tag Archives: SQL

PowerShell Server Inventory, Part 2: Collecting and Sending Data

This will be at least a 3 part series in which I will go over each aspect of my build which will cover the following topics: Staging the SQL database and tables (Part 1) Collecting server data and pushing to … Continue reading

Posted in powershell | Tagged , , , , | 6 Comments

PowerShell Server Inventory, Part 1: SQL Database Build

If you’re like me, you might not have SCOM or SCCM or some other 3rd party solution that you can leverage to track all of your systems in your environment that you can pull up at a glance to know … Continue reading

Posted in powershell | Tagged , , , | 4 Comments

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