ffabreti’s gists

ffabreti / SQLServer cheat sheet

Last active August 29, 2015 14:06

	-- conectar via FreeTDS
	TDSVER=7.1 tsql -H <serverName> -p 1433 -U <domain>\\<user> -P `cat pass.txt`

	-- fim de comando
	go

	-- selecionar o banco
	use <dbname>

	-- info sobre tabela

ffabreti / ionic

Last active August 29, 2015 14:15

IONIC

	ERROS:
	================================================
	ao tentar iniciar o android emulator:
	ioctl(KVM_CREATE_VM) failed: 16 Device or resource busy
	ko:failed to initialize KVM
	1) desligar máquinas virtuais VIRTUALBOX
	2) sudo /etc/init.d/vboxdrv stop
	================================================

ffabreti / Rails - cheatsheet

Created February 23, 2015 21:05

RAILS

ffabreti / install-redis.sh

Last active April 6, 2016 01:57 — forked from four43/install-redis.sh

Install Redis

	#!/bin/bash
	# from here: http://www.codingsteps.com/install-redis-2-6-on-amazon-ec2-linux-ami-or-centos/
	# and here: https://raw.github.com/gist/257849/9f1e627e0b7dbe68882fa2b7bdb1b2b263522004/redis-server
	###############################################
	# To use:
	# wget https://gist.githubusercontent.com/ffabreti/0512fb5705926ae7f5ee34536a0e28db/raw/install-redis.sh
	# chmod 777 install-redis.sh
	# ./install-redis.sh
	###############################################
	function die {

ffabreti / exec result of install-redis.sh

Last active April 1, 2016 20:13

	[ec2-user@ip-172-31-49-17 ~]$ wget https://gist.githubusercontent.com/ffabreti/0512fb5705926ae7f5ee34536a0e28db/raw/97304371c0476ddcf0ae76151b20faf895bbd94b/install-redis.sh
	--2016-04-01 20:06:43-- https://gist.githubusercontent.com/ffabreti/0512fb5705926ae7f5ee34536a0e28db/raw/97304371c0476ddcf0ae76151b20faf895bbd94b/install-redis.sh
	Resolvendo gist.githubusercontent.com (gist.githubusercontent.com)... 199.27.76.133
	Conectando-se a gist.githubusercontent.com (gist.githubusercontent.com)\|199.27.76.133\|:443... conectado.
	A requisição HTTP foi enviada, aguardando resposta... 200 OK
	Tamanho: 6690 (6,5K) [text/plain]
	Salvando em: “install-redis.sh”

	install-redis.sh 100%[=========================================================================>] 6,53K --.-KB/s em 0s

ffabreti / install-redis-aws.sh

Created April 1, 2016 21:24

	#!/bin/bash
	# from here: http://www.codingsteps.com/install-redis-2-6-on-amazon-ec2-linux-ami-or-centos/
	# and here: https://raw.github.com/gist/257849/9f1e627e0b7dbe68882fa2b7bdb1b2b263522004/redis-server
	###############################################
	# To use:
	# wget https://gist.githubusercontent.com/ffabreti/0512fb5705926ae7f5ee34536a0e28db/raw/install-redis.sh
	# chmod 777 install-redis.sh
	# ./install-redis.sh
	###############################################
	function die {

ffabreti / pg_extract.sh

Created August 7, 2018 11:09 — forked from brock/pg_extract.sh

Extract all databases (or one by name) from a sql file created by pg_dumpall

	#!/bin/bash
	# extract all postgres databases from a sql file created by pg_dumpall
	# this script outputs one .sql file for each database in the original .sql file
	# unless you pass the name of a database in the dump

	if [ $# -lt 1 ]
	then
	echo "Usage: $0 <postgresql sql dump> [dbname]" >&2
	exit 1
	fi

Fernando ffabreti