bradleykronson’s gists

bradleykronson / test-password-strength.js

Created August 19, 2013 13:58

Test Password Strength

	$('#pass').keyup(function(e) {
	var strongRegex = new RegExp("^(?=.{8,})(?=.[A-Z])(?=.[a-z])(?=.[0-9])(?=.\W).*$", "g");
	var mediumRegex = new RegExp("^(?=.{7,})(((?=.[A-Z])(?=.[a-z]))\|((?=.[A-Z])(?=.[0-9]))\|((?=.[a-z])(?=.[0-9]))).*$", "g");
	var enoughRegex = new RegExp("(?=.{6,}).*", "g");
	if (false == enoughRegex.test($(this).val())) {
	$('#passstrength').html('More Characters');
	} else if (strongRegex.test($(this).val())) {
	$('#passstrength').className = 'ok';
	$('#passstrength').html('Strong!');
	} else if (mediumRegex.test($(this).val())) {

bradleykronson / validate-email-address.js

Created September 18, 2013 09:54

Validate email address

	function checkEmail(emailAddress) {
	var sQtext = '[^\\x0d\\x22\\x5c\\x80-\\xff]';
	var sDtext = '[^\\x0d\\x5b-\\x5d\\x80-\\xff]';
	var sAtom = '[^\\x00-\\x20\\x22\\x28\\x29\\x2c\\x2e\\x3a-\\x3c\\x3e\\x40\\x5b-\\x5d\\x7f-\\xff]+';
	var sQuotedPair = '\\x5c[\\x00-\\x7f]';
	var sDomainLiteral = '\\x5b(' + sDtext + '\|' + sQuotedPair + ')*\\x5d';
	var sQuotedString = '\\x22(' + sQtext + '\|' + sQuotedPair + ')*\\x22';
	var sDomain_ref = sAtom;
	var sSubDomain = '(' + sDomain_ref + '\|' + sDomainLiteral + ')';
	var sWord = '(' + sAtom + '\|' + sQuotedString + ')';

bradleykronson / empty-recycle-bin.sql

Created October 21, 2013 11:21

Empty recycle bin with SQL

	delete from cmsPreviewXml where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from cmsContentVersion where contentId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from cmsDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from cmsContentXML where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from cmsContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from cmsPropertyData where contentNodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from dbo.umbracoRelation where childId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from dbo.umbracoRelation where parentId in (select id from umbracoNode where path like '%-20%' and id!=-20)
	delete from dbo.umbracoDomains where domainRootStructureID in (select id from umbracoNode where path like '%-20%' and id!=-20)
	-- delete the X

bradleykronson / recommend-indexes.sql

Created October 29, 2013 06:04

Recommend indexes based on usage

bradleykronson / HTML5-starter-pack.html

Created November 18, 2013 11:12

HTML5 starter pack

	<!DOCTYPE HTML>
	<html>
	<head>
	<meta charset = "utf-8">
	<title></title>
	<link rel="stylesheet" href="style.css">
	<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
	<!--[if IE]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
	<script src ="script/script.js"></script>

bradleykronson / delete-tables.sql

Created November 28, 2013 19:54

Delete all tables in database

-DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR
-SET @Cursor = CURSOR FAST_FORWARD FOR
-SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'
-FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1
-LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME
-OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql
-WHILE (@@FETCH_STATUS = 0)

bradleykronson / SaveCroppedImage.cs

Last active December 29, 2015 19:19

Crop image from center

	public bool SaveCroppedImage(Image image, int maxWidth, int maxHeight, string filePath)
	{
	ImageCodecInfo jpgInfo = ImageCodecInfo.GetImageEncoders()
	.Where(codecInfo =>
	codecInfo.MimeType == "image/jpeg").First();
	Image finalImage = image;
	System.Drawing.Bitmap bitmap = null;
	try
	{
	int left = 0;

bradleykronson / object-properties.cs

Last active August 29, 2015 13:57

View all the properties of an object

	public static string ReportAllProperties<T>(this T instance) where T : class
	{

	if (instance == null)
	return string.Empty;

	var strListType = typeof(List<string>);
	var strArrType = typeof(string[]);

	var arrayTypes = new[] { strListType, strArrType };

bradleykronson / script-indexes.sql

Created April 8, 2014 14:19

Script all indexes in a database

	SELECT ' CREATE ' +
	CASE
	WHEN I.is_unique = 1 THEN ' UNIQUE '
	ELSE ''
	END +
	I.type_desc COLLATE DATABASE_DEFAULT + ' INDEX ' +
	I.name + ' ON ' +
	SCHEMA_NAME(T.schema_id) + '.' + T.name + ' ( ' +
	KeyColumns + ' ) ' +
	ISNULL(' INCLUDE (' + IncludedColumns + ' ) ', '') +

bradleykronson / delete-old-versions.sql

Created April 15, 2014 12:25

Delete older versions in Umbraco

-/* Delete Old Document Versions */
-Declare @keepOldVersionsCount int, @keepNewerThanDate datetime
-Set @keepOldVersionsCount = 0 /* 0 Keeps published and newest only. */
-Set @keepNewerThanDate = getdate() /* getDate() or '2013-01-01' */
-IF OBJECT_ID('tempdb..#versions') IS NOT NULL DROP TABLE #versions
-SELECT VersionID, nodeId, updateDate, newest, published  INTO #versions

	SELECT migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure_pct ,QUOTENAME(db_name(mid.database_id)) AS [database]
	,QUOTENAME(OBJECT_SCHEMA_NAME(mid.object_id, mid.database_id)) AS [schema]
	,QUOTENAME(OBJECT_NAME(mid.object_id, mid.database_id)) AS [table]
	,'CREATE INDEX [mi_' + SUBSTRING(CONVERT(VARCHAR(64), NEWID()), 1, 8) + ']' + ' ON ' + mid.statement + ' (' + ISNULL(mid.equality_columns, '') + CASE
	WHEN mid.equality_columns IS NOT NULL
	AND mid.inequality_columns IS NOT NULL
	THEN ','
	ELSE ''
	END + ISNULL(mid.inequality_columns, '') + ')' + ISNULL(' INCLUDE (' + mid.included_columns + ')', '') AS create_index_statement
	,migs.*,mid.database_id

Bradley bradleykronson