Should I put my transformation logic into my SQL query?

Save time with PopSQL. Collaborate on queries with your team, visualize data, and share results. Visit popsql.com/bert for your free 2-week trial.
Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBer...
Related blog post: bertwagner.com/2020/07/29/sho...
Follow me on Twitter:
/ bertwagner

[@MiningForPies]

There’s also a third option, ORMs like entity framework can take advantage of both scenarios, generating on the fly queries that can transform and sort in the DB engine.

[@marcosoliveira8731]

In my scenario I have to deal with a lot of linkedservers sendind large datasets around.
I wonder if , in this case, get data direct to an "transformation app" could deliver fastests results without penalize the servers like it´s done today.

[@zanonilabuschagne7628]

Thanks for the video Bert!!! I'm not 100% sure what the topic was about - was it related to DW ETL/ELT, or OLTP transactions? Either way, thought-provoking :)

[@lunarmodule6419]

Interesting - Thank you

[@kryori]

I was interested, but as soon as there was an advertisement built into the video after I skipped the pre-roll ad I closed the video and will never watch anything from the channel again. Too bad.

[@bimjean1053]

Just skip it, geez