miguelfito

---------------------------------------------------------------------------------------------
-- ORACLE DBA COOKBOOK ----------------------------------------------------------------------
---------------------------------------------------------------------------------------------

-- Set wide output in rlwrap
set lines 1000 pages 1000


-- Get privileges granted for certain table/object
SELECT * FROM ALL_TAB_PRIVS WHERE TABLE_NAME='TABLE_NAME';

miguelfito

cat 'IdentityFile ~/.ssh/id_rsa' > ~/.ssh/config
chmod 600 ~/.ssh/config

miguelfito

cat ~/.ssh/id_rsa.pub | ssh hostname 'cat >> ~/.ssh/authorized_keys'
-OR-
sh-copy-id -i ~/.ssh/id_rsa.pub username:password@remotehost.co.jp

miguelfito

# Define a new alias for git tree, colorized and with graph
git config --global alias.tree 'log --graph --full-history --all --color --date=short --pretty=format:"%Cred%x09%h %Creset%ad%Cblue%d %Creset %s %C(bold)(%an)%Creset"'

# Then, invoke it
git tree

# Source: https://coderwall.com/p/4-itow/nice-terminal-git-tree-graph

miguelfito

# Start Puppet Master process in foreground (v3.x)
puppet master --no-daemonize --debug --verbose

# Start Puppet Agent test without doing any change (v3.x)
puppet agent --test --debug --noop

# Get puppet config for a parameter
puppet config print "name_of_the_parameter"
# ... or print full configuration and then filter 
puppet config print | grep -i "filter"

miguelfito

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

miguelfito

#!/bin/bash

# store the current dir
CUR_DIR=$(pwd)

# Let the person running the script know what's going on.
echo -e "\n\033[1mFetching in latest changes for all repositories...\033[0m\n"

# Find all git repositories and update it to the master latest revision
for i in $(find . -name ".git" | cut -c 3-); do

miguelfito

minikube start --kubernetes-version=v1.7.0 --extra-config=apiserver.Authorization.Mode=RBAC

kubectl create clusterrolebinding add-on-cluster-admin --clusterrole=cluster-admin --serviceaccount=kube-system:default

minikube dashboard

miguelfito

import jenkins.model.*

i = 1

def matchedJobs = Jenkins.instance.items.findAll { job ->
    job.name =~ /my_regex_here/
}
    
matchedJobs.each { job ->
    println i++ + " >> This job will be deleted: " + job.name

miguelfito

An Ansible summary

Jon Warbrick, July 2014, V3.2 (for Ansible 1.7)

Configuration file

intro_configuration.html

First one found from of