Single source of truth in one place is a paradigm that has scuppered many an EDW project.  Once an organisation gets beyond a certain scale you are on a hiding...

If I was worried about disk space then I'd be asking how I could determine the amount of disk space required through automated means. Similarly could I predict locking/blocking impact...

The ridiculous thing is that the cost of peoples time arguing why you shouldn't have a RAM upgrade far exceeds the cost of that RAM upgrade.
The cost of nursemaiding...

Given the variability of the preferences this could be an example of where a good Document DB would fit.
Of course if youvyo got the in-house skills to keep an...

For all there faults RDBMS's have been tested pretty damn thoroughly over the past decades.  That testing has been in the real world rather than isolated to academia and in...

I think triggers work particularly well when used as a pattern.  An example would be to maintain Type 4 slow changing dimensions.
I've also used them on tables representing a...

I went to a presentation that gave the opinion that technology is moving so fast that in a 4 year Computer Science degree the stuff you learn in the 1st...

If you are going to take on a junior then as far as I am concerned you are duty bound to be that person's point of contact and mentor.

I'm not clear what this syntax adds over the old WITH ROLLUP and WITH CUBE?  Is it a more ANSI compatible version of the same thing?

Excellent points Hakim.
I feel for anyone who has to deal with the bloody minded bureaucracy when dealing with a bereavement.  There is a lesson here for all parents and...

I take my hearing aids out when in the office. Our desks are capital I shaped so you can see the guy sitting next to you in the eye and...

I stopped watching Formula one motor racing a long time ago.  The microanalysis of performance had resulted in cars that made overtaking almost impossible and only a mistake in the...

Yes I have had many technical victories but as someone with Aspergers the best days have always involved success with other people. I've been extremely fortunate in the colleagues I have...