Skip to content

Instantly share code, notes, and snippets.

View tkarpinski's full-sized avatar

Tod Karpinski tkarpinski

View GitHub Profile

Keybase proof

I hereby claim:

  • I am tkarpinski on github.
  • I am todkarpinski (https://keybase.io/todkarpinski) on keybase.
  • I have a public key ASAUNOlmtJmzY3G0Qo5hpwbJoLXIzzBNMHxi1jjNQ-xt3go

To claim this, I am signing this object:

@tkarpinski
tkarpinski / bigdata-log-query.sql
Last active January 7, 2017 21:05
Migrate Nearline Storage to Coldline storage for Arq Backup on Google Cloud
SELECT
MIN(cast(time_micros as timestamp)) as mi,
MAX(cast(time_micros as timestamp)) as ma,
COUNT(*) as ct,
cs_bucket,
cs_user_agent
FROM [{PROJECTNAME}:storageanalysis.usage]
--WHERE cs_user_agent = 'GCS Lifecycle Management' -- if you only want Lifecycle events
GROUP BY cs_bucket,cs_user_agent
ORDER BY ma DESC
GENERAL
-------
Use real tabs that equal 4 spaces.
Use typically trailing braces everywhere (if, else, functions, structures, typedefs, class definitions, etc.)
if ( x ) {
}
@tkarpinski
tkarpinski / 1025charstring.txt
Created March 16, 2013 13:59
1025 char string - starts with 1, ends with 3, should exclude 3 if truncated at 1024 chars long
1aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa2
@tkarpinski
tkarpinski / github_issues_to_csv.rb
Created April 12, 2012 18:09 — forked from henare/github_issues_to_csv.rb
Exports Github issues to CSV (API v3)
require 'octokit'
require 'csv'
require 'date'
# Github credentials to access your private project
USERNAME="USER_NAME"
PASSWORD="SEKRIT"
# Project you want to export issues from
USER="REPO_OWNER"
PROJECT="REPO_NAME"
@tkarpinski
tkarpinski / CasseteConfiguration.cs
Created February 10, 2012 16:45
Cassette / SignalR integration
public class CassetteConfiguration : ICassetteConfiguration
{
public void Configure(BundleCollection bundles, CassetteSettings settings)
{
//Assuming that you've included the SignalR.Js nuget package this is how you configure
//cassette to correctly order your Scripts and your hub script generated by signalr
bundles.AddPerSubDirectory<ScriptBundle>("Scripts");
bundles.AddUrlWithAlias<ScriptBundle>("http://localhost:50436/signalr/hubs", "signalr-hub", b => { b.AddReference("~/Scripts"); });
}
}
@tkarpinski
tkarpinski / gist:1649302
Created January 20, 2012 20:04
Return JsonResult from Exception on Controller
protected override void OnException(ExceptionContext filterContext)
{
filterContext.Result = Json(new { error = filterContext.Exception.ToString()},JsonRequestBehavior.AllowGet());
}
@tkarpinski
tkarpinski / web.config
Created January 16, 2012 14:43
webconfig for http to https redirect
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<rewrite>
<rules>
<rule name="HTTP to HTTPS redirect" stopProcessing="true">
<match url="(.*)" />
<conditions>
<add input="{HTTPS}" pattern="off" ignoreCase="true" />
</conditions>
@tkarpinski
tkarpinski / EnableLinkedConnections.reg
Created January 5, 2012 16:47
A reg file to EnableLinkedConnections (Network Drives over UAC) http://support.microsoft.com/kb/937624
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"EnableLinkedConnections"=dword:00000001
@tkarpinski
tkarpinski / template.js
Created January 4, 2012 18:11
template for js file using jslint and jquery namespace
/// <reference path="jquery-1.7.1.js"/>
/// <reference path="jquery.namespace.js"/>
/*globals jQuery, window, document*/
///<summary>
///template for new js file in visual studio and jslint
///</summary>
jQuery.namespace('my.namespace');
my.namespace = (function () {
'use strict';