Adding SQLSERVERAGENT permission on certificate private keys

The format to use is NT Service\SQLSERVERAGENT

Set the Location to the local machine rather than the domain.

Scheduled Wake on LAN (WoL) via crontab on Mango router

I wanted my pc to boot up each workday at 08:50, so decided to use my Mango router as it's already on the network and runs OpenWRT.

1. Install etherwake via: http://<mango-IP>/cgi-bin/luci/admin/system/opkg
   
   
2. Use: https://crontab.guru/#50_8_*_*_1-5 to find the crontab timing.
   
   
3. SSH to the Mango router and run the following command to find the name of your LAN interface that can see the target PC.
   IP a
   
   
4. In http://<mango-IP>/cgi-bin/luci/admin/system/crontab add the following line.
   50 8 * * 1-5 etherwake -b -i br-lan <MAC address of target PC>
   
   
   
   
   
   

Cannot resize Azure VM due to Accelerated Networking being enabled

 You decide to drop the size of a D series Azure VM to B series and are told it's incompatible with Accelerated Networking, perhaps you don't care.

Here's how to disable Accelerated Networking, no reboot required!

In Azure Portal, find the relevant info for your VMs 'network interface name' and 'resource group name', use those in place of the <placeholders> and run the command in Azure CLI from the icon in the top-right of the portal. 

Your VM will continue to run and will not drop the network connection. Once the command has completed you can resize your VM.

az network nic update --accelerated-networking false --name <network interface name> --resource-group <resource group name>

Outlook Room Finder does not load data/work

The error message: We can't open the Room Finder right now. Please try again later.

For Room Finder to load data in Outlook 'Edge Webview2' is required to be installed, this appears not to happen on RDS Session hosts.

Webview2 can be installed on a user-by-user basis or for all users if installed by a local admin. The Evergreen edition is recommended in most cases.