I'm an independent DW/BI consultant specialising in the SQL Server stack. Long experience of inheriting ETL developments in a variety of conditions has given me a strong interest in building fault-tolerant, diagnostic-rich systems. I'm particularly interested in using metadata to inform process control, drive code generation, automate documentation and to reduce human error.
Richard Swinbank has submitted 3 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Writing boilerplate T-SQL for ETL is time-consuming, boring and error-prone. In this session we'll look at some basic dynamic T-SQL before supercharging it with metadata to generate (and re-generate) a variety of ETL components in T-SQL.
Documentation has never been this much fun! In this session we'll be building informative visualisations of ETL pipelines and SQL Server database diagrams, then automating it to describe large and complex systems in an easy-to-navigate way.
In this session we'll look at ETL metadata, use it to drive process execution, and see benefits quickly emerge. I'll show how a metadata-first approach reduces complexity, enhances resilience and allows ETL processing to become self-organising.

Sessions