J.D. Gonzalez jdgonzalez

jdgonzalez / Deploy-SSRSProject.ps1

Created September 13, 2013 14:45 — forked from ChrisMissal/Deploy-SSRSProject.ps1

	#requires -version 2.0
	[CmdletBinding()]
	param (
	[parameter(Mandatory=$true)]
	[ValidatePattern('\.rptproj$')]
	[ValidateScript({ Test-Path -PathType Leaf -Path $_ })]
	[string]
	$Path,

	[parameter(

jdgonzalez / backingMySQLDatabasesToMultipleFiles.sh

Created September 13, 2012 14:40 — forked from msadouni/backup-all-databases-separate-files.sh

Backup all dbs in separate files

	#!/bin/sh
	# Backup all dbs in separate files
	# adapted from
	# http://www.usercore.com/backup-all-mysql-databases-as-seperate-sql-files/
	# use mysqldump5 for MacPorts, mysqldump otherwise

	user='root'
	password='password'

	to='/path/to/backup/folder' # without final /

jdgonzalez / backup.sh

Created September 13, 2012 14:38 — forked from jeremyharris/backup.sh

Quick bash script to backup mysql databases as separate files similar to how MySQL Workbench does

	#!/bin/bash
	#
	# Script to backup all mysql tables as separate files
	#
	# $BACKUP_PATH/<date>/<db_name>/<host>_<table_name>.gz

	# MySQL settings
	MYSQL_USER="root"
	MYSQL_PASS=""
	MYSQL_HOST="localhost"

jdgonzalez / gist:3644236

Created September 5, 2012 20:30 — forked from davesherratt/gist:1408695

mysql radius

	select asciiname,latitude,longitude, acos(SIN( PI()* 40.7383040 /180 )SIN( PI()latitude/180 )
	)+(cos(PI()* 40.7383040 /180)COS( PI()latitude/180) COS(PI()longitude/180-PI()* -73.99319 /180)
	)* 3963.191 AS distance
	FROM allcountries
	WHERE 1=1
	AND 3963.191 * ACOS( (SIN(PI()* 40.7383040 /180)SIN(PI() latitude/180)) +
	(COS(PI()* 40.7383040 /180)cos(PI()latitude/180)COS(PI() longitude/180-PI()* -73.99319 /180))
	) < = 1.5
	ORDER BY 3963.191 * ACOS(
	(SIN(PI()* 40.7383040 /180)SIN(PI()latitude/180)) +