{"id":205,"date":"2019-08-21T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/the-collaboration-commission-part-5"},"modified":"2026-03-18T21:53:32","modified_gmt":"2026-03-18T21:53:32","slug":"the-collaboration-commission-part-5","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2019\/08\/21\/the-collaboration-commission-part-5\/","title":{"rendered":"The Collaboration Commission \u2013 Part 5 – SQL Hammer"},"content":{"rendered":"

Architecture choices for cultural factors<\/h2>\n

\"\"\"\"<\/p>\n

I was having a discussion with one of my team members. He questioned some of our early decisions which predated his involvement on the project. I began to give him a bit of history of the choice and realized, while I was explaining, that some of the benefits were never realized. We made other choices which limited our ability to leverage those benefits and over complicated certain areas which eliminated efficiency gains which were expected.<\/p>\n

This particular example related to a set of templatized ETL integration jobs. We took concepts of code re-usability and modular design, which are good practices, and wielded them like silent weapons to carve out smaller scopes of responsibility.<\/p>\n

Our team\u2019s imbalance of responsibility can be seen in our templates which turned into a way for engineers to minimize their scope of work to guarantee success while burdening the heroes with the responsibility of the common components and overall functionality of the templates.<\/p>\n

This created an environment where no one ever felt 100% responsible for the successful execution of their own integration, in the production environment. Development decisions based on team pain-points brings the risk of blending cultural or managerial issues into the technical choices.<\/p>\n

\"\"\"\"<\/p>\n

In part 2 of this series<\/a>, I wrote about the need for design reassessment after walking down a path of incremental change. Our current reality is a Frankenstien\u2019s monster compared to the original vision of the templates and has caused a large portion of the team to not even understand how the processes run. Others, such as the person whom I was speaking to when I realized this, were wondering why we are making our own lives so hard when simpler methods are readily available.<\/p>\n

Series index<\/h2>\n