Jade Abbott jaderabbit

## split_files_based_on_percentage.sh
split -l $[ $(wc -l filename|cut -d" " -f1) * percentage / 100 ] filename

## cool_terminal_tools.sh
split
wc
grep
sed
tee

## del_dups.sql
DELETE FROM tablename
WHERE id IN (
    SELECT id
    FROM (SELECT id,
                 ROW_NUMBER() OVER (partition BY column1, column2, column3 ORDER BY id) AS rnum
          FROM tablename) t
    WHERE t.rnum > 1);

## How-to-install-Ubuntu-on-Dell-Inspiron-15-7000.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jaderabbit
                / How-to-install-Ubuntu-on-Dell-Inspiron-15-7000.md
            
            
              Last active
              June 27, 2017 11:39
            
              
                How to install Ubuntu on Dell Inspiron 15 7000
              
          
You need Ubuntu 17 on a live usb. Ubuntu 16 does not appear to support the fancy CPUs


You need to switch from IDE mode to AHCI mode on the harddrive else, it won't find it.

Run Command Prompt as Admin
Invoke a Safe Mode boot with the command: bcdedit /set {current} safeboot minimal
Restart the PC and enter your BIOS during bootup.
Change from IDE to AHCI mode then Save & Exit.
Windows 10 will launch in Safe Mode.
Right click the Window icon and select to run the Command Prompt in Admin mode from among the various options.


Cancel Safe Mode booting with the command: bcdedit /deletevalue {current} safeboot


## server_wisdom

sudo netstat -lpn

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04
Something like
swapoff -a
fallocate 4G /swapfile
mkswap /swapfile
swapon /swapfile

## server_wisdom

sudo netstat -lpn

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04
Something like
swapoff -a
fallocate 4G /swapfile
mkswap /swapfile
swapon /swapfile

## spark_setup.bat
JAVA_HOME=...
SPARK_HOME=...
SPARK_SCALA_VERSION=...

## things-derik-says-2
psql -e \copy (select * from py_killer) to /tmp/eat_me_numpy.csv

## things-derik-says.sh
pg_restore -v -U dev -W -d kalories_galore -n public -O ./muffin.dmp

## find-replace-exclude-git
grep -lr --exclude-dir=".git" -e "oldword" . | xargs sed -i "s/oldword/newword/g"
	DELETE FROM tablename
	WHERE id IN (
	SELECT id
	FROM (SELECT id,
	ROW_NUMBER() OVER (partition BY column1, column2, column3 ORDER BY id) AS rnum
	FROM tablename) t
	WHERE t.rnum > 1);

	sudo netstat -lpn

	https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04
	Something like
	swapoff -a
	fallocate 4G /swapfile
	mkswap /swapfile
	swapon /swapfile