Support
SQL Cartoons
Writing a Query
2023-06-29
Piotr Kononow
Writing a an SQL query, even if you know SQL, is not an easy task. You need to know a lot of things before you get any meaningful results - for instance, what tables, columns and joins to use.
Importance of a Where Clause
2022-11-10
It's really important to remember about all the conditions in your WHERE statement. You might get flooded with the results.
Just use this table...
2021-02-11
Business users don't always have to take a back seat to IT when it comes to data.
Build data literacy and democratization in your organization with Data Catalog and data documentation.
Santa queries database
2020-12-22
Have you been good this year? Well, let’s just hope that Santa will figure out his SQL by Christmas...
It is NoSQL
2020-08-18
There's more behind NoSQL databases than that they do not support SQL...
Asc, desc, whatever
2020-01-29
Sometimes you write the most sophisticated query and celebrate the results. Only to find out that you forgot something as trivial as a sort order...
Sum(id)
2019-09-23
If the numbers look too good, check the SQL.
SQL joins are tricky
2018-11-23
Table relationships (foreign keys) in a database are often not obvious. When you make a mistake joining them you end up with seriously incorrect results.
'Do not use' client
2018-11-21
Without good understanding of database schema it is easy to make mistake joining tables which can cause serious error in the results.
Earth Query Language
2018-11-07
Database you are desigining or implementing can be used far beyond your office, and your time.
Querying in the dark
2018-10-08
If you don't know schema and the right tables in the database you are querying it's like being blind.