Command Query Responsibility Segregation

Olivier gives us some insights about CQRS: what is it? How does it work? What are its pros & cons?