Skip to content

Instantly share code, notes, and snippets.

View martic's full-sized avatar

Martin Camp martic

1 follower · 0 following
  • Sydney, Australia
View GitHub Profile
@martic
martic / MachineSetup.ps1
Last active April 13, 2022 02:00 — forked from foshdafosh/MachineSetup.ps1
MachineSetup
#Install WinGet
#Based on this gist: https://gist.github.com/crutkas/6c2096eae387e544bd05cde246f23901
$hasPackageManager = Get-AppPackage -name 'Microsoft.DesktopAppInstaller'
if (!$hasPackageManager -or [version]$hasPackageManager.Version -lt [version]"1.10.0.0") {
"Installing winget Dependencies"
Add-AppxPackage -Path 'https://aka.ms/Microsoft.VCLibs.x64.14.00.Desktop.appx'
$releases_url = 'https://api.github.com/repos/microsoft/winget-cli/releases/latest'
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
@martic
martic / Program.cs
Created August 25, 2021 13:51 — forked from abfo/Program.cs
See https://ithoughthecamewithyou.com/post/reading-and-writing-office-365-excel-from-a-console-app-using-the-microsoftgraph-c-client-api
using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Net.Http.Headers;
using System.Threading.Tasks;
using Microsoft.Graph;
using Microsoft.IdentityModel.Clients.ActiveDirectory;
using Newtonsoft.Json.Linq;
@martic
martic / laptop_boxstarter
Last active June 9, 2021 05:49
#
# Install boxstarter:
# . { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:
# start http://boxstarter.org/package/nr/url?<URL-TO-RAW-GIST>
# OR
# Install-BoxstarterPackage -PackageName <URL-TO-RAW-GIST> -DisableReboots
@martic
martic / gist:9142cf607f13048f56b0cfe5ae48786b
Created March 15, 2021 13:07
#
# Install boxstarter:
# . { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:
# start http://boxstarter.org/package/nr/url?<URL-TO-RAW-GIST>
# OR
# Install-BoxstarterPackage -PackageName <URL-TO-RAW-GIST> -DisableReboots
@martic
martic / education_box_starter.txt
Created March 14, 2021 03:40
#
# Install boxstarter:
# . { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:
# start http://boxstarter.org/package/nr/url?<URL-TO-RAW-GIST>
# OR
# Install-BoxstarterPackage -PackageName <URL-TO-RAW-GIST> -DisableReboots
@martic
martic / closure-table-operations.sql
Created January 13, 2020 04:53 — forked from kentoj/closure-table-operations.sql
Closure Table operations SQL fragments
-- Retrieve descendants
-- ====================
-- retrieve descendants of #4
SELECT c.*
FROM Comments AS c
JOIN TreePaths AS t ON c.comment_id = t.descendant
WHERE t.ancestor = 4;
-- Retrieve ancestors
@martic
martic / boxstarter-remove-windows-preinstalls.ps1
Last active March 10, 2021 07:07 — forked from jessfraz/boxstarter.ps1
Boxstarter Commands for a new Windows box.
#
# Install boxstarter:
# . { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:
# start http://boxstarter.org/package/nr/url?<URL-TO-RAW-GIST>
# OR
# Install-BoxstarterPackage -PackageName <URL-TO-RAW-GIST> -DisableReboots
@martic
martic / 0_upload.lua
Created March 12, 2019 03:30 — forked from flostellbrink/Flash Air Media Uploader.md
FlashAir uploader is a script that iterates over all photos and movies saved on an SD card and uploads them to an HTTP endpoint. Uploaded files are renamed. A tiny node
-- FlashAir Lua script
-- Copy to 'Lua' folder on your SD card
-- Set as RUN_SCRIPT/SD_EVENT in your SD_WLAN/CONFIG file:
-- LUA_RUN_SCRIPT=/Lua/upload.lua
-- LUA_SD_EVENT=/Lua/upload.lua
local httpendpoint = 'http://192.168.1.13:3333/upload'
local folder = '/DCIM'
-- Recursively iterate through directories
@martic
martic / SqlBackupToS3.ps1
Created July 22, 2017 03:30
Powershell Sql Backup To AWS S3
# Needed PS packages
# Install-Package -Name pscx
# Install-Package -Name AWSPowerShell
#
# Scheduling
# The script then needs to be scheduled to run every night, I’m using scheduled tasks for this,
# creating a task that runs nightly and triggers the powershell script by running
# Powershell.exe with the arguments 
# -ExecutionPolicy Bypass C:\SqlBackup\SqlBackupToS3.ps1.
# From <https://www.rhysgodfrey.co.uk/b/blog/posts/backing-up-a-sql-database-to-amazon-s3-using-powershell>
@martic
martic / True Trello Printer
Created June 29, 2017 21:15 — forked from mathiasrw/True Trello Printer
Ever wanted to print your Trello board? Export as JSON and paste it into the code.
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>True Trello Printer</title>
<link href="http://netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet">
<style>
body{margin:15%;}
.panel-body{