Skip to content

Instantly share code, notes, and snippets.

View mattjcowan's full-sized avatar

MJC mattjcowan

View GitHub Profile
@mattjcowan
mattjcowan / Windows Defender Exclusions VS 2017.ps1
Created August 17, 2021 20:23
Adds Windows Defender exclusions for Visual Studio 2019
$userPath = $env:USERPROFILE
$pathExclusions = New-Object System.Collections.ArrayList
$processExclusions = New-Object System.Collections.ArrayList
$pathExclusions.Add('C:\Windows\Microsoft.NET') > $null
$pathExclusions.Add('C:\Windows\assembly') > $null
$pathExclusions.Add($userPath + '\AppData\Local\Microsoft\VisualStudio') > $null
$pathExclusions.Add('C:\ProgramData\Microsoft\VisualStudio\Packages') > $null
$pathExclusions.Add('C:\Program Files (x86)\MSBuild') > $null
$pathExclusions.Add('C:\Program Files (x86)\Microsoft Visual Studio') > $null
@mattjcowan
mattjcowan / ormlite-add-attr-issue.csx
Created March 29, 2020 03:13
Ormlite AddAttribute Issue
#!/usr/bin/env dotnet-script
#r "nuget: ServiceStack.OrmLite.Sqlite, 5.8.0"
#r "nuget: ServiceStack.Server, 5.8.0"
using ServiceStack;
using ServiceStack.Auth;
using ServiceStack.Configuration;
using ServiceStack.DataAnnotations;
using ServiceStack.OrmLite;
@mattjcowan
mattjcowan / cloudSettings
Last active March 12, 2021 18:53
VSCode's Settings - Syncing
{"lastUpload":"2021-03-12T18:53:24.702Z","extensionVersion":"v3.4.3"}
@mattjcowan
mattjcowan / sqlserver-linux-backup.py
Created March 31, 2018 17:47 — forked from jniltinho/sqlserver-linux-backup.py
SQL Server command line Backup Linux
#!/usr/bin/env python
# -*- coding: utf-8 -*-
## SQL Server command line backup Linux
## On OpenSUSE 42.2 64Bits
## Author: Nilton OS -- www.linuxpro.com.br
## http://stackoverflow.com/questions/880487/sql-server-command-line-backup-statement
## https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-sqlpackage
## Version: 0.2
### BACKUP SCRIPT SQLSERVER CLI
@mattjcowan
mattjcowan / Readme.md
Created January 4, 2018 21:20 — forked from NickCraver/Readme.md
A simple LINQPad script I wrote for load testing SQL Server.

This is a simple LINQPad script I wrote one day to load test some large SQL servers. Maybe it's useful to someone. The basic premise is defining your queries once, including which ID patterns to fetch (at the bottom), and load test a mixture. The script defines everything needed in one place, then fires up the command-line linqpad runner to run many queries at once.

Params up top:

const string LinqPadPath = @"C:\Linqpad\lprun.exe";
const bool runSequential = false;
const int defaultThreads = 1;
const int defaultIterations = 2000;
@mattjcowan
mattjcowan / ubuntu1604-install-node-v8.sh
Created November 21, 2017 04:54
ubuntu1604-install-node-v8
#!/bin/sh
# SAMPLE USAGE(S)
# ------------------------------
# curl GIST_URL | bash
# OR
# curl -o /tmp/ubuntu1604-install-node-v8.sh GIST_URL
# chmod +x /tmp/ubuntu1604-install-node-v8.sh
# /tmp/ubuntu1604-install-node-v8.sh
# OR
@mattjcowan
mattjcowan / ubuntu1604-install-dotnet-v20.sh
Last active November 21, 2017 05:07
ubuntu1604-install-dotnet-v20
#!/bin/sh
# SAMPLE USAGE(S)
# ------------------------------
# DOWNLOAD_URL=https://raw.githubusercontent.com/mattjcowan/os-install-scripts/master/ubuntu/16.04/install-dotnet-v20.sh
# FILE_NAME=install-dotnet-v20.sh
#
# curl $DOWNLOAD_URL | bash
# OR
# curl -o /tmp/$FILE_NAME $DOWNLOAD_URL
@mattjcowan
mattjcowan / ubuntu1604-startup.sh
Last active April 22, 2019 05:44
Startup script - Ubuntu 16.04 - nvm, node, dotnet core 2.0, nginx w/ self-signed cert
#!/bin/sh
# USE LIKE THIS
# curl GIST_URL | bash
# curl -o /tmp/ubuntu1604-startup.sh GIST_URL
# chmod +x /tmp/ubuntu1604-startup.sh
# cd /tmp/
# ./ubuntu1604-startup.sh
@mattjcowan
mattjcowan / Web_Config.xml
Last active June 30, 2017 05:03
letsencrypt
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<validation validateIntegratedModeConfiguration="false" />
<staticContent>
<clear/>
<mimeMap fileExtension="." mimeType="text/json" />
</staticContent>
<handlers>
@mattjcowan
mattjcowan / RouteParser.cs
Created January 17, 2017 19:40 — forked from wcharczuk/RouteParser.cs
C# Route Parser
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Text.RegularExpressions;
//TODO: probably want to change this if you're using it your project
namespace ClothesHorse.Core
{