Looking at this I feel that the example starts off denormalised.  Rather than have a guide with a language attribute and a team with a language attribute I would have

I've tried this on MySQL with similar results.

As a homage to Jeff Modem I created a tally table with as least as many number as the longest string...

Of course, it failed that basic "Turing Test" by asking me why I wanted to know instead of answering the question and the directive I gave it of "Just answer...

I expect the problems from AI to be the social fallout from the change in employment hits.
In the UK we got a forewarning of this during the late 1980s/early...

I've worked on a big personalisation project that produced a distance score between 250,000 products for 5 million customers.  That was 1.25 trillion records generating 37TB of scoring data.
The capabilities...

Even the successful inventors get treated badly.  Christopher Cockerell wasn't even allowed to pilot his hovercraft and didn't get much from his invention.

Take a look at http://www.telegraph.co.uk/technology/5158972/Starlite-the-nuclear-blast-defying-plastic-that-could-change-the-world.html...

There are still some poorly designed user interfaces that make handling long filenames difficult.  Apart from that there's nothing much apart from habit that keeps this going.
The max...

Quite enjoyed building an ETL framework using Python and Apache Spark.
Doing loads with Pandas, HP Vertica & RedShift.

The one I'm most enthusiastic about is encouraging colleagues to...

Once you've worked in a large hierarchical structure you realise that hell isn't fire and brimstone, it's being teased for ever with the promise that a simple decision with an...

I've spent some time reading a summarised version of the GDPR regulations.  These regulations give HUGE levers to those of us who favour doing things properly.  I think it is...

I've been asked to provide a high level architectural design for a system.
I've also been set DB scenarios as interview questions but haven't been asked explicitly for a DB...

I found that the brittleness in replication is due to the complexity and flexibility of the facility.  The brittleness was more down to inadvertent misconfiguration than an inherent problem with...

I wish I could find the blog post that addresses business logic in databases.
The gist of the article was that "Business Logic" was too broad a term to have...

I use AWS RedShift on a daily basis which is based around PostGres 8.  I like the reduced DBA headaches but there is nothing like using another DB to make...