Skip to content

Instantly share code, notes, and snippets.

View Sjeanpierre's full-sized avatar
💭
🤷🏿‍♂️

Stevenson Jean-Pierre Sjeanpierre

💭
🤷🏿‍♂️
View GitHub Profile
@Sjeanpierre
Sjeanpierre / switching_from_ahci_to_raid.txt
Created September 6, 2015 05:13
Windows 10, switching from AHCI to RAID after installation
Open Admin command prompt: bcdedit /set {current} safeboot minimal
Restart to BIOS and set to AHCI
Restart. Windows will boot into safe mode and will update the driver.
Open Admin command prompt: bcdedit /deletevalue {current} safeboot
Restart to boot Windows Normally.
@Sjeanpierre
Sjeanpierre / athena_ddl
Created December 6, 2018 06:26
Cloudflare logs Athena DDL - Create Athena schema for Cloudflare logs
CREATE EXTERNAL TABLE `cf_logs`(
`cachecachestatus` string COMMENT 'from deserializer',
`cacheresponsebytes` int COMMENT 'from deserializer',
`cacheresponsestatus` int COMMENT 'from deserializer',
`cachetieredfill` boolean COMMENT 'from deserializer',
`clientasn` int COMMENT 'from deserializer',
`clientcountry` string COMMENT 'from deserializer',
`clientdevicetype` string COMMENT 'from deserializer',
`clientip` string COMMENT 'from deserializer',
`clientipclass` string COMMENT 'from deserializer',
alias muxnew='tmux new -s'
alias muxlist='tmux list-sessions'
alias muxswitch='tmux switch -t'
alias muxsplit='tmux split-window -h'
alias muxdown='tmux select-pane -D'
alias muxup='tmux select-pane -U'
alias muxleft='tmux select-pane -L'
alias muxright='tmux select-pane -R'
alias muxnewtab='tmux new-window'
alias muxtab='tmux select-window -t'
@Sjeanpierre
Sjeanpierre / Skype_reset.sh
Created April 30, 2018 21:48
If your Skype for Business Installation on Mac OS keeps crashing on startup run the following.
#!/usr/bin/env bash
set -e
echo "Waring, this script will remove chat history and prefrences from Skype for Business"
read -p "Press enter to continue"
current_user=`whoami`
#going into directory where app stuff is stored
cd /users/$current_user/library
pwd
@Sjeanpierre
Sjeanpierre / aws_inventory.sh
Created November 24, 2015 19:42
Report running instances across all regions in AWS
regionlist=($(aws ec2 describe-regions --query Regions[*].RegionName --output text))
for region in "${regionlist[@]}"
do
aws --region $region ec2 describe-instances --output text --query 'Reservations[*].Instances[*].[Tags[?Key==`Name`] | [0].Value,PrivateIpAddress,InstanceId,State.Name,InstanceType,Placement.AvailabilityZone,LaunchTime]' --filters 'Name=tag:Name,Values=*'
done
@Sjeanpierre
Sjeanpierre / list_env.rb
Created January 4, 2014 01:56
List environment variables used by ruby script
#!/bin/ruby
REGEX = Regexp.new('ENV\[\s*(\S.*?)\s*\]')
def report
list = list_found
if list.empty?
puts 'No environment variables found'
else
@Sjeanpierre
Sjeanpierre / redis
Last active December 12, 2015 06:08
Monit configuration for Redis on platform servers
check process redis-server
with pidfile "/var/run/redis/redis.pid"
start program = "/etc/init.d/redis start"
stop program = "/etc/init.d/redis stop"
if cpu usage > 95% for 3 cycles then restart
if failed host localhost port 6379 then restart
if 5 restarts within 5 cycles then timeout
@Sjeanpierre
Sjeanpierre / db_connect.sh
Created June 15, 2015 19:04
Connect to database defined by rails databae.yml when on a server
#! /usr/bin/env bash
USERNAME=`cat config/database.yml | grep username | awk {'print$2'}`
PASSWORD=`cat config/database.yml | grep password | awk {'print$2'}`
HOST=`cat config/database.yml | grep host | awk {'print$2'}`
DATABASE=`cat config/database.yml | grep database | awk {'print$2'}`
mysql -h $HOST -u $USERNAME -D $DATABASE -p$PASSWORD
@Sjeanpierre
Sjeanpierre / redis.conf
Created December 12, 2012 02:34 — forked from anonymous/redis.conf
Spec and conf file for building redis on CentOS 5.8
# Redis configuration file example
# Note on units: when memory size is needed, it is possible to specify
# it in the usual form of 1k 5GB 4M and so forth:
#
# 1k => 1000 bytes
# 1kb => 1024 bytes
# 1m => 1000000 bytes
# 1mb => 1024*1024 bytes
# 1g => 1000000000 bytes
@Sjeanpierre
Sjeanpierre / dropbox
Created July 31, 2012 20:22 — forked from nyarla/dropbox
/etc/init.d/SpiderOak.sh
#!/bin/sh
# /etc/init.d/SpiderOak
### BEGIN INIT INFO
# Provides: SpiderOsk
# Required-Start: $network $syslog $remote_fs
# Required-Stop: $network $syslog $remote_fs
# Should-Start: $named $time
# Should-Stop: $named $time
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6