relating 2 existing dimensions combined to a fact table
given: * 1 existing sales fact table; > 1.500.000.000 records * 1 existing product dimension; >= 300.000 records * 1 existing store dimensions; >= 1.000 records required: * 3 new attributes, defined by the combination of a certain store an

DVD drive concerns
Is it possible for Windows to be buggy if your DVD drive is defective or not functioning correctly? After I bought my Inspiron 1318 laptop it seems I have nothing but problems. The drive has been struggling to read discs for quite some time. It won't

Thoughts & concerns before Ubuntu install
Hi George, Wanted to put into a post my thoughts and concerns on going to Ubuntu as my main OS. For some time now I ,ve sat on the fence shall I sharn,t I go with Ubuntu when I require to do a reinstall. Well that time is nigh!! Sent for the disc fro

Impact of type 2 dimensions on factless tables
Suppose I have a SCD Type2 dimension participating in a relationship with factlessfact table defining relationship of this dimension with some other dimensions. Any change to this dimension will lead to creation of a new row with new key. So new rows

Football Related 'Pop' Songs
Thanks to Jimmy for reminding me 'how'! Here is 'Kicker Conspiracy' by The Fall, well worth watching for the old football images from the 'eighties even if you hate Mark E Smith, which in itself would be strange.

LastPass possibly hacked, users urged to change master password
It's time to change your passwords again. According to an official announcement on the company's blog, LastPass believes it may have suffered an attack that compromised user data. On Tuesday, the company discovered an unusual traffic spike on one of its

Goya's Disasters of War
I keep on thinking about Goya's Disasters of War, a series of prints from events in Spain, 1808. If you haven't seen them, you might be interested in checking them out. They're full of atrocities and they're quite heartbreaking, but I am glad he made