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 3 months, 3 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 3 months, 3 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...

• This reply was modified 4 months, 2 weeks 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...

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

The technology behind robot vacuum cleaners and lawnmowers owes much to the work of MIT professor (and founder of the company Robust.AI) Rodney Brooks.

Brooks' blog offers a very well informed...

Sometimes as technical people we forget all the other pressures our managers are under - personell issues, purchasing, licensing, vendor management, dealing with departmental managers and higher management. It is...

• This reply was modified 3 years, 7 months ago by  will 58232.

It is only a matter of time until every byte of every disk in the whole world is completely full of pictures of cute cats.

A vehicle is subject to inspection by the relevant safety authorities before it goes on the market. As the "autopilot" is a new thing I expect that the necessary legislation...