Skip to content

Instantly share code, notes, and snippets.

brentmaxwell / array_size.ino
Created December 1, 2022 16:43
quick header array size macro for Arduino
#define ARRAY_SIZE(array) ((sizeof(array)) / (sizeof(array[0])))
brentmaxwell /
Created February 2, 2022 20:11
Convert csv to sc format
import sys
import string
if len(sys.argv) < 2:
print "Usage: %s infile [outfile] [delimiter_char]" % sys.argv[0]
filename_in = sys.argv[1]
brentmaxwell / EmptyGuid.sql
Created January 20, 2022 20:42 — forked from jonsagara/EmptyGuid.sql
Generating Guid.Empty in SQL Server
-- 2021-11-24: suggestion from comments:
SELECT @EmptyEmpty
-- Original
brentmaxwell / search-all-tables.sql
Created January 19, 2022 16:00
Search all tables in a database
DECLARE @SearchStr nvarchar(100) = 'brent'
DECLARE @SearchSchema nvarchar(100) = 'dbo'
TableName nvarchar(255),
ColumnName nvarchar(255),
ColumnValue nvarchar(MAX))
DECLARE @TableName nvarchar(255) = '',
@ColumnName nvarchar(255),
brentmaxwell / Overlapping Dates
Created September 14, 2021 15:26
Overlapping Dates formula
(StartA <= EndB) and (EndA >= StartB)
Let ConditionA Mean that DateRange A Completely After DateRange B
_ |---- DateRange A ------|
|---Date Range B -----| _
(True if StartA > EndB)
Let ConditionB Mean that DateRange A is Completely Before DateRange B
brentmaxwell / myusbgadget
Last active June 1, 2020 14:39 — forked from geekman/myusbgadget
Pi Zero multiple USB gadgets minimal example
#!/bin/bash -e
modprobe libcomposite
cd /sys/kernel/config/usb_gadget/
mkdir g && cd g
echo 0x1d6b > idVendor # Linux Foundation
echo 0x0104 > idProduct # Multifunction Composite Gadget
echo 0x0100 > bcdDevice # v1.0.0

Better SSH Authorized Keys Management

A seemingly common problem that people encounter is how to handle all of your users authorized_keys file.

People struggle over management, ensuring that users only have specific keys in the authorized_keys file or even a method for expiring keys. A centralized key management system could help provide all of this functionality with a little scripting.

One piece of functionality overlooked in OpenSSH is the AuthorizedKeysCommand configuration keyword. This configuration allows you to specify a command that will run during login to retrieve a users public key file from a remote source and perform validation just as if the authorized_keys file was local.

Here is an example directory structure for a set of users with SSH public keys that can be shared out via a web server:

brentmaxwell / ChangeDoubleStraightQuotesToSmartQuotes.vba
Last active November 25, 2019 15:45
Swap smart and straight quotes in Microsoft Word
Sub ChangeDoubleStraightQuotesToSmartQuotes()
With Selection.Find
.Text = """"
.Replacement.Text = """"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
brentmaxwell / GenerateDataDictionary.sql
Created September 9, 2019 16:17
Generate a simple data dictionary for SQL Server; uses the Description extended property.
CREATE PROCEDURE GenerateDataDictionary
SELECT AS ColumnName,
WHEN c.max_length = -1 THEN + '(max)'
WHEN = 'nvarchar' THEN + '('+CAST(ISNULL(c.max_length,0)/2 AS NVARCHAR)+')'
WHEN = 'varchar' THEN + '('+CAST(ISNULL(c.max_length,0) AS nvarchar)+')'
brentmaxwell / gist:4e0239b214f589cc3d80824a4bef8f34
Created May 4, 2016 12:53 — forked from davidnunez/gist:1404789
list all installed packages in android adb shell
pm list packages -f