Skip to content

Instantly share code, notes, and snippets.

View xagronaut's full-sized avatar

Jeffrey A. Miller xagronaut

View GitHub Profile
@xagronaut
xagronaut / BulkApplyTfsWorkItemTag.js
Created January 16, 2015 00:06
A short self-contained JavaScript snippet (IIFE) to apply a tag to multiple TFS Work Items through the TFS Web Access interface. If you don't have a version of TFS that allows bulk application of tags, this can help.
// Author: Jeffrey A. Miller (@xagronaut), 01/15/2015
// License: Apache 2.0
//
// Description: Apply a custom tag to multiple TFS Work Items systematically
//
// Notes:
// * Navigate to a TFS query page [YourTfsServer]:8080/tfs/[TfsCollection]/[TfsProject]/_workItems
// * Identify the Work Item IDs you want to update and edit the array at the end of this code snippet
// * This code should be executed in your browser's script console (tested in Chrome)
//
@xagronaut
xagronaut / addqrcode.html
Last active August 29, 2015 14:27
Bookmarklets - including "Add QR code" for the current page for printing or sharing over-the-shoulder
<html>
<head>
<title>Add QR Code - by Jeffrey A. Miller</title>
<!-- the bookmarklet logic is mine; the formatted bookmarklet link was produced with help from
Bookmarklet Creator with Script Includer
http://mrcoles.com/bookmarklet/
It's a very awesome tool! Check it out!
-->
@xagronaut
xagronaut / 1_Neo4jFromDbSchemaMetadata.linq
Last active May 2, 2016 12:56
LINQPad Scripts to create CYPHER queries from database metadata extracted from Microsoft SQL Server. They should be executed in the order indicated at the beginning of the filename. You'll need to point to your own database connection in LINQPad. Make sure to check "Include System Views and SPs" in your connection.
<Query Kind="Statements">
</Query>
string.Format("// Add database schemas\nUNWIND [\n\t{0}\n] AS item" + @"
MERGE (db:Database {{ name: item[0] }})
MERGE (sc:DbSchema {{ name: item[1] }})
MERGE (ow:DbAccount {{ name: item[2] }})
MERGE (db)-[:CONTAINS]->(sc)
MERGE (ow)-[:OWNS]->(sc)
RETURN DISTINCT db, ow, sc;
@xagronaut
xagronaut / Vagrantfile
Created October 27, 2016 23:26
WorldVax.org Linux VM provisioning script
# -*- mode: ruby -*-
# vi: set ft=ruby :
$rootScript = <<SCRIPT
echo "**********************************"
echo "* Modifying hostname"
echo "**********************************"
echo worldvaxdev>/etc/hostname
echo "**********************************"
echo "* Installing unzip"
@xagronaut
xagronaut / 1_SqlDependencies.sql
Last active December 21, 2016 21:07
Analysis query for SQL Server based on the sys.sql_dependencies view. Suitable for CSV export and import into Neo4j.
-- *******
-- * Track which objects in the database depend on other objects
-- *******
;WITH ObjectTypeNames AS (
SELECT [Type] = 'P', [Name] = 'DbProcedure' UNION ALL
SELECT [Type] = 'FN', [Name] = 'DbFunction' UNION ALL
SELECT [Type] = 'U', [Name] = 'DbTable' UNION ALL
SELECT [Type] = 'V', [Name] = 'DbView'
),
ObjectReferences AS (
@xagronaut
xagronaut / largePrint.grass
Last active June 13, 2017 16:36
Sample Graph Stylesheet (.grass) file for Neo4j
node {
diameter: 100px;
color: #FFD86E;
border-color: #EDBA39;
border-width: 2px;
text-color-internal: #604A0E;
font-size: 16px;
/* uncomment this line if you want the "name" property to be the default caption */
/* caption: '{name}'; */
}
@xagronaut
xagronaut / SoftwareDevelopmentProcessModel.adoc
Last active August 21, 2017 20:28
Software development process model in Neo4j

Software Development Process Model

Introduction

Sometimes software just seems to happen haphazardly, despite our allegiance to diligence and process. Systems creep into our lives through some combination of people, skills, and tools. The result is often a mass of unfamiliar and unclear components written by many authors, with little understanding of the big picture.

@xagronaut
xagronaut / lightingTalkTreasureHunt.md
Last active August 23, 2017 21:59
This is a bookmarklet lightning talk! Follow the QR codes to find the goodies!

Lightning Talk Treasure Hunt

Choices

Just the Info!

Choices

@xagronaut
xagronaut / GraphToGreatnessResourcesList.md
Created February 13, 2018 22:48
This page contains helpful resources about Neo4j.

Neo4j Resources

This page contains helpful resources about Neo4j.

Manuals and Docs

Neo4j Cypher Refcard

@xagronaut
xagronaut / _Bookmarklets_README.md
Last active July 17, 2018 16:24
Some of my favorite bookmarklets

Bookmarklets! by Jeffrey A. Miller ( @xagronaut )

The following are some bookmarklets I've created:

  • Add QR Code to page
  • QR image hover
  • QR link hover

Most of them were created with the assistance of the very helpful bookmarklet creator at mrcoles.com/bookmarklet.