View git-bc.cmd
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"
View git-bc.cmd
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"
View iphone-text-message-sqlite.sql
-- 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
View keybase.md

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:

View KuduWebJobService.cs
public class KuduWebJobService
{
private string KuduUserName { get; set; }
private string KuduPassword { get; set; }
private string AzureWebsiteName { get; set; }
public KuduWebJobService()
{
this.KuduUserName = "";
this.KuduPassword = "";
View email-to-sms.csv
provider emailDomain
AT&T txt.att.net
Verizon vtext.com
US Cellular email.uscc.net
Sprint messaging.sprintpcs.com
T-Mobile tmomail.net
View ky-county-district-map.csv
CountyName District
Adair KY1
Allen KY1
Anderson KY6
Ballard KY1
Barren KY2
Bath KY4
Bell KY5
Boone KY4
Bourbon KY6
View search-db-for-guid.sql
-- 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
View EpochConverter.cs
private static readonly DateTime _epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
public DateTime EpochSecondsToDateTime(int secondsSinceEpoch)
{
return _epoch.AddSeconds(secondsSinceEpoch);
}
View EnumerableExtensions.cs
using System.Collections.Generic;
using System.Linq;
public static class EnumerableExtensions
{
public static IEnumerable<IEnumerable<T>> Batch<T>(this IEnumerable<T> items, int batchSize)
{
return items
.Select((item, inx) => new { item, inx })
.GroupBy(x => x.inx / batchSize)