Roche's Maxim of Data Transformation

Roche's Maxim of Data Transformation states that should be transformed as far upstream as possible, and as far downstream as necessary. We've all heard this maxim, but what does it actually MEAN?

In this example-packed session Microsoft program manager Matthew Roche explores his maxim, with real-world stories and best practices - all with the goal of helping YOU build a better and more maintainable data estate the first time... or at least the next time.

Feedback link:

Starts: 13:40 11th Mar 2022
Ends: 14:00 11th Mar 2022


Short Description
- As far upstream as possible. As far downstream as necessary. In 20 minutes.

Slidedeck Link

2022-03-11 - SQLBits - Roche's Maxim of Data Transformation.pptx


Matthew Roche


AWSAzureGCPOn PremisesPlatform AgnosticData IntegratorIntelligence and AnalyticsManaging Big DataNoCode Data EngineerNon TechnicalOperational DatabasesSecure and GovernVisualising and Actioning DataDeploymentDevelopingManagingMonitoringModellingOptimisingData LakeData Transformation and IntegrationDatabase EngineModern AnalyticsPower BIIntermediateWhy

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.