vsshs

netsh wlan show profile name="INSERT SSID HERE" key=clear

vsshs

git update-index --assume-unchanged Web/css/page.css

git update-index --assume-unchanged Web/js/*.js

** check with 
git ls-files -v | grep ^[a-z]

vsshs

SELECT 
     TO_TIMESTAMP(TO_DATE(date), TO_TIME(time)) AS Timestamp, 
     sc-status as Status, sc-substatus as Sub-Status, cs-method as Method, 
     cs-uri-stem as URL, cs-uri-query as Query, time-taken as Time-Taken-ms
FROM '[LOGFILEPATH]' 
WHERE
     time-taken > 1000
     AND TO_DATE(date) = '2015-12-18' 

vsshs

# Automatically adds branch name to the end of every commit message. Handy for git/JIRA integrations.

# Make a copy of .git/hooks/prepare-commit-msg.sample in your repo and name the file prepare-commit-msg (remove "sample" extension)
# Paste the following into the file, save the file, and try it out in bash

NAME=$(git branch | grep '*' | sed 's/* //') 
echo $(cat "$1") "  in branch: $NAME" > "$1"

vsshs

DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)
SELECT *
FROM <tablename>
WHERE <fieldname> like '%'+@NewLineChar

vsshs

%date{yyyy-MM-dd HH:mm:ss,fff} [%Generic] %level %class - %message