Skip to content

Instantly share code, notes, and snippets.

View ryangraffy's full-sized avatar
[object Object]

Ryan Graffy ryangraffy

[object Object]
View GitHub Profile
IF OBJECT_ID('[dbo].spGetParticipantReportOptionsByProgram', 'P') IS NOT NULL
BEGIN
DROP PROCEDURE [dbo].[spGetParticipantReportOptionsByProgram];
END;
go
CREATE PROCEDURE [dbo].[spGetParticipantReportOptionsByProgram] @inProgramId INT
AS
@ryangraffy
ryangraffy / gist:21b8110c3591981fccca9aa129788fb7
Created September 19, 2018 13:02
Useful docker + sqlserver commands
Copy a .bak to the container
docker cp blah.bak sqlserver:/tmp
From https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017
Run a sql terminal
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'thePassword_'
Create a database
CREATE DATABASE TestDB
@ryangraffy
ryangraffy / gist:ab4f5878d4162134ec88f3d131c52d5b
Created August 28, 2018 16:34
Workaround to JENKINS-48960
Per https://wiki.jenkins.io/display/JENKINS/Jenkins+Script+Console
https://issues.jenkins-ci.org/browse/JENKINS-48960?focusedCommentId=332057&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-332057
update.groovy:
--------------
for (f in Jenkins.instance.getAllItems(jenkins.branch.MultiBranchProject.class)) {
if (f.parent instanceof jenkins.branch.OrganizationFolder) {
f.addTrigger(new com.cloudbees.hudson.plugins.folder.computed.PeriodicFolderTrigger("5m"));
}
@ryangraffy
ryangraffy / gist:d449cef6cbf5ab4a3ec2ac86bc0a85a5
Last active August 24, 2018 18:25
Find JIRA ids (e.g., HI5R-123) in git log between tags (e.g., "BTCM-211 and "BTCM-217")
git log origin/master..origin/release | grep -Eo "(HI5R|ITS)-\d+" | sort -u