Joao Marques @ Data Beyond Ltd – Medium

Joao Marques @ Data Beyond Ltd

Pinned

Joao Marques @ Data Beyond Ltd
in
Level Up Coding

Snowflake vs BigQuery: Clash of Titans (Part 1)

Snowflake and BigQuery are similar in many ways, and one could think it would be an easy and balanced fight between them… but is it though?

Jul 9, 2021

Snowflake vs BigQuery: Clash of Titans (Part 1)

Jul 9, 2021

Pinned

Joao Marques @ Data Beyond Ltd
in
Level Up Coding

What Makes Snowflake So Much Better Than Others

Technical overview of what makes Snowflake the best data platform out there

Dec 28, 2020

What Makes Snowflake So Much Better Than Others

Dec 28, 2020

Joao Marques @ Data Beyond Ltd
in
Level Up Coding

Snowflake vs Redshift Serverless: Is this really the best you got?

After years of using Snowflake, I was “forced” to use Redshift Serverless with proper big data. What did I find?

Mar 16, 2023

Snowflake vs Redshift Serverless: Is this really the best you got?

Mar 16, 2023

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Query Tuning by Example

If you ever get fed up with queries that run for hours… this one’s for you!

Feb 9, 2023

SQL Like a Pro: Query Tuning by Example

Feb 9, 2023

Joao Marques @ Data Beyond Ltd
in
Level Up Coding

If You Really Must Use SQL Distinct…

A Distinct is just like a group by (*)… except when it’s not!

Oct 19, 2022

If You Really Must Use SQL Distinct…

Oct 19, 2022

Joao Marques @ Data Beyond Ltd

Can You Have Too Many Joins? YES!

Joins are databases’ “bread and butter”, but can you actually have “too many” joins? TLDR: yes!

Jun 19, 2022

Can You Have Too Many Joins? YES!

Jun 19, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Please Stop Using Distinct!!

Every time I see a “DISTINCT” I ask the same question: Why??

Mar 27, 2022

SQL Like a Pro: Please Stop Using Distinct!!

Mar 27, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Query Tuning #1

If you ever got fed up with queries that run for hours… this one is for you! #sql #tuning

Feb 14, 2022

SQL Like a Pro: Query Tuning #1

Feb 14, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Window Functions

You probably use window functions already… but have you taken them this far?

Feb 7, 2022

SQL Like a Pro: Window Functions

Feb 7, 2022

Joao Marques @ Data Beyond Ltd

Get Your Data Lineage Out of Snowflake in 2 Minutes… For Free!

Snowflake is just about to release something that looks like nothing, but is kind of awesome! Watch out for Bundle 2021_10.

Jan 16, 2022

Get Your Data Lineage Out of Snowflake in 2 Minutes… For Free!

Jan 16, 2022

Joao Marques @ Data Beyond Ltd

Joao Marques @ Data Beyond Ltd

Just a technical Data Architect having too much fun building new data platforms! Want to support my writing? Why not BuyMeACoffee.com/joao.marques.db

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams