ryangraffy

IF OBJECT_ID('[dbo].spGetParticipantReportOptionsByProgram', 'P') IS NOT NULL
    BEGIN
        DROP PROCEDURE [dbo].[spGetParticipantReportOptionsByProgram];
    END;

go

CREATE PROCEDURE [dbo].[spGetParticipantReportOptionsByProgram] @inProgramId INT
AS

ryangraffy

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

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

git log origin/master..origin/release | grep -Eo "(HI5R|ITS)-\d+" | sort -u