Wednesday, 23 November 2022

Running multiple identities on GitHub on Windows

 

You can run multiple identities on GitHub, by putting a copy of the two files

id_ed25519 and id_ed25519.pub 

in the 

C:\Users\<username>\.ssh 

directory.

It is worth creating two subfolders

C:\Users\<username>\.ssh\user1 and

C:\Users\<username>\.ssh\user2

to keep the original copies of the keys and copy them into the parent folder as required.

If you try and clone a GitHub repo under the wrong user, than isn't permissioned, then you will get the error:

Cloning into 'myrepo'...

remote: Repository not found.

fatal: repository 'https://github.com/myteam/myrepo.git/' not found



Friday, 14 October 2022

ZoomIt shortcuts

Ctrl+1 Zoom

Ctrl+5 Record

e delete all


pens

r red

b blue

g green

o orange

y yellow

p pink


shift line

ctrl rectangle

elipse tab

shift+ctrl arrow

w white

b black


ctrl+c copy

ctrl+s save




Friday, 30 September 2022

Docker & Kubernetes cheat sheet

Attach to a running container

docker exec -i -t <container> /bin/bash

Test network connectivity

apt update
apt install net-tools
apt install curl
curl -kv

Read logs on failed startup


Networking tools

docker run --rm -it praqma/network-multitool bash

Wednesday, 28 September 2022

3D Printer tips for the Longer LK4

Tree supports are the best kind of support. Select "Touching Buildplate" to avoid having them join the print.

Support structure: Tree

Support placement: Touching Buildplate


Thursday, 1 September 2022

READPAST SQL hint

 We had a batch process that retrieved 1,000s of rows from SQL Server, processed them and updated them.

Multiple readers were operating in parallel. We found that throughput hit some limitations because of the number of locked rows.


READPAST is a good SQL hint that will ignore locked rows when returning a resultset. If the rows are locked, they are excluded.

This allows a processor to read unlocked rows and process them. Once the locked rows are released they can be processed if applicable.

Using NOLOCK and READPAST table hints in SQL Server | TechRepublic

Friday, 26 August 2022

SSH to Freenas

If you SSH to freenas, it errors:

Unable to negotiate with <ipaddress> port 22: no matching host key type found. Their offer: ssh-dss

Solution:

 ssh -oHostKeyAlgorithms=+ssh-dss freenas