Joustie's blog

Nov 20, 2015 - 3 minute read - oracle windows

Oracle External tables over the network

At one of the projects we do for KPN we use Oracle as a database. For some daily batches we use the external tables mechanism to load data from files we receive from another supplier in the chain. The files are in the comma separated values (csv) format like below (I used the Oracle example): 56november, 15, 1980 baker mary alice 09/01/2004 87december, 20, 1970 roper lisa marie 01/01/1999 Oracle can represent this file as a table internally and you can subject it to SQL-queries this way.

Oct 20, 2015 - 3 minute read

Agile methods and technologies for KPN HR-Analytics

This is a translation of the first part of the introduction of my thesis: The need for relevant information to distinguish yourselves from others, making you faster than your competitor, has existed since the creation of the first societies. In the course of recorded history more and more data accumulated in different administrations. Since the advent of the computer and the use of databases, there are all kinds of new possibilities to analyze this data and transform it into useful information.

Oct 20, 2015 - 2 minute read - 8800gs apple chipset imac nvidia overheating reballing

Back to life

A month ago or so I turned on my iMac and something weird happened. The screen stayed black as oil. Reset it and it did actually start to boot, but after a couple of minutes….. bam.. black screen. I could hear the fans still working but the machine died. Did some resets of NVRAM and stuff like that and I was able to boot to the console. Unfortunately, after examining the logfiles I found kernel panics loading the nvidia driver.

Sep 18, 2015 - 1 minute read - emcads encryption enterprise-mobility excitor gon vpn

Go supersecure

At Cloud Seven we endorse the super secure G/On product. It replaces the VPN technology that is commonly used to deliver remote access to the company network to employees. The easy part is you just plug in the USB stick and boot your computer and login, choose your application and it starts automatically and connects to your company’s servers and networks! G/ON USB stick This product was acquired by Excitor in 2012, the creators of DME and integrated G/On in their mobile app as the Appbox feature.

Sep 16, 2015 - 2 minute read - agile docker javascript nodejs os-x webstorm

Developing using Webstorm+Docker+nodejs on OS X and debugging it

First install the latest Docker(I use the Mac version for this tutorial) here: http://docs.docker.com/mac/step_one/ Get Webstorm: https://www.jetbrains.com/webstorm/ Start the Docker Quick start terminal (see screenshot) You’ll start the default docker vm (linux inside OS X).You can find this later by issuing ‘docker-machine ls’:![] Go and download an image inside the docker terminal:Use ‘docker pull ubuntu’To run an interactive shell in the Ubuntu image: use ‘docker run -i -t ubuntu /bin/bash’Of course we also want to mount our home directory: e.

Sep 16, 2015 - 1 minute read - apple osx macos unix

Internet sharing on a Mac

I use a Mitel desk phone which connects to my company’s PBX when working from home. I used to hook it up to my iMac and used internet sharing to make it connect. I tweaked the default network of the internal DHCP server used (to avoid a clash with the 2.0 network at my company) by adding a ‘SharingNetwork’ key to the NAT configuration in /Library/Preferences/SystemConfiguration/com.apple.nat As of Yosemite this ceased to work and I used an extra wire to my switch to connect the Mitel.

Sep 16, 2015 - 1 minute read

Up to speed

Finally an update on my blog for you guys. So let me get you current on developments: I am now officially a Bachelor of ICT! I’m presenting the conclusion from the thesis at KPN soon the code I used for my final assignment is downloadable at https://gitlab.cloudseven.nl:8081/joost/horang visited XebiCon 2015 in May and heard lots of interesting stuff on Agile development visited the Microsoft Techdays and learned lots about Javascript, React and Cloud developments

Jun 22, 2015 - 1 minute read

Done done?

As of last week, all coursework is completed and I have received the following date to attend a session where I have to defend my thesis: 13 juli! Really really almost done!