Gabriel Marcan

A visit to the Alexandra Township

2010-02-24T23:04:00.004+02:00

Today, on a training course, we were taken to the Alexandra Township (Alex) in Johannesburg. This was related to exploring diversity and sustainable development. It was an interesting and informative experience whereby we had the opportunity to sense and explore the businesses and living standards in the Township.Firstly, if you are reading this blog entry you are likely to be privileged.

Definition for Master Data Management (MDM) and Meta-data (metadata)

2009-05-20T09:07:00.002+02:00

These definitions are my own personal consolidation, interpretation and understanding of all the definitions that I researched and found (see Bibliographies below). These definitions are hence copyrighted and you may use them as long as you give me, and this site - the appropriate credit for compiling them. You agree to do this also to protect the credit of the original authors of these

Orli completed her clamber club term

2008-06-13T15:49:00.001+02:00

100_4250Originally uploaded by gmarcanOrli completed her clamber club term. Well done !

Lessons learned

2008-02-18T23:15:00.001+02:00

ADOBD "Connection Timeout" is in seconds NOT milliseconds. Always check your units !

The Undo for Excel VBA

2007-09-19T13:49:00.000+02:00

VBA Macros in Excel clear the Undo stack. The stack is not easily accessible. The following link provides a Macro undo routine: http://j-walk.com/ss/excel/tips/tip23.htm This might be useful, but what about undoing previous actions when your VB "messes up the undo stack". The following code, which is loosely based on the

Spreadsheets' Auditing Solution

2007-09-02T22:09:00.001+02:00

Spreadsheets' Auditing SolutionThe solution is based on an add-in. Data changes are audited internally on a hidden spreadsheet and then synchronized to a database when the spreadsheet closes (if the connection is available).The solution has the ability to prompt the user to integrate any new spreadsheet created (i.e. on-the-fly integration), but requires locking away the embedded VB code (

My best PPC software (all free but 1)

2007-08-05T23:01:00.001+02:00

Below is a list of the best tools I have come across for my Ipaq 6xxxx (CE 4). It is my personal favorites, which have become an integral part of my daily use of my Ipaq:1. Total Commander - Absolute must: Free, zip and unzip files, built-in editor, edit registry, search function, other stuff.http://www.ghisler.com/ce.htm2. vBar: Free, switch between application, close applications, miniature

simple, hands-on example: pivot tables explained

2007-07-25T16:02:00.000+02:00

This tutorial is short, but must be read word-for-word Introduction: -------------- This short tutorial aims to give you a simple hands-on example of what pivot tables are Pivot tables allow you to report and analyze data. It provides automatic

Testing e2b

2007-07-18T22:10:00.001+02:00

This is an email to blog test

BA

2007-03-17T21:42:00.000+02:00

I am now working in Credit risk, as a BA. I miss the technical engineering side, but this role is forcing me to expand my understanding of the business side. I cannot go into details, but I just want to share that my knowledge expansion includes both academic type of risk management and understanding existing systems.

JDBC - data visualizer

2007-01-23T21:24:00.000+02:00

Connecting to a JDBC database for managing and viewing during debug:With Google I initially found iSQL, but this wasn't very stable. I then downloaded dbvis which is a real pleasure:connection creation wizard with an in-wizard driver loaderTree view, table structures, data views, SQL executor - and lots of other stuff.free, but not open source (EULA) - don't really know why you want to buy a

Hibernate userTYPE

2007-01-18T22:41:00.000+02:00

I am currently developing a J2EE service. I am interacting with ORACLE, its XMLType and HIBERNATE. The lesson for today is that using USERTYPE requires you to specify it as the column type property in the HBM document.You also need to make sure your USERTYPE class support all the variations on the RESAULTSET in (e.g. In mysql pass it as String)

My first post

2007-01-17T22:38:00.000+02:00

Never been a blogger before. Hopefully this blog will help me to store and share my professional experiences.I specialize in SW development and architecture.My goals are to become a guru both in technical and managerial aspects of engineering digital information systems.