SHIFT-WIKI - Sjoerd Hooft's InFormation Technology
This WIKI is my personal documentation blog. Please enjoy it and feel free to reach out through blue sky if you have a question, remark, improvement or observation. See below for the latest additions, or use the search or tags to browse for content.
PowerBI
Summary: How to get started with PowerBi (Power Automate).
Date: Around 2020
Refactor: 1 March 2025: Checked links and formatting.
All you need to get started with PowerBI, as an user and as an administrator.
Using SharePoint PowerApps and Flow for your Daily Checks Reports
Summary: How to use PowerApps and Microsoft Flow (Power Automate) for your daily checks.
Date: Around 2020
Refactor: 1 March 2025: Checked links and formatting.
Here I take you through the hypothetical training of creating a Daily check list in sharepoint and then making it beautiful using PowerApps and have them approved by your manager. This is a must have in most regulated companies.
Create A SSL Port Tunnel
Summary: Create a SSL Port tunnel with Putty
Date: Around 2011
Refactor: 4 January 2025: Checked links and formatting.
- Target: Access a SFTP Server which is only accessible by a production box.
- Production Box: AIX with SSH/SSL capabilities, login is possible.
- SFTP Server: Login credentials are available.
- Used Tools: Putty for the tunnel, WinSCP to connect
Setup a Point To Site VPN to Azure
Summary: How to Setup a Point To Site VPN to Azure.
Date: Around 2018
Refactor: 22 March 2025: Checked links and formatting.
Setting up a Point2Site VPN is something you normally would consider for people on the road or if you do not have many users. This setup will just connect my computer to my Azure tenant and is a follow-up on these previous articles: Getting Started With Azure and Active Directory Domain Controller in Azure. So far I haven't done anything else in the environment so everything will still be done from scratch. To connect my computer through a VPN to the Azure tenant we'll need a couple of things and steps to go through:
- We'll need Certificate Services because we need a root certificate as well as a client certificate
- We need to enable the tenant to allow Point To Site VPNs by configuring a subnet and gateway
- Then we need to install the VPN client software