Recent Articles

SQL,

Mastering SQL: How to detect and avoid 34+ Common SQL Antipatterns

Overview Are you looking for reasons why your SQL queries are slow or costly. Look no more. This blog post showcases a comprehensive list of 34 SQL antipatterns. Use it…

Kristijan Berta December 6, 2023

SQL,

SQL Challenge: Tackling the Island Problem in Time Series Data

Jump into our SQL Challenge! Today, we're exploring customer loyalty trends. Are you prepared to show off your SQL skills? About the quiz In this SQL pop quiz, we're challenging…

Kristijan Berta November 7, 2023

SQL,

Automatically detect bad SQL. Static and dynamic analysis of SQL code

Preventing Query Catastrophe with FlowHigh SQL Analyser Does the following sound familiar? As the wizard EsQuEl delved deep into the SQL code, he stumbled upon multiple instances where tables were…

Kristijan Berta September 8, 2023

SQL,

Bad SQL. SQL anti patterns in OUTER joins

You often need to find both matched and unmatched rows between two or more tables. As we all know we use OUTER joins in SQL to achieve this. However, there…

Kristijan Berta August 29, 2023

Data Lineage, FlowHigh,

From Code to Clarity: Visualizing SQL code for Documentation and Debugging

In this post we will show you how you can create a visual diagram of your SQL code. We will use the FlowHigh SQL visualiser to achieve this. FlowHigh is…

Kristijan Berta May 29, 2023

SQL antipatterns: SELECT DISTINCT

The DISTINCT operator The DISTINCT operator is used to eliminate duplicates in a resultset, e.g. we can use it to identify the unique number of customers who made a purchase.…

Kristijan Berta August 9, 2022