Metadata driven development
Track: Application & Database Development
The longer I've been coding, the less time I want to spend coding - at least, the boring, repetitious bits. In this talk, I'll share the approaches I've used to systematically generate SQL artifacts based on metadata and templates.
The approach is basic: Get data. Process through some templating engine. Collect output.
The specifics scenarios we'll cover
* Biml/C#: we'll build SSIS packages, tables and stored procedures
* Python: we'll use pyratemp to build tables and CLR stored functions
* Versioning: Version your templates and your data