Skip to content

Instantly share code, notes, and snippets.

View dbafromthecold's full-sized avatar

Andrew Pruski dbafromthecold

View GitHub Profile
@dbafromthecold
dbafromthecold / sql_server_images.txt
Last active September 5, 2023 09:45
Microsoft SQL Server Container Images
2017-CU1-ubuntu
2017-CU10
2017-CU10-ubuntu
2017-CU11
2017-CU11-ubuntu
2017-CU12
2017-CU12-ubuntu
2017-CU13
2017-CU13-ubuntu
2017-CU14
@dbafromthecold
dbafromthecold / vwmare_pacemaker_sqlserver.sh
Last active October 29, 2022 11:06
Creating a VMWare pacemaker cluster to run SQL Server Availability Groups
######################################################################################################################
#
# Creating a pacemaker cluser and availability group on VMWare Virtual Machines - Andrew Pruski
# @dbafromthecold
# dbafromthecold@gmail.com
#
######################################################################################################################
# Installing SQL Server
######################################################################################################################
@dbafromthecold
dbafromthecold / mssql-cli-ubuntu-22.04
Last active January 14, 2024 12:10
Installing the mssql-cli on Ubuntu 22.04
#######################################################################################################
#
# How to install the mssql-cli on Ubuntu 22.04 running python 3.10
#
# This is pretty hacky so please only do this on dev/test servers
#
# The first few steps here will also get the mssql-cli working on Ubuntu 20.04 (running python 3.8)
#
#######################################################################################################
@dbafromthecold
dbafromthecold / index.html
Created January 30, 2022 16:11
Index.html file for Reveal Presentation in Github Pages
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<title>Test Presentation</title>
<link rel="stylesheet" href="dist/reset.css">
<link rel="stylesheet" href="dist/reveal.css">
@dbafromthecold
dbafromthecold / vimrc
Last active October 31, 2022 14:25
My vimrc file
"vim generic settings
set number
set nocompatible
set backspace=indent,eol,start
set nowrap
set nobackup
set noswapfile
set noundofile
@dbafromthecold
dbafromthecold / main.go
Last active May 15, 2021 11:55
SqlContainerFromScratch
package main
import (
"fmt"
"io/ioutil"
"os"
"os/exec"
"path/filepath"
"strconv"
"syscall"
@dbafromthecold
dbafromthecold / azure-sql-edge-persistent.yaml
Created December 6, 2020 11:00
Azure SQL Edge with persistent volume claims
apiVersion: apps/v1
kind: Deployment
metadata:
name: sqledge-deployment
spec:
replicas: 1
selector:
matchLabels:
app: sqledge
template:
@dbafromthecold
dbafromthecold / azure-sql-edge-pvc.yaml
Last active December 6, 2020 13:37
Persistent Volume Claims for Azure SQL Edge
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
name: sqlsystem-pvc
spec:
volumeName: sqlsystem-pv
accessModes:
- ReadWriteOnce
resources:
requests:
@dbafromthecold
dbafromthecold / azure-sql-edge-pv.yaml
Created December 6, 2020 10:47
Persistent Volumes for Azure SQL Edge
apiVersion: v1
kind: PersistentVolume
metadata:
name: sqlsystem-pv
spec:
capacity:
storage: 1024Mi
accessModes:
- ReadWriteOnce
nfs:
@dbafromthecold
dbafromthecold / azure-sql-edge.yaml
Created November 30, 2020 11:43
Yaml file to deploy Azure SQL Edge and expose with a load balanced service
apiVersion: apps/v1
kind: Deployment
metadata:
name: sqledge-deployment
spec:
replicas: 1
selector:
matchLabels:
app: sqledge
template: