Jonathan Boeke jboeke

## github-print-bookmarklet
javascript:(function(e,a,g,h,f,c,b,d)%7Bif(!(f=e.jQuery)%7C%7Cg%3Ef.fn.jquery%7C%7Ch(f))%7Bc=a.createElement(%22script%22);c.type=%22text/javascript%22;c.src=%22http://ajax.googleapis.com/ajax/libs/jquery/%22+g+%22/jquery.min.js%22;c.onload=c.onreadystatechange=function()%7Bif(!b&&(!(d=this.readyState)%7C%7Cd==%22loaded%22%7C%7Cd==%22complete%22))%7Bh((f=e.jQuery).noConflict(1),b=1);f(c).remove()%7D%7D;a.documentElement.childNodes%5B0%5D.appendChild(c)%7D%7D)(window,document,%221.3.2%22,function($,L)%7B$('%23header,%20.pagehead,%20.breadcrumb,%20.commit,%20.meta,%20%23footer,%20%23footer-push,%20.wiki-actions,%20%23last-edit,%20.actions,%20.header,.site-footer,.repository-sidebar,.file-navigation,.gh-header-meta,.gh-header-actions,#wiki-rightbar,#wiki-footer,.commit-tease').remove();%20$('%23files,%20.file').css(%7B%22background%22:%22none%22,%20%22border%22:%22none%22%7D);%20$('link').removeAttr('media');%7D); var removeMe = document.getElementsByClassName("file-header")[0]; removeMe.parentNode.removeChild(r

## resume.json
{
  "basics": {
    "name": "Jonathan Boeke",
    "label": "Full Stack Software Developer",
    "summary": "I am an experienced full stack software developer who has been tinkering with technology ever since I took interest in my dad's Lear Siedler ADM-3A in my childhood. I've continued this passion for tinkering, making me a strong debugger; not stopping until I find the solution to a problem and making the system work. I am thrilled to watch the ways technology is changing our world and being a small part of that forward momentum.",
    "website": "https://jonathanboeke.com",
    "phone": "970-444-2844",
    "email": "jb@avietech.com",
    "location": {
      "countryCode": "US",

## FullOuterJoinExample.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApplication1
{
    public class ColorPrefs
    {

## gist:993773
-- Fix orphaned users after restoring a SQL database (pre-2012 version)
USE YourDBName;
exec sp_change_users_login 'update_one', 'username', 'username';

-- Fix orphaned users after restoring a SQL database (version 2012 and after)
USE master;
CREATE LOGIN username WITH PASSWORD = 'password';
USE YourDBName;
ALTER USER username WITH LOGIN = username;

## 001 NoLevels.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <style type="text/css">
        body
        {
            font-family: Arial;
            color: black;
            background-color: white;
        }

## 001 Levels.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title></title>
    <style type="text/css">
        body
        {
            font-family: Arial;
            color: black;
            background-color: white;

## Sample Contract - Hours Only
## For educational purposes only! Not a substitute for individualized advice from a qualified legal practitioner. ##

This Independent Consultant Agreement (the "Agreement") is entered into on <date> by and between <your name or company name> (the "Consultant"), and <client name> (the "Company").

RECITALS

WHEREAS, the Company is in need of assistance in the area of computer programming services; and WHEREAS, Consultant has agreed to perform consulting work for the Company in computer programming services and other related activities for the Company;

NOW, THEREFORE, the parties hereby agree as follows:

## Sample Contract - Software Deliverable
## For educational purposes only! Not a substitute for individualized advice from a qualified legal practitioner. ##

SOFTWARE CONSULTING AGREEMENT

THIS AGREEMENT is entered into on <contract date> by and between Avie, LLC, (hereinafter "Developer") and <client company>, (hereinafter "Company").

RECITALS

WHEREAS, Company wishes to retain Developer to develop certain <software type> software (hereinafter defined and referred to as “Software”); and

## gist:765530
ALTER PROCEDURE [dbo].[spTestAllViews]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	DECLARE @Loopid int, @MaxID int, @ViewName varchar(100)

	SELECT quotename(table_schema) +'.' + quotename(table_name) as ViewName, identity(int,1,1) as ID

## Test SQL Views (The Hard Way)
SELECT TOP 1 FROM viewFoo1
SELECT TOP 1 FROM viewFoo2
SELECT TOP 1 FROM viewFoo3
...
	{
	"basics": {
	"name": "Jonathan Boeke",
	"label": "Full Stack Software Developer",
	"summary": "I am an experienced full stack software developer who has been tinkering with technology ever since I took interest in my dad's Lear Siedler ADM-3A in my childhood. I've continued this passion for tinkering, making me a strong debugger; not stopping until I find the solution to a problem and making the system work. I am thrilled to watch the ways technology is changing our world and being a small part of that forward momentum.",
	"website": "https://jonathanboeke.com",
	"phone": "970-444-2844",
	"email": "jb@avietech.com",
	"location": {
	"countryCode": "US",
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;

	namespace ConsoleApplication1
	{
	public class ColorPrefs
	{
	-- Fix orphaned users after restoring a SQL database (pre-2012 version)
	USE YourDBName;
	exec sp_change_users_login 'update_one', 'username', 'username';

	-- Fix orphaned users after restoring a SQL database (version 2012 and after)
	USE master;
	CREATE LOGIN username WITH PASSWORD = 'password';
	USE YourDBName;
	ALTER USER username WITH LOGIN = username;
	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
	<html>
	<head>
	<style type="text/css">
	body
	{
	font-family: Arial;
	color: black;
	background-color: white;
	}
	## For educational purposes only! Not a substitute for individualized advice from a qualified legal practitioner. ##

	This Independent Consultant Agreement (the "Agreement") is entered into on <date> by and between <your name or company name> (the "Consultant"), and <client name> (the "Company").

	RECITALS

	WHEREAS, the Company is in need of assistance in the area of computer programming services; and WHEREAS, Consultant has agreed to perform consulting work for the Company in computer programming services and other related activities for the Company;

	NOW, THEREFORE, the parties hereby agree as follows:
	## For educational purposes only! Not a substitute for individualized advice from a qualified legal practitioner. ##

	SOFTWARE CONSULTING AGREEMENT

	THIS AGREEMENT is entered into on <contract date> by and between Avie, LLC, (hereinafter "Developer") and <client company>, (hereinafter "Company").

	RECITALS

	WHEREAS, Company wishes to retain Developer to develop certain <software type> software (hereinafter defined and referred to as “Software”); and
	ALTER PROCEDURE [dbo].[spTestAllViews]
	AS
	BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	DECLARE @Loopid int, @MaxID int, @ViewName varchar(100)

	SELECT quotename(table_schema) +'.' + quotename(table_name) as ViewName, identity(int,1,1) as ID
	SELECT TOP 1 FROM viewFoo1
	SELECT TOP 1 FROM viewFoo2
	SELECT TOP 1 FROM viewFoo3
	...