Back to Basics - The Burden of Proof
There's a reason we don't just lump all of our data into Excel, Word and other such tools. Databases exist to give rigour to our data. They are the "statement of record" - the proof that our applications are meeting any business and/or regulatory requirements. The data stored in the database is typically the evidence that we provide to auditors and legal representatives that we are not breaking any rules. But are you sure that your data will pass an audit? In this episode, I examine a real customer example - a customer that thought they were meeting all of their legal requirements, only to hit a firestorm when an audit of the database suggested otherwise. Achieving a correct ordering of transactions whilst still allowing high concurrency is an often overlooked issue. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.