Documents
The Benefits Of Using Python And SQL
The Benefits Of Using Python And SQL
  • The Benefits Of Using Python And SQL To Build Data Pipelines Over No Code Tools
  • Introduction
  • SSIS Is Not Forward Compatible Usually
  • Higher Performance
  • Easier To Develop
  • Easier To Deploy
  • Easier To Maintain
    • Audit Columns On Every Table
    • No OOP In T-SQL
    • Self-Diagnostics
    • Error Notifications
    • Code Versioning With Git
    • Overall Engineering Philosophy
  • So In Conclusion…
  • Wanna Learn How I Develop ETL Processes?
Powered by GitBook
On this page
  1. Easier To Maintain

No OOP In T-SQL

I have seen people try to make T-SQL an object-oriented programming language. What this looks like is stored procedures that call other stored procedures that call views etcetera etcetera ad nauseam. This is an anti-pattern.

Every stored procedure I write is a self-contained process that performs a single task. This kind of process isolation allows for rapid debugging and redeployment of code. Since the process is self-contained, there is only one thing to regression test before pushing the fix to prod.

PreviousAudit Columns On Every TableNextSelf-Diagnostics

Last updated 3 years ago