jamiebuilds

Multiple GitHub accounts (Work vs Personal)

This setup uses some tricks to ensure that the right email/name/ssh-key is used for the right repos without having to think about it ever again.

• First generate two SSH keys, ~/.ssh/id_ed25519 and ~/.ssh/id_ed25519_work
• Add one key to your personal account and the other to your work account

.ssh/config

m-radzikowski

#!/usr/bin/env bash

set -Eeuo pipefail
trap cleanup SIGINT SIGTERM ERR EXIT

script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P)

usage() {
  cat <<EOF
Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -p param_value arg1 [arg2...]

johannesprinz

Migrate-GitlabToDevops

Dependencies

You will need an access token from azure devops. Get yours here. This script will need contributor access to the project in question.

How to run

# populate user map in Map-IssueToWorkitem

robinsmidsrod

# boot-url points to an nfs URL
# sanboot-url points to an http URL
# ubuntu-version contains 18.04.3
# ubuntu-release contains bionic

:ubuntu
echo Booting Ubuntu from iSCSI for ${initiator-iqn}
set root-path ${base-iscsi}:${hostname}.boot.ubuntu
sanboot ${root-path} || goto failed
goto start

stummsft

/*
 * Creates an XEvent session utilizing the 'Trace' event added to SQL 2016
 * This event will capture the protocol negotiation details of all TLS connections
 * This allows you to capture how many connections are being made and with what
 * protocol version and cipher.
 * This information can be used to predict the impact of disabling a given
 * protocol version or cipher suite before taking such actions.
 */

CREATE OR ALTER PROCEDURE usp_get_tls_connection_stats

BobGerman

using Microsoft.IdentityModel.Clients.ActiveDirectory;
using Microsoft.SharePoint.Client;
using System.Security.Cryptography.X509Certificates;

public static class csomHelper {

    private static string ClientId = "<fill in app ID>";
    private static string Cert = "myCert.pfx";                      // Fill in name of your cert file and upload it
    private static string CertPassword = "<fill in cert password>"; // TODO: Explore more secure place for this
    private static string Authority = "https://login.windows.net/<tenant>.onmicrosoft.com/";

celisflen-bers

Python script to convert DBF database file to CSV

• First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
• Then install: sudo python setup.py install

To convert DBF file to CSV:

./dbf2csv database.dbf

bitoiu

Copy the default template of openssl.cnf to a writable location.

cp /System/Library/OpenSSL/openssl.cnf src

Uncomment the req_extensions = v3_req

req_extensions = v3_req # The extensions to add to a certificate request

Add subjectAltName to v3_req section