Recent Articles

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…
Uli Bethke November 7, 2023
SQL,

Detect Bad SQL with Static & Dynamic Code Analysis – A Guide

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…
Uli Bethke September 8, 2023
SQL,

Avoid SQL Anti-Patterns – OUTER Joins & Anti Joins Explained

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…
Uli Bethke August 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.…
Uli Bethke August 9, 2022

Converting and Masking Connexo XML to a database (MySQL)

In this post we will show you how obfuscate XML data and convert it to a tabular format. We will use XML documents from Connexo NetSense and convert it to…
Maciek August 13, 2019
SQL,

Converting Financial Information eXchange XML (FIXML) to MS SQL Server

FIX is a messaging standard used for trades in the financial services industry. The FIX Trading Community is the independent body behind the FIX messaging standard. FIX messages are encoded…
Maciek June 5, 2018
spinner