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 ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

SWObjects can also rewrite SPARQL queries in SQL, effectively including relational databases alongside SPARQL endpoints in a linked data federation.

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which ...

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!