Strongswan: Dynamic (BGP) IPsec VPN tunnel with strongSwan

This guide, coming from Google, explains how to use a dynamic IPsec VPN tunnel with strongSwan on Linux Step 1: Configure BIRD   # Config example for bird 1.6 #debug protocols all;router id 169.254.2.2;# Watch interface up/down eventsprotocol device {       scan time 10;}# Import interface routes (Connected)#…

Read More

T-SQL: Check status of automatic seeding

T-SQL-Commands

Automatic seeding for SQL Always On it nice, but in case of big databases this can take some time. Of course, it can be annoying if something is running, and you don’t see the status of it. The query below will show you the status of the automatic seeding, and…

Read More

T-SQL: Only run SQL agent job on primary node

T-SQL-Commands

In a SQL Always On setup, the SQL agent jobs are not synced between the different nodes. This means you need to manually create them on the other nodes. For read-write jobs, you can only run them on the active node of course. You should modify the SQL agent job…

Read More

Linux – commvault: create systemd file

If you have upgraded your old Commvault agent,or you still use an old Commvault agent on your linux ‘systemd’ system, there won’t be any start/stop script for the agent. You can use the workaround below for creating a systemd file for it.

Read More

Mysql: optimize all tables in all databases

In order to optimize all databases & tables within your mysql instance, you can use the code below. You can also use a more specific script, where only the tables are optimized which have 10MB free space and 10% free space.

Read More