Phil Murwin 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.

Setup SSH Authentication for Git Bash on Windows

Prepararation

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

.ssh/config

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

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.

	--=========================================================
	-- SQL Server 2008 apparently has a bug that causes issues when trying to read from XML into a temporary table.
	-- This can be overcome with the simple addition of an option to your query.
	--=========================================================
	-- Additional information can be found at the links below
	--
	-- http://connect.microsoft.com/SQLServer/feedback/details/562092/an-insert-statement-using-xml-nodes-is-very-very-very-slow-in-sql2008-sp1
	-- http://stackoverflow.com/questions/3978807/why-insert-select-to-variable-table-from-xml-variable-so-slow
	--=========================================================

	using Newtonsoft.Json;
	using System.Collections.Generic;
	using System.Data;
	using System.IO;
	using System.Linq;
	using System.Reflection;
	using System.Text;
	using System.Xml;
	using System.Xml.Serialization;

	== Visual Studio .NET 2003 (DO NOT COPY THIS LINE) ==
	Microsoft Visual Studio Solution File, Format Version 8.00
	# Visual Studio .NET 2003
	VisualStudioVersion = 7.1


	== Visual Studio 2005 (DO NOT COPY THIS LINE) ==
	Microsoft Visual Studio Solution File, Format Version 9.00
	# Visual Studio 2005
	VisualStudioVersion = 8.0

	var stringList = new List<string>
	{
	"Ackbar",
	"Amidala",
	"Anakin",
	"Antilles",
	"BB-8",
	"Boba",
	"Bossk",
	"C-3PO",

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

	set @KeyWord = ''

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

	[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