jdaigle’s gists

HoussemNasri / BalsamiqForever.py

Last active November 18, 2024 18:31

Extend your trial period for Balsamiq Wireframes on Windows and macOS Forever!

	import json
	import os
	import time
	import webbrowser
	import sys
	import re


	def handleWindows(extra_seconds):
	print("OS : Windows")

ErikEJ / IQueryableExtensions.cs

Last active June 14, 2024 19:25

Replacement for EF Core .Contains, that avoids SQL Server plan cache pollution

	using System.Linq.Expressions;

	namespace Microsoft.EntityFrameworkCore
	{
	public static class IQueryableExtensions
	{
	public static IQueryable<TQuery> In<TKey, TQuery>(
	this IQueryable<TQuery> queryable,
	IEnumerable<TKey> values,
	Expression<Func<TQuery, TKey>> keySelector)

LitKnd / sp_indexdetails.sql

Created January 10, 2018 18:38

	/*****************************************************************************
	Copyright (c) 2018 SQL Workbooks LLC
	MIT License, http://www.opensource.org/licenses/mit-license.php
	Contact: [email protected]
	*****************************************************************************/

	USE master;
	GO

	CREATE OR ALTER PROCEDURE dbo.sp_indexdetails (

NickCraver / ExampleUsage.cs

Last active October 16, 2024 02:37

Code to mark a SQL string before it's passed to Dapper.

	public static List<T> Query<T>(this DataContext db, string sql, object param = null, int? commandTimeout = null, IDbTransaction transaction = null, [CallerFilePath]string fromFile = null, [CallerLineNumber]int onLine = 0, string comment = null)
	{
	using (db.Connection.EnsureOpen())
	{
	try
	{
	return db.Connection.Query<T>(MarkSqlString(sql, fromFile, onLine, comment), param, transaction ?? db.Transaction, true, commandTimeout).AsDapperList();
	}
	catch (SqlException ex) when (ex.Is(SqlErrorCode.DatabaseReadOnly_3906))
	{

Sam-Martin / Invoke-KMSEncrypt-Example.ps1

Last active June 16, 2020 17:53

PowerShell Example for using Invoke-KMSEncrypt and Invoke-KMSDecrypt


	# Stolen from http://ctrlf5.net/?p=263 and http://www.dailycoding.com/posts/convert_image_to_base64_string_and_base64_string_to_image.aspx
	function ConvertFrom-StringToMemoryStream{
	param(
	[parameter(Mandatory)]
	[string]$InputString
	)
	$stream = New-Object System.IO.MemoryStream;
	$writer = New-Object System.IO.StreamWriter($stream);
	$writer.Write($InputString);

NickCraver / Windows10-Setup.ps1

Last active August 1, 2024 16:19

(In Progress) PowerShell Script I use to customize my machines in the same way for privacy, search, UI, etc.

	##################
	# Privacy Settings
	##################

	# Privacy: Let apps use my advertising ID: Disable
	Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\AdvertisingInfo -Name Enabled -Type DWord -Value 0
	# To Restore:
	#Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\AdvertisingInfo -Name Enabled -Type DWord -Value 1
	# Privacy: SmartScreen Filter for Store Apps: Disable
	Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\AppHost -Name EnableWebContentEvaluation -Type DWord -Value 0

NickCraver / haproxy.cfg.example

Created May 20, 2015 13:52

HAProxy SSL/TLS Setings for Stack Overflow as of 2015-05-20

	ssl-default-bind-ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA
	tune.ssl.default-dh-param 2048
	tune.ssl.maxrecord 1400

mefellows / ec2-user-data.ps1

Last active May 28, 2021 11:44

Packer Community Plugins - Example Windows 2012 Setup

	<powershell>
	write-output "Running User Data Script"
	write-host "(host) Running User Data Script"

	cmd.exe /c net user /add vagrant FooBar@123
	cmd.exe /c net localgroup administrators vagrant /add

	Set-ExecutionPolicy -ExecutionPolicy bypass -Force

	# RDP

Joseph Daigle jdaigle