ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server

Harry Dragstra

While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the 2 other ETL processes (transformation and load) can be configured and administered with more flexibility, providing an almost acceptable level of […]

R: Utilizing multiple CPUs

Maarten Smeets

R is a great piece of software to perform statistical analyses. Computing power can however be a limitation. R by default uses only a single CPU. In almost every machine, multiple CPUs are present, so why not utilize them? In this blog post I’ll give a minimal example and some […]

Change UUIDs in VirtualBox

Patrick Barel

If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualbox for different purposes. Like running an Oracle 11 Devdays instance as test environment but also running the same vbox for customer testing. If you […]

Programmatically extract key and value from Windows registry using simple Dos command line statement

Lucas Jellema

The Windows Registry can be inspected from a Dos (Command Prompt) command. The key and data element I was looking for is: Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\chrome.exe Data Name: Path The OS command we can use to extract the value of this entry: REG QUERY “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\chrome.exe” /S /v Path The […]