aaronhoffman

// source: https://msdn.microsoft.com/en-us/library/bb259689.aspx
//------------------------------------------------------------------------------
// <copyright company="Microsoft">
//     Copyright (c) 2006-2009 Microsoft Corporation.  All rights reserved.
// </copyright>
//------------------------------------------------------------------------------

using System;
using System.Text;

aaronhoffman

-- more info http://aaron-hoffman.blogspot.com/2017/02/iphone-text-message-sqlite-sql-query.html
select
 m.rowid
,coalesce(m.cache_roomnames, h.id) ThreadId
,m.is_from_me IsFromMe
,case when m.is_from_me = 1 then m.account
 else h.id end as FromPhoneNumber
,case when m.is_from_me = 0 then m.account
 else coalesce(h2.id, h.id) end as ToPhoneNumber
,m.service Service

aaronhoffman

public class SpotifyApiController
{
  //see https://developer.spotify.com/web-api/authorization-guide/#client_credentials_flow
  public void GetClientCredentialsAuthToken()
  {
    var spotifyClient = "";
    var spotifySecret = "";
    
    var webClient = new WebClient();
    

aaronhoffman

static void Main(string[] args)
{
    // read input from local file (could also pass in via args)
    var hexInput = File.ReadAllText("hexInput.txt");

    // convert to binary, strip off first two chars 'Ox'
    var byteArray = StringToByteArray(hexInput.Substring(2));

    // write bytes to file
    File.WriteAllBytes("output.file", byteArray);

aaronhoffman

git config --global diff.tool bc
git config --global difftool.bc.path "C:\Program Files\Beyond Compare 4\BComp.exe"
git config --global merge.tool bc
git config --global mergetool.bc.path "C:\Program Files\Beyond Compare 4\BComp.exe"
git config --global alias.mydiff "difftool --dir-diff --tool=bc --no-prompt"

aaronhoffman

#!/bin/sh
# prevent commit to local master branch

branch=`git symbolic-ref HEAD`
if [ "$branch" = "refs/heads/master" ]; then
    echo "pre-commit hook: Can not commit to the local master branch."
    exit 1
fi

exit 0

aaronhoffman

aaronhoffman

using System;
using System.Collections.Concurrent;
using System.Threading;
using System.Threading.Tasks;

public class ThreadSafeConcurrentDictionary
{
    public bool TryGetValue<TValue>(string key, out TValue value)
    {
        return _dictionary.TryGetValue(key, out value);

aaronhoffman

-- SQL Query to search every guid/uniqueidentifier column in a database for the given id

declare @Id uniqueidentifier = 'ED4D0741-B092-4F0A-9E10-51C19265357C'
-- set to 1 to only search within columns that have '%id%' in the name, for all columns of uniqueidentifier type, set to 0
declare @onlyColumnsWithIdInName bit = 1

declare @Columns table (TableName varchar(200), ColumnName varchar(200))

insert into @Columns (TableName, ColumnName)
select

aaronhoffman

Keybase proof

I hereby claim:

• I am aaronhoffman on github.
• I am aaronhoffman (https://keybase.io/aaronhoffman) on keybase.
• I have a public key whose fingerprint is CA49 A892 C3FF 3F8B 95B4 8309 B693 4228 86D5 7E4F

To claim this, I am signing this object: