Skip to content

Instantly share code, notes, and snippets.

@ninjatek
ninjatek / .bash_profile
Created February 9, 2016 22:45 — forked from natelandau/.bash_profile
Mac OSX Bash Profile
# ---------------------------------------------------------------------------
#
# Description: This file holds all my BASH configurations and aliases
#
# Sections:
# 1. Environment Configuration
# 2. Make Terminal Better (remapping defaults and adding functionality)
# 3. File and Folder Management
# 4. Searching
# 5. Process Management
#!/bin/sh
# Alot of these configs have been taken from the various places
# on the web, most from here
# https://github.com/mathiasbynens/dotfiles/blob/master/.osx
# Set the colours you can use
black='\033[0;30m'
white='\033[0;37m'
red='\033[0;31m'
@ninjatek
ninjatek / UnixToDatetime.sql
Created January 31, 2011 21:58
Used for converting Java Long entries in SQL 05 to a Datetime friendly format for Reporting from Openfire
/****** Script for SelectTopNRows command from SSMS
SELECT TOP 1000 [sessionID]
,[agentJID]
,DateAdd(s,(cast [joinTime] as int), 1/1/1970)
,[leftTime]
FROM [openfire].[dbo].[fpAgentSession]
******/
SELECT [sessionID]