Recent Articles

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…

Kristijan Berta 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…

Kristijan Berta June 5, 2018

SQL,

SQL on Hadoop, BigQuery, or Exadata. Please don’t call them MPP.

I often hear people referring to SQL engines running against HDFS or object storage as MPP. Strictly speaking this is incorrect. Let me first explain what an MPP database is…

Kristijan Berta May 10, 2018

SQL,

Comparing Window Function Features by Database Vendors

We will round off the series on window functions with comparison of what database vendors offer. There are various mutations of window functions and every vendor supports a different subset…

Jiří Mauritz September 15, 2017

SQL,

Window Function ROWS and RANGE on Redshift and BigQuery

Frames in window functions allow us to operate on subsets of the partitions by breaking the partition into even smaller sequences of rows. SQL provides syntax to express very flexible…

Jiří Mauritz August 22, 2017

SQL,

Redshift's Window Functions Advanced use case – Sessionization

In the last post about the Window Functions, we introduced an advanced use case, in which the window functions help to make the query more readable, simple and efficient. The…

Jiří Mauritz August 14, 2017