PhilMurwin

How to use Namecheap DynDNS service with ddclient on the Raspberry Pi

Log into your Raspberry Pi (by ssh for example) or open a terminal window if you are working directly on Pi. In the first step we have to install ddclient, a DynDNS software, on the Pi. For this purpose, the following two commands are necessary.

sudo apt-get update
sudo apt-get install ddclient

Note: During installation an installation wizard opens and wants to know some things from you. Here you can safely enter what you want, because we have to adjust the configuration file manually either way, because the wizard does not support the Namecheap.com interface.

PhilMurwin

Setup SSH Authentication for Git Bash on Windows

Prepararation

0. Create a folder at the root of your user home folder (Example: C:/Users/uname/) called .ssh.
1. Create the following files if they do not already exist (paths begin from the root of your user home folder):

• .ssh/config

PhilMurwin

declare
	@KeyWord  varchar(128),
	@KeyWord2 varchar(128) = null
set nocount on

set @KeyWord = ''

--=========================================================
-- Temp Tables
--=========================================================

PhilMurwin

Environment > Keyboard > Query Shortcuts

• Create a Dev database to contain some server level procedures
• Create a stored proc SPWHO with the sp_who2 script in it.
  • This is used for Ctrl + 3 below

Shortcut	Stored Procedure
Alt + F1	sp_help
Ctrl + F1

PhilMurwin

Configure Synology NAS as Git Server

Instructions for setting up a git server on a Synology NAS with Diskstation. Specifically, I am using a DS218+ with DSM 6+.

Set Up User group and Folder

• Create group gitusers via Diskstation interface (with File Station and WebDAV privilages)
• Add new shared folder called Git (located at /volume1/Git) with read/write access for group gitusers. This folder will hold all the repos.

PhilMurwin

[core]
	editor = \"C:/Program Files (x86)/Programmer's Notepad/pn.exe\"
	autocrlf = true
[merge]
	tool = winmerge
[mergetool "winmerge"]
	cmd = wMerge.sh \"$MERGED\" \"$REMOTE\"
	path = c:/Program Files (x86)/winmerge/winmergeu.exe
[diff]
	guitool = winmerge

PhilMurwin

Declare @sp_who2 Table
(
	SPID		INT
	,Status		VARCHAR(255)
	,Login		VARCHAR(255)
	,HostName	VARCHAR(255)
	,BlkBy		VARCHAR(255)
	,DBName		VARCHAR(255)
	,Command	VARCHAR(255)
	,CPUTime	INT

PhilMurwin

h2. Summary of Request:
Brief description of request that all stakeholders can agree to.

h2. Details of Request:
Customer list of the things necessary to accomplish the end result.

h2. Affected Components:
What existing components are impacted by this request?

h2. Work Involved:

PhilMurwin

/* ################################################################################ 
# AUTHOR  : 	Markus Kofler - http://www.kofler-it.com
# NAME	  : 	countries-for-mssql.sql
# DATE    : 	2015-06-21
# Version : 	1.0
# COMMENT : 	This script creates a table within your MS-SQL-Server with all
#	    	the ISO-codes for countries, phonecodes, etc.
#	    	The script is based on the following github-resources:
#		   + https://gist.github.com/adhipg/1600028
#		   + https://gist.github.com/paulochf/9616f85f3f3904f1c36f

PhilMurwin

Using Git

Global Settings

Related Setup: https://gist.github.com/hofmannsven/6814278

Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/