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 [...]
For some time now I was looking a good way tracking and understanding how Blendo operates as a business and more about people that become customers. In this post, we will go through how to get [...]
