Trending and Reporting
summary
PowerShell scripts output typed objects that get stored directly into a database using a small module that exposes save-reportdata/getreportdata and auto-creates tables named from the object type like report.diskcapacity. It uses SQL Server Express and SSRS for scheduled, graphical reports instead of automating Excel. Example: a disk-capacity collector emits timestamps and sizes, the module creates columns with appropriate types and inserts rows, and reports run automatically — it works and scales with proper SQL sizing.
AI-written summary · about
chapters (5)
- 0:00Start
- 5:07Use Powershell To Stick Data into Sequel Server
- 17:01Get Report Data
- 19:08Save Report Data
- 40:08Ssrs
related talks
39mPowerShell with SQL Statement Data Gathering
44mPowerShell, Graphs, Topology and Real Use Cases
44mContinuously deploying SQL code using Powershell
44mMy romantic relation with Powershell generally and DBATools especially
36mInventory Your Server Environment and Detect Change at Scale
46mFrom Script to Tool: Building Robust, Meaningful Tools with PowerShell
39mGet a Load of this - Realistic Load Testing for Power BI, explained!
51mPowerShell Techniques and Performance Tweaks - Full Throttle