Clint Miller clintmiller

## README.md

      
              2 files
            
          
              1 fork
            
          
              3 comments
            
          
              5 stars
            
          
                johannrichard
                / README.md
            
            
              Last active
              July 17, 2023 21:27
            
              
                E-Mail Retention Policies for Gmail
              
          
    How to bring E-Mail retention policies to Gmail / Google Mail:

Go to Google Scripts and create a blank project (make sure you are logged into your Google account);
paste the code (below) (and modify the policies as needed);
set a trigger (Resources -> Current Project's Triggers -> Add one now) to run it at the preferred interval; and
create filters in Gmail/Google Mail that set policies when specific messages arrive

Inspired and adapted from Gmail Automation: 5 Useful Google Scripts to Automate Your Gmail

  
## samizdat-shell-help.bash
#!/bin/bash
###
### my-script — does one thing well
###
### Usage:
###   my-script <input> <output>
###
### Options:
###   <input>   Input file to read.
###   <output>  Output file to write. Use '-' for stdout.

## saas_metrics.sql
/*
Explanation of what's going on in this query can be found in this blog post: https://blog.redash.io/sql-query-to-calculate-saas-metrics-dd25d72a0521.
*/

WITH v_charges AS (
SELECT org_id,
       date_trunc('month', start_date) AS month,
       coalesce((extra::json->>'amount')::float, (extra::json->>'charged_amount')::integer/100) as total
FROM charges
WHERE extra::json->>'months' = '1'

## clean-up-boot-partition-ubuntu.md

      
              1 file
            
          
              288 forks
            
          
              135 comments
            
          
              1096 stars
            
          
                ipbastola
                / clean-up-boot-partition-ubuntu.md
            
            
              Last active
              June 5, 2024 21:05
            
              
                Safest way to clean up boot partition - Ubuntu 14.04LTS-x64, Ubuntu 16.04LTS-x64
              
          
    Safest way to clean up boot partition - Ubuntu 14.04LTS-x64, Ubuntu 16.04LTS-x64

Reference
Case I: if /boot is not 100% full and apt is working

1. Check the current kernel version

$ uname -r 


## creating_a_date_dimension_table_in_postgresql.sql
DROP TABLE if exists d_date;

CREATE TABLE d_date
(
  date_dim_id              INT NOT NULL,
  date_actual              DATE NOT NULL,
  epoch                    BIGINT NOT NULL,
  day_suffix               VARCHAR(4) NOT NULL,
  day_name                 VARCHAR(9) NOT NULL,
  day_of_week              INT NOT NULL,

## gist:9271432

      
              1 file
            
          
              2 forks
            
          
              0 comments
            
          
              4 stars
            
          
                pokle
                / gist:9271432
            
            
              Last active
              August 22, 2017 16:01
            
              
                Automatically mount the EC2 ephermal SSDs as raid0 on Ubuntu
              
          
    Launch your EC2 EBS instance with two SSDs on the second and third slots (after the root EBS volume), with this in your userdata:
#!/usr/bin/env bash

umount /dev/xvdb
umount /dev/xvdc
apt-get install mdadm -y
mkdir /u01

cat > /etc/init/mount-ephermal-ssd.conf <

  
## new_bashrc.sh
#!/bin/bash
# License: Public Domain.
# Author:  Joseph Wecker, 2012
#
# -- DEPRICATED --
# This gist is slow and is missing .bashrc_once
# Use the one in the repo instead! https://github.com/josephwecker/bashrc_dispatch
# (Thanks gioele)
#
# Are you tired of trying to remember what .bashrc does vs .bash_profile vs .profile?
	#!/bin/bash
	###
	### my-script — does one thing well
	###
	### Usage:
	### my-script <input> <output>
	###
	### Options:
	### <input> Input file to read.
	### <output> Output file to write. Use '-' for stdout.
	/*
	Explanation of what's going on in this query can be found in this blog post: https://blog.redash.io/sql-query-to-calculate-saas-metrics-dd25d72a0521.
	*/

	WITH v_charges AS (
	SELECT org_id,
	date_trunc('month', start_date) AS month,
	coalesce((extra::json->>'amount')::float, (extra::json->>'charged_amount')::integer/100) as total
	FROM charges
	WHERE extra::json->>'months' = '1'
	DROP TABLE if exists d_date;

	CREATE TABLE d_date
	(
	date_dim_id INT NOT NULL,
	date_actual DATE NOT NULL,
	epoch BIGINT NOT NULL,
	day_suffix VARCHAR(4) NOT NULL,
	day_name VARCHAR(9) NOT NULL,
	day_of_week INT NOT NULL,
	#!/bin/bash
	# License: Public Domain.
	# Author: Joseph Wecker, 2012
	#
	# -- DEPRICATED --
	# This gist is slow and is missing .bashrc_once
	# Use the one in the repo instead! https://github.com/josephwecker/bashrc_dispatch
	# (Thanks gioele)
	#
	# Are you tired of trying to remember what .bashrc does vs .bash_profile vs .profile?