greenkey's technical stuff

[ambienne]

Dear internet,

Please give me all the advice you have on writing cover letters. Like, the closer you can get to literally just writing a cover letter for me, the better. Ok bye.

[emilysidhe]

This is how I did the one for my librarian position.  I hope it helps.

Dear Person Hiring for this Job,

I am writing to ask you to consider me for X position.  This is a paragraph about why I want to do X position in general.  It includes at least one personal detail and at least one job skill I consider a particular strength.  It argues that I am passionate about this career.  It is not long.

I have had the opportunity to gain experience in this job by - paragraph about my work or study experience.  It should go from most recent experience back.  Include some details about your responsibilities/achievements in your most recent or most important positions.  If you have mostly study experience, give more detail about what exactly you studied.  If you shadowed people, mention that.  If your work experience is largely unrelated, try to shoehorn some of it in (e.g. I gained experience working with people by).  You can supplement with relevant hobbies.  (But if you do have recent, relevant work experience, you should largely be detailing that.  Only embroider the other stuff if you need to flesh it out.)  This should be the longest paragraph.

I hope you will consider allowing me to do X thing at your company.  This is a few sentences about why I want to work at your company in particular and what I think I could bring.  Try to mention at least one detail from the company website, so they know you visited it.  This is a short paragraph that parallels the first one.

Thank you very much for your time and attention.

Sincerely,

Person You Would Be a Fool Not to At Least Interview

[walkingoutintherain]

oh my god thank you this is relevant to current interests

[magpieandwhale]

Two other points, to challenge what’s being said above a little:

1) Remember that the person reading this cover letter wants to know how you can contribute to the company. Not how excited you are about the position: it’s all about what they gain. Try framing the whole thing in that sense — “You would gain my X awesome skill that would help you Y with your mission.” “Here’s why I’m awesome and a great fit for making your company go better.”

2) At the end, ask for the interview. “I am available at PHONE NUMBER at your convenience. I look forward to speaking with you about this great opportunity soon.” Maybe even say you’ll be following up at a specific time and date. Ask for the job. People respond to that, and it’s a good way to fake confidence until you make it. Ask for the job.

Okay, three points. People reading cover letters get SO BORED going through them. Think about starting off with a story that relates to why you’re interested in the job, or that demonstrates a skill or a strong interest that would make you a good candidate. Be memorable — people remember stories, even (maybe especially) very little ones.

[walkingoutintherain]

*hoards advice*

[greenkey-tech]

After all, what is a freeway at 100% utilization? At 100% utilization a freeway looks like a parking lot. And that’s the same with an employee. When you take an employee and try to utilize her for 100% of the day, she’ll just stop. Somewhere around 50% is ideal. If you’ve got developers who are producing real value 50% of the time, that’s pretty amazing. People aren’t machines, after all. We need time for ongoing learning, we’ve got to stretch, we’ve got to eat, we’ve got to use the restroom. We’re human.

David Scott Berenstein - Beyond Legacy Code

[greenkey-tech]

[necclibrary]

Thinking critically about information - Just Do It!

From the Global Digital Citizen Foundation.

[batmansymbol]

OKAY TUMBLR. IT'S TIME TO SETTLE THIS ONCE AND FOR ALL.

Reblog this if you pronounce “.gif” as “GIF.”

NOT JIF,

GIF.

And here is the link for the opposite.

WE SHALL SEE WHICH ONE PREVAILS.

my dad had a skype interview today so he was sitting in the living room looking all professional in his suit and tie and everything while he’s talking to the people who are interviewing him. and OF COURSE my cat decided that she NEEDED to speak at that moment so she just starts meowing left and right and talking crazy talk to the point where the interviewers just start laughing because she just will NOT shut up. so my dad just kind of sighs, looks at the camera, and goes, “i’m so sorry. i have to ask my cat to leave.” and then he looks over at victoria and very calmly and professionally goes, “victoria, i’m afraid you’re being too loud, and i’m going to have to ask you to leave.”

and she did. she fucking turned and walked out of the living room.

[krawdad]

“…you’re hired.”

[classicprogrammerpaintings]

“EULA”

Michael Pancher

Ca. 1483

Collaboration from J-No ([email protected]) 

[greenkey-tech]

