<![CDATA[Stories by Joao Marques @ Data Beyond Ltd on Medium]]> https://medium.com/@jmarquesdatabeyond?source=rss-1afd200bdabf------2 https://cdn-images-1.medium.com/fit/c/150/150/1*KImIYUKqcZJB5O4NyaHnfQ.jpeg Stories by Joao Marques @ Data Beyond Ltd on Medium https://medium.com/@jmarquesdatabeyond?source=rss-1afd200bdabf------2 Medium Sat, 14 Nov 2026 08:24:40 GMT <![CDATA[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?

Continue reading on Level Up Coding »

]]> https://levelup.gitconnected.com/redshift-serverless-is-this-really-the-best-you-got-5b58ebb3c29a?source=rss-1afd200bdabf------2 https://medium.com/p/5b58ebb3c29a Thu, 16 Mar 2023 08:35:24 GMT 2023-03-20T12:15:21.835Z <![CDATA[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!

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/sql-like-a-pro-query-tuning-by-example-2b47b9b6f0e3?source=rss-1afd200bdabf------2 https://medium.com/p/2b47b9b6f0e3 Thu, 09 Feb 2023 07:04:03 GMT 2023-02-09T07:04:03.834Z <![CDATA[If You Really Must Use SQL Distinct…]]>

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

Continue reading on Level Up Coding »

]]> https://levelup.gitconnected.com/if-you-really-must-use-distinct-c1233761baae?source=rss-1afd200bdabf------2 https://medium.com/p/c1233761baae Wed, 19 Oct 2022 05:01:19 GMT 2022-10-26T02:39:59.534Z <![CDATA[Can You Have Too Many Joins? YES!]]>

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

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/can-you-have-too-many-joins-yes-719ceb2291a3?source=rss-1afd200bdabf------2 https://medium.com/p/719ceb2291a3 Sun, 19 Jun 2022 07:03:40 GMT 2022-06-19T19:09:52.909Z <![CDATA[SQL Like a Pro: Please Stop Using Distinct!!]]>

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

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/sql-like-a-pro-please-stop-using-distinct-31bdb6481256?source=rss-1afd200bdabf------2 https://medium.com/p/31bdb6481256 Sun, 27 Mar 2022 09:57:32 GMT 2022-10-23T16:11:18.616Z <![CDATA[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

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/sql-like-a-pro-query-tuning-1-ce6f6b710560?source=rss-1afd200bdabf------2 https://medium.com/p/ce6f6b710560 Mon, 14 Feb 2022 18:13:33 GMT 2022-02-14T18:14:49.742Z <![CDATA[SQL Like a Pro: Window Functions]]>

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

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/sql-like-a-pro-window-functions-9946e4bcee7e?source=rss-1afd200bdabf------2 https://medium.com/p/9946e4bcee7e Mon, 07 Feb 2022 08:50:51 GMT 2022-02-07T08:52:08.443Z <![CDATA[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.

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/get-your-data-lineage-out-of-snowflake-in-2-minutes-for-free-2d9c23d61100?source=rss-1afd200bdabf------2 https://medium.com/p/2d9c23d61100 Sun, 16 Jan 2022 10:19:44 GMT 2022-08-19T09:15:52.224Z <![CDATA[SQL Like a Pro: Looks Do Matter!]]>

Any fresh-out-of-college junior can write SQL that works… but if you want to be a pro, that won’t “cut the mustard”…

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/sql-like-a-pro-looks-do-matter-20fca817f7c9?source=rss-1afd200bdabf------2 https://medium.com/p/20fca817f7c9 Tue, 14 Dec 2021 08:03:07 GMT 2022-02-06T09:39:59.722Z <![CDATA[SQL Like a Pro: How to Write a “For Loop” in SQL]]>

That mind blowing moment when someone just totally changes your understanding of how SQL works

Continue reading on Medium »

]]> https://jmarquesdatabeyond.medium.com/sql-like-a-pro-how-to-write-a-for-loop-in-sql-fcc96559d259?source=rss-1afd200bdabf------2 https://medium.com/p/fcc96559d259 Wed, 01 Dec 2021 08:38:06 GMT 2022-02-06T09:40:29.084Z