Highlight queries that join or filter on a table but never project any of its columns, suggesting EXISTS as a clearer alternative. Flag NVL-style null handling in predicates so authors can consider IS ...

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...

This time, I'm going to write about learning SQL. It all started with a casual comment from my teacher one day and a reference book placed in front of me. “You should try getting your hands on SQL ...

PostgreSQL is an advanced open-source relational database that has been widely used in the management of big data due to its robustness, scalability, and flexibility. However, with a large volume of ...

Many SQL users have expressed frustration with the SQL query syntax for SELECT. They argue that beginning with the FROM clause and ending with the SELECT clause would be more intuitive. This sequence ...

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...