Passing Environment Variables into Java from Command Line

java -DvarName1=varValue1 -DvarName2=varValue2

Pentaho Data Integration PostgreSQL Bulk Loader Gotcha

The password you key in the connection won't work. It only works when authentication is disabled for the server Pentaho is running on.

Reference: http://wiki.pentaho.com/display/EAI/PostgreSQL+Bulk+Loader#PostgreSQLBulkLoader-Setupauthentication

Cheat Sheet on 16 Analytics Techniques

Here it is: http://www.forbes.com/sites/bernardmarr/2016/02/04/the-18-best-analytics-tools-every-business-manager-should-know/#ebb1f7d2c4ad

MongoDB "update" Only Updates One Entry by Default

The "update" command only updates the first matching entry by default. To update all entries, there is a third parameter i.e. "options" where you need to set "multi: true" e.g.

db.coll.update({},{$set:{"attr":”value”]}},{multi:true})

Reference: https://docs.mongodb.org/v2.4/reference/method/db.collection.update/

AWS IAM: EC2 Full Access to Region

Example:

{    "Version": "2012-10-17",    "Statement": [        {            "Sid": "xxxxxxxxxxx",            "Effect": "Allow",            "Action": [                "ec2:*"            ],            "Resource": "*",            "Condition": {            "StringEquals": {                "ec2:Region": "us-west-2"            }        }      }    ] }

Reference: http://stackoverflow.com/questions/18112784/iam-allowing-a-user-to-access-everything-for-ec2-on-a-region