Jess Pomfret shows us how we can aggregate data using Powershell:
As a SQL Server DBA, aggregating data is first nature. I can easily throw together some T-SQL if I need to get the average sales per product group, or perhaps the number of employees hired per month. Yesterday I was writing a little PowerShell when I came across a problem. I needed to get the size of my database data and log files for several databases on a server, when I realized I didn’t know how to group and sum this data in PowerShell.
Click through to learn how.