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

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

Creating a new SSH key for GitHub

 Generating a new SSH key and adding it to the ssh-agent - GitHub Docs

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

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

Setting a background colour to transparent in GIMP

 Sometimes you have an image with antialising against a background colour, such as white.

If you paste it over a coloured box you get this:

To make the background colour transparent, use Gimp's Color to Alpha (Layer > Transparency > Color to Alpha).

It will remove the background.

Allowing you to paste it in the box:

Git Pull Request (PR) workflow

 Pull Request Workflow with Git — 6 steps guide | by Hybesis - H.urna | Medium

Find the remote

git remote -v

git push origin <branch>

Create a pull request