jeffjohnson9046

// jsfiddle:  https://jsfiddle.net/Lkxtryvp/1/

var myAwesomeLoop = function(x) {
	  // This is the magic sauce right here - you're creating a unit of work that will be done at some
    // point in the future.  We're not exactly sure when, but the deferred object will notify us when
    // it's done (by calling "resolve()" or "reject()" on itself).
    var deferred = $.Deferred();
    
    // We'll create a simple loop to concatenate some values together.  This simulates where the
    // actual, for-real work would be done (e.g. an AJAX request, some sort of long-running calculation, etc)

jeffjohnson9046

# Occasionally I want to see the application properties that are pulled down from the Spring Cloud Config service that provides 
# content to our Spring Boot apps.  Since I seem to have to re-discover this every time, I figured I'd write it down to help me
# remember.
#
# Additional docs can be found here: https://cloud.spring.io/spring-cloud-config/single/spring-cloud-config.html

# To see the output in YML format
curl -u {the user name}:{the user password} http://{the domain:port}/{the application name}-{the spring profile name}.yml

# For example:

jeffjohnson9046

# This is something that I always forget and had a surprisingly hard time finding (or better yet, understanding).  Here's the
# scenario: a colleague creates a new kubernetes cluster, named" cluster-foo.example.com".  You want to look at it (for 
# troubleshooting, updating the deployment, whatever).  To get your kubectl installation to "see" the new cluster, take the 
# following steps:

# ASSUMPTION:  You have pointed kops to some location where the cluster configurations are stored 
# (I have this in my ~/.bash_profile):
export KOPS_STATE_STORE=s3://example-state-store

# Use kops to get the list of clusters

jeffjohnson9046

SELECT 
      * 
FROM 
      INFORMATION_SCHEMA.ROUTINES 
WHERE 
      ROUTINE_DEFINITION LIKE '%My Text%' 
ORDER BY ROUTINE_NAME;

jeffjohnson9046

-- From this article:  https://logicalread.com/troubleshoot-high-cpu-sql-server-pd01/#.WW_hjtPytuY
-- Show CPU Utilization by SQL Server, system idle time and other processes
DECLARE @ms_ticks_now BIGINT

SELECT @ms_ticks_now = ms_ticks
FROM sys.dm_os_sys_info;

SELECT TOP 15 record_id
	,dateadd(ms, - 1 * (@ms_ticks_now - [timestamp]), GetDate()) AS EventTime
	,SQLProcessUtilizationPercent

jeffjohnson9046

# Install the Spring Boot CLI via homebrew (https://brew.sh/)
brew update
brew tap pivotal/tap
brew install springboot

# Download the Java 8 JCE from here: http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html
# Extract the .zip file somewhere.  There should be three files:
#
# local_policy.jar
# README.txt

jeffjohnson9046

/*
* From here:  http://mysql.rjweb.org/doc.php/uuid
*/
-- Convert a formatted UUID to a BINARY(16)
CREATE FUNCTION UuidToBin(_uuid CHAR(36))
    RETURNS BINARY(16)
    LANGUAGE SQL  DETERMINISTIC  CONTAINS SQL  SQL SECURITY INVOKER
RETURN
    UNHEX(CONCAT(
        SUBSTR(_uuid, 15, 4),

jeffjohnson9046

GREEN='\[\033[0;32m\]'
YELLOW='\[\033[0;33m\]'
NC='\[\033[0m\]' # No Color

function parse_git_dirty {
  [[ $(git status 2> /dev/null | tail -n1) != "nothing to commit, working tree clean" ]] && echo "*"
}

function parse_git_branch {
  ref=$(git symbolic-ref HEAD 2> /dev/null) || return

jeffjohnson9046

SELECT *
FROM information_schema.KEY_COLUMN_USAGE
WHERE table_schema = /* the schema you're interested in */
AND referenced_table_name = /* name of the table that is referenced by other tables via foreign key */;

jeffjohnson9046

SELECT UNHEX(REPLACE(UUID(),'-',''))