Breakpoints in .net core library will not be hit when debugging consuming WinForms app

https://stackoverflow.com/q/55359599/1219280

Check the project's Debug information property found here: Properties > Build > Advanced (button at bottom) > Debugging information

Retrieving Jenkins Credentials passwords using Jenkins Script Console

https://github.com/tkrzeminski/jenkins-groovy-scripts/blob/master/show-all-credentials.groovy

import jenkins.model.*

import com.cloudbees.plugins.credentials.*
import com.cloudbees.plugins.credentials.impl.*
import com.cloudbees.plugins.credentials.domains.*
import com.cloudbees.jenkins.plugins.sshcredentials.impl.BasicSSHUserPrivateKey
import com.cloudbees.jenkins.plugins.awscredentials.AWSCredentialsImpl
import org.jenkinsci.plugins.plaincredentials.StringCredentials
import org.jenkinsci.plugins.plaincredentials.impl.FileCredentialsImpl

def showRow = {
    credentialType, secretId, username = null, password = null, description = null - >
        println("${credentialType} : ".padLeft(20) + secretId ? .padRight(38) + " | " + username ? .padRight(20) + " | " + password ? .padRight(40) + " | " + description)
}

// set Credentials domain name (null means is it global)
domainName = null

credentialsStore = Jenkins.instance.getExtensionList('com.cloudbees.plugins.credentials.SystemCredentialsProvider')[0] ? .getStore()
domain = new Domain(domainName, null, Collections. < DomainSpecification > emptyList())

credentialsStore ? .getCredentials(domain).each {
    if (it instanceof UsernamePasswordCredentialsImpl)
        showRow("user/password", it.id, it.username, it.password ? .getPlainText(), it.description)
    else if (it instanceof BasicSSHUserPrivateKey)
        showRow("ssh priv key", it.id, it.passphrase ? .getPlainText(), it.privateKeySource ? .getPrivateKey(), it.description)
    else if (it instanceof AWSCredentialsImpl)
        showRow("aws", it.id, it.accessKey, it.secretKey ? .getPlainText(), it.description)
    else if (it instanceof StringCredentials)
        showRow("secret text", it.id, it.secret ? .getPlainText(), '', it.description)
    else if (it instanceof FileCredentialsImpl)
        showRow("secret file", it.id, it.content ? .text, '', it.description)
    else
        showRow("something else", it.id, '', '', '')
}

return

Updating multiple fields, one of them conditionally in SQL

                                    UPDATE
                                        table
                                    SET
                                        f1 = 27521,
                                        f2 = CASE
                                                        WHEN f2 = 21 AND actionType = 12 THEN
                                                            27521
                                                        ELSE
                                                            f2
                                                      END
                                    WHERE
                                        f1 = 21

Enabling mysql.general_log

SET global general_log = 1;
SET global log_output = 'table';

Taken from here

Looking for (and killing) locks in mySQL

Taken from here.

1) List all your processes with
    SHOW FULL PROCESSLIST

2) Look at the "State" column, it will mention a lock if existent

3) Kill the process you want by running
    KILL [process_id_taken_from_process_list]

Javascript Array Distinct functionality

https://codeburst.io/javascript-array-distinct-5edc93501dc4

Translating Set Operations into SQL Joins

Thanks to a colleague from work for sharing this.
The last one is was not familiar to me.
Good to know.