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...

I have experienced many application rewrites and replatforming over my career. Very few down to obsolescence, most down to the app being replaced having descended into a big ball of...

You mean human beings accessing accounts they shouldn't using tools the shouldn't be using in a manner that has not been authorised?  There is legitimate monitoring software to provide governance...

I heard Simon Munroe's presentation when SQL Bits was held in Westminster.  At the time I asked if NOSQL should really be NORDBMS and was told no.  Now that so...

I find that ORMs are like all tools.  Used properly they work as intended.  I've only seen them used properly in demonstrations, never in real life.

I always think...

I got on fine with SSMS.  I disliked having to skip across to BIDS to do stuff.  I meant to use the Red-Gate SSMS plug-in project to see if I could...