The dinosaurs didn't die out. They grew feathers and took to the air.

I find there are a lot of people in management nowadays who have learned statistics in their MBA and are proficient in R.

R dataframes implement the relational model and they...

Can we please, please stop talking about relational data stores?

The relational model is about the logical organization of data. One of the central aims of the model is to ensure...

My go to source for a very well informed and refreshingly sceptical view of artificial intelligence is the blog of Rodney Brooks, former head of the MIT AI Lab: https://rodneybrooks.com/blog/

There are a great many features missing from SQL Server but they are missing from the competition as well and some of the things are integral to SQL so it...

Failure is a great teacher, but the more you see it as the primary way a lot of people learn (or even don't learn), I guess this is what actually...

deleted

• This reply was modified 9 months, 2 weeks ago by will 58232.

Useful if you need to learn DAX. But I think some of this is misleading.

The basis of the relational model is a relation, a mathematical structure that represents a relation...

• This reply was modified 9 months, 2 weeks ago by will 58232.

My point was how you solve serialisable with adequate performance in principle independent of platform, I am well aware of the drawbacks in current methods.

My other point is that concurrency...

Hi Rick,

The MVCC thing is fairly incidental to the book which is great because it is such a clear exposition of the math behind the relational model.

@rick-1071254

The problem with MVCC is that you only see the data as it was at the beginning of the transaction. If performing updates, other data which are relevant to validation...

• This reply was modified 10 months, 1 week ago by will 58232.

@paul-2 White

Excellent post Paul. Snapshot isolation is useful for a consistent (but not up to date) result without locking. RSCI is logically equivalent to MVCC which has the same drawbacks.

Which...

With NOLOCK the data returned can be inconsistent with itself!

This is not acceptable.

The correct solution to this problem is snapshot isolation - no locking and a consistent result as of...

When do we get PostgresQUEL?

although upon hindsight it's obvious that a Roomba will encounter dog poop (my wife suggested dog vomit too) or cat poop, I'd never thought of it.

This may be an example...