posted: Jun 14, 2016 gist: 4995de0bd65661dbd46a5140a3a3ce4c tablespace_shrink.sql /* It is not possible to shrink a tablespace that's being used, in order to reclaim the unused space you can use this script (remember to change the value of OLD_TBSP variable) The script essentially does the following: - create a new tablespace appending "_TMP" at the end, it's going to use a datafile with the same name, adding (or incrementing) an id; - move all the object from the old tablespace to the new one; (this means that on the filesystem there should be enough space for the new datafile, consider also the extra space for the index rebuild!) - prints the commands to execute in order to drop the old tablespace and rename the new. At the end it is possible that the space on the filesystem is not freed, follow the instructions here: http://ift.tt/1ZOhvk5 */ DECLARE EXEC_IMM VARCHAR(255) := ''; OLD_TBSP VARCHAR(80) := 'TABLE_SPACE_TO_BE_SHRINKED'; NEW_TBSP VARCHAR(80); TBSP_FILE VARCHAR(250); TBSP_FILE_ID NUMBER; BEGIN NEW_TBSP := OLD_TBSP || '_TMP'; SELECT FILE_NAME, nvl(regexp_replace(TBSP_FILE, '^(.*[^0-9])(_([0-9]+))*(\.[a-z]+)$', '\3'), 0) + 1 INTO TBSP_FILE, TBSP_FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = OLD_TBSP; SELECT regexp_replace(TBSP_FILE, '^(.*[^0-9])(_([0-9]+))*(\.[a-z]+)$', '\1_' || TBSP_FILE_ID || '\4') INTO TBSP_FILE FROM DUAL; BEGIN EXECUTE IMMEDIATE 'CREATE TABLESPACE ' || NEW_TBSP || ' DATAFILE ''' || TBSP_FILE || ''' SIZE 100M AUTOEXTEND ON NEXT 100M'; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line(' WARNING: tablespace might already exist '); END; FOR SEG IN (SELECT DISTINCT nvl(I.TABLE_OWNER, S.OWNER) AS OWNER, S.SEGMENT_NAME, S.SEGMENT_TYPE, S.PARTITION_NAME, nvl(L.TABLE_NAME, I.TABLE_NAME) AS TABLE_NAME, nvl(L.COLUMN_NAME, C.COLUMN_NAME) AS COLUMN_NAME, P.PARTITION_NAME AS REAL_PARTITION_NAME FROM DBA_SEGMENTS S LEFT OUTER JOIN DBA_LOBS L ON L.OWNER = S.OWNER AND L.SEGMENT_NAME = S.SEGMENT_NAME LEFT OUTER JOIN DBA_LOB_PARTITIONS P ON P.TABLE_OWNER = L.OWNER AND P.TABLE_NAME = L.TABLE_NAME AND P.COLUMN_NAME = L.COLUMN_NAME AND S.PARTITION_NAME = P.LOB_PARTITION_NAME LEFT OUTER JOIN DBA_INDEXES I ON I.OWNER = S.OWNER AND I.INDEX_NAME = S.SEGMENT_NAME LEFT OUTER JOIN DBA_LOBS C ON C.INDEX_NAME = I.INDEX_NAME WHERE S.TABLESPACE_NAME = OLD_TBSP AND S.SEGMENT_NAME NOT LIKE 'BIN$%' AND S.SEGMENT_TYPE NOT IN ('LOBINDEX', 'INDEX PARTITION') ORDER BY S.SEGMENT_TYPE DESC) LOOP DBMS_OUTPUT.put_line(SEG.SEGMENT_TYPE || ' ' || SEG.SEGMENT_NAME); IF SEG.SEGMENT_TYPE .....

[oneofthosecrazycatladies]

[devopsreactions]

Our Development Process

by @_Ashtonian

[greenkey-tech]

posted: Mar 01, 2016 gist: 5261cc6ccc4699e95841 fraction_exercise_generator.py #!/usr/bin/python3 from random import randrange, random from fractions import Fraction from functools import reduce def pf(f): '''Pretty print the fraction''' return "{}/{}".format(f.numerator,f.denominator) while True: fractions = [Fraction( randrange(1,30), randrange(1,30) ) for i in range(randrange(2,6))] final = reduce(lambda x, y: x * y, fractions) if final.denominator

[greenkey-tech]

posted: Feb 29, 2016 gist: d0a3c7035205bd0367de JDBC_guide_SoapUI.md # How to easily use JDBC in a SoapUI Test Case ### Choose the DB and get the JDBC driver First we need to know to which DBMS we want to connect. You can find all the supported driver in the [JDBC Driver List](http://ift.tt/1oJBu6K) page of the SoapUI website. Take note of the Driver name, i.e. `oracle.jdbc.driver.OracleDriver` and download the `.jar` file. Put the jar file in the `ext` directory, it should be in ithe same folder as the SoapUI start script. In Linux, you can find it in this way: ```shell $~ which SoapUI-5.2.1 /usr/local/bin/SoapUI-5.2.1 $~ ls -l /usr/local/bin/SoapUI-5.2.1 lrwxrwxrwx 1 root root 44 feb 9 15:40 /usr/local/bin/SoapUI-5.2.1 -> /opt/SmartBear/SoapUI-5.2.1/bin/SoapUI-5.2.1 $~ cd /opt/SmartBear/SoapUI-5.2.1/bin $bin ls -l ... drwxr-xr-x 2 root root 4096 feb 29 17:50 ext ... ``` ### Use the connection in a `JDBC Request` Test Step 1. Create a JDBC Request Test Step in a Test Case; 1. set the driver name in the `Driver` field, i.e. `oracle.jdbc.driver.OracleDriver`; 1. set the Connection String, i.e. `jdbc:oracle:thin:user/password@//host.or.ip.address:1521/SID`; 1. click on the `TestConnection` button to test the connection. Now you can use the SQL Query to get values or verify them. Enjoy

[greenkey-tech]

posted: Feb 25, 2016 gist: b90c4d58794dae15f3f3 sql_parametric.vbs ' inspired by: ' http://ift.tt/1Q3Hxwg ' http://ift.tt/1oJBGDC ' The function takes three parameters: ADOConnection; sql (string); params, an Array() of parameters Function sqlOperationParametric(ADOConnection,sql,params) Dim Cm, Pm, i, p Set Cm = CreateObject("ADODB.Command") With Cm .ActiveConnection = ADOConnection .CommandText = sql .CommandType = adCmdText For i=0 To UBound(params) p = params(i) Set Pm = .CreateParameter() With Pm .Direction = adParamInput Select Case VarType(p) Case vbString .Type = adVarChar .Size = Len(p) .Value = p Case vbInteger, vbLong, vbSingle, vbDouble .Type = adDouble Pm.Value = p Case vbDate .Type = adDBTimeStamp .Value = p ' sure there should be other cases, but these are the most used End Select End With .Parameters.Append Pm Next Set sqlOperationParametric = .Execute End With End Function

[greenkey-tech]

posted: Dec 22, 2015 gist: df650cebd75cc0d6ecae proxied_chrome.sh #!/bin/bash PROXY_IP=192.168.1.100 PROXY_PORT=4444 ssh -N -D $PROXY_PORT $PROXY_IP & ID=$! chromium-browser --proxy-server="http://socks127.0.0.1:$PROXY_PORT" kill $ID

[greenkey-tech]

sqlldr - some notes

Ok, so, yesterday I had to run an import into Oracle tables with sqlldr, this is what I learned.

Try to use a tab as field separator

The pipe | is fairly good, but there are some fields that can contain that character. The tab character (\t) is much less frequent.

Double quotes text delimiter

If you are nearly sure that the fields does not contain the field separator character, avoid the double quotes. There may be some problems if there are double quotes in the fields, and there always are.

Check for file encoding

The data extracted can contain special characters. To avoid issues follow this checklist:

execute this on Oracle: SELECT * FROM NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET';

check the character set of the file with this linux command: file -bi [filename]

correct the character set if needed: iconv -f ascii -t utf8 [filename] > [newfilename] Or recode UTF-8 [filename]

Check and change your NLS_LANG settings in Linux: echo $NLS_LANG NLS_LANG=[selected_encoding] export NLS_LANG=[selected_encoding]

sources:

http://support.etouch.net/cm/wiki/?id=43321

http://mindspill.net/computing/linux-notes/determine-and-change-file-character-encoding/

https://community.oracle.com/thread/650821

[bestfunnystuffs]

[greenkey-tech]

When a leader want it his way or nothing and the other's way is "wrong"... then the team become dumb and doesn't think anymore

me