InfoWorld

Beyond SQL: 8 new languages for data querying

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

SQL basics: SELECT statement options

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
GitHub

create-table-as-select-azure-sql-data-warehouse.md

CREATE TABLE AS SELECT creates a new table based on the output of a SELECT statement. CTAS is the simplest and fastest way to create a copy of a table. CREATE TABLE AS SELECT (CTAS) is one of the most ...
InfoWorld

How to use GPT as a natural language to SQL query engine

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 means ...
Redmond Magazine

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...