We are excited to have Steph Locke talking about Agile Databases and Richard Swinbank showing us ways to orchestrate our ETL in T-SQL. The schedule will be:
18:00 arrival
18:15 ETL orchestration in T-SQL
19:00 Pizza
19:30 Anchor Modelling - Agile Databases
20:30 Close - everyone welcome to join us at the pub afterwards
Talk 1: ETL orchestration in T-SQL
Richard Swinbank
In this session Richard will present a simple approach to orchestrating SQL-heavy ETL processes. We will look at desirable behaviours -- including error handling, diagnosis support, fault tolerance, resume-after-error and parallel processing -- and see how we can obtain these using tools built in pure T-SQL. Not just for ETL developers, there should be something here for anyone with an interest in T-SQL beyond data manipulation.
Bio: Richard is an independent DW/BI consultant specialising in the SQL Server stack. Long experience of inheriting ETL developments in a variety of conditions has given him a strong interest in building fault-tolerant, diagnostic-rich systems. He's particularly interested in using metadata to drive code generation, automate documentation and to reduce human error.
Talk 2: Anchor Modelling - Agile Databases
Steph Locke
Anchor Modelling is a fantastic database modelling paradigm that uses sixth normal form (6NF) to store data and provides third normal form (3NF) views for ease of use.
This session deep dives into all the concepts behind Anchor Modelling (and indeed databases generally!) and then takes you through how Anchor Modelling uses these concepts to move away from the traditional data warehouse paradigm to deliver a purely additive, agile database.
Bio: Steph is the founder of Locke Data, a consultancy in the UK. Her talks, blog posts, conferences, and business all have one thing in common – they help people get started with data science. Steph holds the Microsoft MVP award for her community contributions. In her spare time, Steph plays board games with her husband and takes copious pictures of her doggos.
Note from the organisers: We're always keen to hear from people who may be interested in doing a talk. If you or someone you know would like to present to our friendly audiences, we welcome those looking to gain experience of speaking as well as seasoned pro's. We can discuss/support co-presenting for speakers who prefer to share the limelight, and are happy to run through ideas and draft presentations. Please get in touch at: [masked]!