Discover gists

MSSQL CLI

github...

UI

sqlcmd -S <ip> -d <dbname> -U <username> -P <password> -I

Shaman BiS List

Restoration Shaman

Slot	Name	Source
Head	Sanctified Frost Witch's Headpiece	Vendor
Neck	Blood Queen's Crimson Choker	Blood Queen Lana'thel 25HC
Shoulders	Sanctified Frost Witch's Spaulders	Vendor
Back	Cloak of Burning Dusk	Halion 25HC

javascript:(function(){
  allowCopyAndPaste = function(e){
  e.stopImmediatePropagation();
  return true;
  };
  document.addEventListener('copy', allowCopyAndPaste, true);
  document.addEventListener('paste', allowCopyAndPaste, true);
  document.addEventListener('onpaste', allowCopyAndPaste, true);
})();

Docker on Lima (lima-vm/lima) Setup Guide

In recent months, Lima has become de facto standard software as a free and open source alternative to Docker Desktop for Mac. Several projects (such as Colima, Rancher Desktop, or Finch) for similar purpose also uses Lima as their backend. These projects will make it easier to set up Lima. But some people may not want to introduce extra components other than Lima. This guide will show you how to set up Lima to be alternative to Docker Desktop for Mac, while using Lima only.

🪣 Note. It is a good practice to uninstall Docker Desktop for Mac before proceeding with the following steps.

1. Install Lima and Docker CLI

Some hosting providers like scaleway allows to remove the IPv4 from the VPS in order to save 1€/month but doing this will result in losing connectivity to the "IPv4 world".
Or you may have ordered a VPS that only has IPv6 connectivity and you want to access to a resource only accessible from the "IPv4 world".
Here is how to gain your access back to the "IPv4 world".

Change your name servers(s) to DNS64 name servers(s)

Note: You may deploy your own DNS64 & NAT64 server on a separate server by following this tutorial (untested): https://packetpushers.net/nat64-setup-using-tayga/.
Note²: You may find a explanation of what is NAT64 and DNS64 on Wikipedia.

Choose a/multiple DNS64 public server(s) that has/have its own NAT64 public service from this list:

How to create a self-signed SSL Certificate with SubjectAltName(SAN)

After Chrome 58, self-signed certificate without SAN is not valid anymore.

Step 1: Generate a Private Key

openssl genrsa -des3 -out example.com.key 2048

	{% comment %}
	*
	* This loop loops through a collection called `collection_name`
	* and sorts it by the front matter variable `date` and than filters
	* the collection with `reverse` in reverse order
	*
	* To make it work you first have to assign the data to a new string
	* called `sorted`.
	*
	{% endcomment %}

	function Find-VisualStudio() {
	Write-Information "Finding VisualStudio .exe path"
	$vsWherePath = join-path ${env:ProgramFiles(x86)} "\Microsoft Visual Studio\Installer\vswhere.exe"
	Write-Debug "Checking for vswhere.exe at $vsWherePath"
	if (-not (Test-Path $vsWherePath)) {
	Write-Error "vswhere.exe not found at $vsWherePath"
	exit 1
	}

	Write-Debug "Finding VisualStudio Installation Location using:"

	import "dotenv/config";
	import { OpenAIEmbeddings } from "@langchain/openai";
	import { TextLoader } from "langchain/document_loaders/fs/text";
	import natural from "natural";
	import * as math from "mathjs";
	import { quantile } from "d3-array";

	interface SentenceObject {
	sentence: string;
	index: number;

	## Thanks to https://twitter.com/JNP7771 for the script at https://playcode.io/780618/

	## imports
	import requests
	import json
	import pandas as pd
	import math
	from beautifultable import BeautifulTable

	x96 = math.pow(2, 96)