Triggers, SPs, and referential integrity are of value if you need and care about data integrity and correctness. For systems most likely to run in public cloud

Triggers, SPs, and referential integrity are of value if you need and care about data integrity and correctness. For systems most likely to run in public cloud: High availability and scalability is valued much more.