Skip to content

Instantly share code, notes, and snippets.

On vacation

Jared Dobson jaredmdobson

On vacation
View GitHub Profile
jaredmdobson / gist:5a94fb2a43157953d017fc2dd0fdd03e
Created Apr 29, 2021
Find out which certificate a macos was signed with.
View gist:5a94fb2a43157953d017fc2dd0fdd03e
codesign -d --extract-certificates ./[App Name Here].app;
openssl x509 -inform DER -in codesign0 -out codesign0.pem;
openssl x509 -inform DER -in codesign1 -out codesign1.pem;
openssl x509 -inform DER -in codesign2 -out codesign2.pem;
cat codesign1.pem codesign2.pem > cachain.pem;
openssl x509 -inform DER -in codesign0 -noout -nameopt -oneline -subject -serial -dates;
View gist:1da04297140e07fdfebb2b42def9e94a
jaredmdobson / sp_queryplan.sql
Created Jan 13, 2012
SQL Server 2008 Shows Execution Plan for a given spid.
View sp_queryplan.sql
-- Author: Jared Dobson
-- Date: 12/22/2010
-- Description: Shows Execution Plan for a given spid.
CREATE PROCEDURE sp_queryplan ( @SessionID INT )
jaredmdobson /
Last active Jun 14, 2018 — forked from cyxou/
Upgrade Jenkins on Bitnami VM
sudo /opt/bitnami/ stop tomcat
cd /opt/bitnami
sudo cp -f apache-tomcat/webapps/jenkins.war apps/jenkins/jenkins.war.bak
sudo rm -r apache-tomcat/webapps/jenkins
sudo rm -r apache-tomcat/webapps/jenkins.war
sudo rm -r apache-tomcat/work/Catalina/localhost/jenkins
sudo wget
sudo mv jenkins.war apache-tomcat/webapps/
jaredmdobson / sp_helpindex3.sql
Last active May 30, 2018
T-SQL sp_helpindex3 replaces sp_helpindex2
View sp_helpindex3.sql
USE master
IF OBJECT_ID('sp_helpindex2', 'P') IS NOT NULL
DROP PROCEDURE sp_helpindex2
IF OBJECT_ID('sp_helpindex3', 'P') IS NOT NULL
DROP PROCEDURE sp_helpindex3
jaredmdobson / launch.json
Last active Apr 9, 2018
VS Code Rust LLDB Debug Launch.json 2018
View launch.json
// Use IntelliSense to learn about possible attributes.
// Hover to view descriptions of existing attributes.
// For more information, visit:
"version": "0.2.0",
"configurations": [
"name": "Debug",
"type": "lldb",
jaredmdobson / tasks.json
Created Apr 9, 2018
VS Code Rust Cargo Tasks 2018
View tasks.json
// Available variables which can be used inside of strings.
// ${workspaceRoot}: the root folder of the team
// ${file}: the current opened file
// ${fileBasename}: the current opened file's basename
// ${fileDirname}: the current opened file's dirname
// ${fileExtname}: the current opened file's extension
// ${cwd}: the current working directory of the spawned process
"version": "0.1.0",
"command": "cargo",
jaredmdobson / EnableAllTriggers.sql
Created Jan 13, 2012
T-SQL Enable All Triggers
View EnableAllTriggers.sql
CREATE PROCEDURE [dbo].[EnableAllTriggers]
DECLARE @string VARCHAR(8000)
DECLARE @tableName NVARCHAR(500)