Archives

Table partitioning is a complex but useful concept. Read this post to better understand partitioning, why you need partitioning and the steps you need for PostgreSQL, BigQuery and MS SQL Server [...]

Although there are many NoSQL database systems that work directly with the JSON format, those who are used to work with RDBMS would love to be able to manipulate their JSON formatted data stored [...]

One of the most basic clauses in any SQL dialect is the GROUP BY. Anyone who interacts frequently with relational databases has for sure used this clause thousands of times in order to compute [...]

What is an SQL Window Function? This is part #7 of our SQL blog post and it is an introduction with easy to use examples to get started with it.

Whoever who has ever written code in any language would agree that date and time data types are the most frustrating of all. Of course SQL is not an exception. Each SQL dialect has its own [...]

How can I effectively organize my SQL query code to further reuse? In their everyday life, many people use SQL to construct queries that they are going to reuse at some point. But how do these [...]

Pattern matching over strings in SQL is a frequent need, much more frequent that some may think. Queries aren’t just for compiling demanding aggregate calculations, advanced joins and table [...]

While in an ideal world each column in a database table has a suitably chosen data type, in this non-ideal place we live in, having stored dates in a wrong format, is a problem that the majority [...]

All of us have at some point worked with some spreadsheet software, like Excel or Google Sheets, or BI tools and we have to admit that they offer certain functionalities that are very handy when [...]