Tag Archive for 'surrogated'

I Dislike Guid As Primary Keys

Add a comment
July 6th, 2009 by Waldar

Damn, I’m currently pushing a small SQL Server application database to an Oracle datawarehouse.
There are guids everywhere, even for a two rows reference table.
This is just so unreadeable and unconfortable to work with.
Try co-working on that kind of database, where you have to dig into the datas to understand them, the design flaws, the weird [...]

Serious , , , , , .

How A Monday Became A Sunday

Add a comment
April 22nd, 2009 by Waldar

Some weeks ago, one client of mine told me something I found really weird.
He told me that he updated the (weekly) day number of a couple of days to have a good count of working days in the month.
In fact, it was a quick and dirty way to take care of something that went in [...]

Datawarehousing , , , , .