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 Reporting, Part 2: Send and Receive SQL Server Data
PowerShell Trend Reporting, Part 3: Excel and Word Reports

About Boe Prox

Microsoft Cloud and Datacenter MVP working as a SQL DBA.
This entry was posted in powershell and tagged , , , , . Bookmark the permalink.

4 Responses to Trend Reporting using PowerShell and SQL on MCPMag.com

  1. Roelof says:

    Is there a special reason you calculate the usedspaceGB from size and freespace, instead of just converting the usedspace value from the table to GB?

    • Boe Prox says:

      That would be a fail on my part. 🙂 The better approach would be to take the UsedSpace from the table and convert it to GB rather than wasting cycles on calculating for UsedSpace like I did. Must have been napping while writing out that code block.

  2. FoxDeploy says:

    Aww, that ended right now before the good stuff!

    Always keep them wanting more, eh?

    Good one, Boe!

    • Boe Prox says:

      😉 Thanks! I was back and forth between how I was going to split this up into 3 parts and figured it would make the most sense to do the data gathering as one part and then cover the SQL part as the next section.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s