Skip to content

Instantly share code, notes, and snippets.

Avatar
🌴
On vacation

jaredmdobson

🌴
On vacation
View GitHub Profile
@jaredmdobson
jaredmdobson / upgrade-jenkins.sh
Last active Jun 14, 2018 — forked from cyxou/upgrade-jenkins.sh
Upgrade Jenkins on Bitnami VM
View upgrade-jenkins.sh
#!/bin/bash
sudo /opt/bitnami/ctlscript.sh 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 http://mirrors.jenkins-ci.org/war/latest/jenkins.war
sudo mv jenkins.war apache-tomcat/webapps/
@jaredmdobson
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
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: https://go.microsoft.com/fwlink/?linkid=830387
"version": "0.2.0",
"configurations": [
{
"name": "Debug",
"type": "lldb",
@jaredmdobson
jaredmdobson / sp_helpindex3.sql
Last active May 30, 2018
T-SQL sp_helpindex3 replaces sp_helpindex2
View sp_helpindex3.sql
USE master
GO
IF OBJECT_ID('sp_helpindex2', 'P') IS NOT NULL
BEGIN
DROP PROCEDURE sp_helpindex2
END
IF OBJECT_ID('sp_helpindex3', 'P') IS NOT NULL
BEGIN
DROP PROCEDURE sp_helpindex3
END
@jaredmdobson
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 )
AS
BEGIN
SELECT
[DEQP].[query_plan],
@jaredmdobson
jaredmdobson / EnableAllTriggers.sql
Created Jan 13, 2012
T-SQL Enable All Triggers
View EnableAllTriggers.sql
CREATE PROCEDURE [dbo].[EnableAllTriggers]
AS
DECLARE @string VARCHAR(8000)
DECLARE @tableName NVARCHAR(500)
DECLARE cur CURSOR
You can’t perform that action at this time.