How to reign in the Wild West that is the Database Development Lifecycle, both culturally and technically, by using native automated SQL unit testing. In an environment where the application development lifecycle has advanced to where development teams can release changes into production tens, hundreds or even thousands of times a day, database development remains the proverbial red-headed stepchild. The challenges of bringing database development into the DevOps world are just too, well, challenging, for many to attempt – so they relegate database development to second class, a necessary evil, a burden that must be borne. At Standard Bank CIB we have developed a DevOps pipeline for our Risk Data Platform that is capable of delivering data warehouse changes into production with sub 24-hour lead times. To do this we had to solve a number of technical issues, but most importantly, we had to effect a massive change in our development culture. In this session you will: Get a peek at our Database DevOps Pipeline, Hear what the technical and cultural problems were that we faced, Learn how we used various quality controls, including automated SQL Unit Testing to solve them, Get an introduction to the unit testing framework that we use, and See how easy it is to build unit tests in SQL.
February 28 @ 09:45
09:45 — 10:30 (45′)