Daily Shaarli

All links of one day in a single page.

April 8, 2021

Execute PowerShell Script from SSIS Package
How Do I Learn PowerShell? - Spiceworks
Create a Polling Loop in PowerShell | SQLvariations: SQL Server, a little PowerShell, maybe some Power BI

This is one way to create a polling loop in PowerShell. I’m sure there are several options, but this one works well for the use case.

PowerShell Commands for SSRS

The Out-GridView cmdlet allows you to present the results from PowerShell in a sortable and filterable grid, sort of like the 'Out to Grid' results you're used to in SQL Server Management Studio (SSMS), but better! When you add the -PassThru parameter, it allows you to multi-select rows in the grid, and when you click the 'OK' button it will send only the rows you selected down the pipeline to the next command in the sequence to be processed.

Screw it, I'll host it myself • Marko Živanović

Luckily, after that phase, things run (mostly) without any interruption. I have a monthly reminder to check for the updates and apply them to the software I’m running. I don’t bother with minor updates, so if it’s not broken, I’m not fixing it.

A simple shell script for deployment | Bas Barten