SQL transactions might seem easy. But most databases have a hidden complexity causing your data to be silently corrupted. If you don't know about it - eventually it will take down your systems and leave you unable to resolve the issues. The problem is that most are not aware of SQL transaction isolation level.