Raspberry Pi Installation

– download Raspbian Stretch Lite (2017-09-07-raspbian-stretch-lite.zip) from https://www.raspberrypi.org/downloads/raspbian/
– download Win32 Disk Imager (win32diskimager-1.0.0-install.exe) from https://sourceforge.net/projects/win32diskimager/files/Archive/

CertUtil -hashfile 2017-09-07-raspbian-stretch-lite.zip SHA256
SHA256-Hash der Datei 2017-09-07-raspbian-stretch-lite.zip:
bd 2c 04 b9 41 54 c9 80 4c c1 f3 06 9d 15 e9 84 c9 27 b7 50 05 6d d8 6b 9d 86 a0 ad 4b e9 7f 12
CertUtil -hashfile win32diskimager-1.0.0-install.exe MD5
MD5-Hash der Datei win32diskimager-1.0.0-install.exe:
be 92 e7 6b aa bc 97 b3 f0 93 ff 73 4d d3 f7 5b

– start Win32 Disk Imager…

– release and reconnect the MicroSD card (it comes a partition „boot“)
– in partition „boot“ create a file with name „ssh“ (content does not matter)
– also in partition „boot“ create a file with name „wpa_supplicant.conf“ (use program Notepad++ for correctly format)…

ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev


– the files „ssh“ and „wpa_supplicant.conf“ will always deleted during boot
– in our case we configure the DHCP by mac address (she starts with B8:27:EB)
– put the card into the Raspberry Pi and connect the power supply
– after 30 seconds join the computer with Putty (username „pi“, password „raspberry“)

we are working work in Putty from now on

sudo passwd root
sudo passwd pi
sudo vi /etc/network/interfaces

auto wlan0
        iface wlan0 inet dhcp
        wpa-conf /etc/wpa_supplicant/wpa_supplicant.conf
        wireless-power off

sudo vi /etc/rc.local

/usr/bin/tvservice -o
exit 0

sudo vi /boot/config.txt


– use sudo vi /etc/ssh/sshd_config and configure Port, X11Forwarding and AllowUsers
sudo systemctl restart ssh

see also: Running on Raspberry Pi + Raspberry Pi Documentation

Spring Boot + Heroku

– Download heroku-cli-win64.exe
– Installation without GIT (it was installed in version 2.9)
– First command „heroku login“ in starts 12MB update

C:\Temp>heroku --version
heroku-cli/5.12.0-211263f (windows-amd64) go1.7.5

– heroku create
– project demo-spring-heroku changed to JDK umgestellt (for „mvn install“ to work)
– Eclipse/Run as: maven clean
– Eclipse/Run as: maven install

mkdir app
cd app
git init
xcopy /s /y c:\Spring\git\spring-boot\demo-spring-heroku .

– heroku local web
– Ctrl+C
– git add .
– git commit -m „First upload“
– git push heroku master
– heroku ps:scale web=1
– heroku logs –tail


„If you need to convert files from one markup format into another, pandoc is your swiss-army knife.“

The Joel Test

Our current rating for the The Joel Test: 12 Steps to Better Code.

Do you use source control?
Can you make a build in one step?
Do you make daily builds?
Do you have a bug database?
Do you fix bugs before writing new code?
Do you have an up-to-date schedule?
Do you have a spec?
Do programmers have quiet working conditions?
Do you use the best tools money can buy?
Do you have testers?
– Do new candidates write code during their interview?
– Do you do hallway usability testing?

SQL-Abfrage zu XML-Datei

Das tägliche Abfrageergebnis als XML-Datei schreiben. Die Spalte „erstellt“ enthält Datum und Uhrzeit von der Datensatzanlage.

@echo off
set jahr=%date:~-2%
set monat=%date:~-7,2%
set tag=%date:~-10,2%
bcp "select t1.* \
  , convert(date, dateadd(day, -1, '%tag%.%monat%.%jahr%'), 104) as exportkey \
  from db..table t1 \
  where convert(date, [erstellt]) = dateadd(day, -1, '%tag%.%monat%.%jahr%') \
  order by [erstellt] desc \
  for xml auto, TYPE, ELEMENTS, ROOT('rows')" \
  queryout c:\Temp\rows_%jahr%%monat%%tag%.xml -S (local) -T -w