I've come across only a few real situations where there is a genuine advantage in using a non-relational datastore compared to a relational data store. The usual "advantages" touted tend...

Nice question. I got it wrong, but it does make (implementation) sense that var tables are not affected by transactions.

A nice tricky one. Although I got it correct through eliminating out the other options and looking suspiciously at the C1 column rather than matching the answer straight away.

I agree... although these risks have been there with slowly modified varieties as well it's just accellerated in this form. It's also the insanity of the GM companies that seem...

Over population will be a problem eventually but it shouldn't be a problem for a quite a lot of years / generations. Limits to over population are societal (both procreation...

Interesting comments about dates... although if you think about it - all dates are weird.

What is important to consider though is that for an international website it is...

Ouch my head. I really, really hate the date hacks that are required in MS-SQL for otherwise relatively simple (in concept) date manipulations. I do have cause to use quite...

In my experience EF and ORMs are just another tool and like any tool they can, and unfortunately are, often used to advantage and disadvantage.

In general, the simpler...

That CROSS APPLY with VALUE is a neat solution - and rather better than mine particularly where I got the OwedBy and OwedTo sum around the wrong way 🙂 Easy...

Agreed, however current mainstream Operating Systems such as Microsoft Windows just are not up to the task of such finely grained administrative level access. This is largely due to the...

This topic has certainly produced some interesting comments however I really can't disagree strongly enough with the "purist" mind frame that one solution, technique or algorithmic aim will solve all...