The guy quotes "Data integrity is 100% paramount, trumping all other concerns, such as performance and scalability." as somewhat of a disadvantage of SQL databases.

Then he goes on to mention that e-commerce orders are examples of things where 100% data integrity isn't needed.

I find that shocking. An ACID-compliant DB engine is essential backup for when customers manage to break your application in ways you never even imagined.