Skip to content

Instantly share code, notes, and snippets.

View dbafromthecold's full-sized avatar

Andrew Pruski dbafromthecold

134 followers · 0 following
View GitHub Profile
@dbafromthecold
dbafromthecold / docker-compose.yaml
Created December 30, 2019 14:38
Spinning SQL Server 2019 up with docker-compose
version: '3.7'
services:
sqlserver1:
build:
context: .
dockerfile: dockerfile
ports:
- "15789:1433"
env_file:
@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 / 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 / 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 / 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 / sqlserver_pod_eviction_demo.yaml
Last active February 11, 2022 23:02
Deployment yaml for testing a pod eviction in kubernetes
apiVersion: apps/v1
kind: Deployment
metadata:
name: sqlserver2019-deployment
spec:
replicas: 1
selector:
matchLabels:
name: sqlserver2019-pod
template:
@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 / 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-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-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: