Skip to content

Instantly share code, notes, and snippets.

@AJGarrett
AJGarrett / images.css
Last active September 28, 2017 13:27
MailChimp CSS Hacks
<img style="width: 50%;" class="mcnImage" />
@AJGarrett
AJGarrett / sql-security-audit.sql
Created July 27, 2017 16:23
SQL Security Access Review
SELECT
[UserName] = CASE princ.[type]
WHEN 'S' THEN princ.[name]
WHEN 'U' THEN ulogin.[name] COLLATE Latin1_General_CI_AI
END,
[UserType] = CASE princ.[type]
WHEN 'S' THEN 'SQL User'
WHEN 'U' THEN 'Windows User'
END,
[DatabaseUserName] = princ.[name],
@AJGarrett
AJGarrett / index.js
Created May 13, 2016 11:16
AWS-Lambda-Example
// dependencies
var async = require('async');
var AWS = require('aws-sdk');
//var util = require('util');
// constants
var srcBucket = "staging.s3bucket.com";
var destBucket = "s3bucket.com";
// get reference to S3 client
@AJGarrett
AJGarrett / directive.js
Created June 11, 2013 17:41
ChartJS Directives
angular.module("ITApp").directive('diskspacevisulization', function () {
return {
restrict: 'E',
//template: '<canvas height=\"200\" width=\"200\" id=\"{{dsName}}\"></canvas>',
replace: true,
scope: {
dsdata: '=',
dsName: '@name'
},
@AJGarrett
AJGarrett / Notes
Created June 6, 2013 19:06
Troubleshooting WebApi
Built a log function to turn off/on via web.config
<add key="logRequeststoDB" value="true" />
then add logger to the contoller functions as needed
example:
if (Convert.ToBoolean(ConfigurationManager.AppSettings["logRequeststoDB"].ToString()))
{
new ITEventLog("WebAPI", "Campus/Get?filtertype=" + filtertype + "&filter=" + filter + "&distance=" + distance.ToString()).Save();