A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

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

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data. In May 1974, Donald Chamberlin and Raymond Boyce published a paper on ...

Bolanle is a Microsoft Office specialist at MUO. She has extensive knowledge and expertise, thanks to more than 5 years of experience using the Microsoft Office suite. She also has a certification in ...

In SQL, the "ROWS BETWEEN" clause is a powerful feature that allows you to define a window of rows for analysis or calculation within a query. By specifying a range of rows, you can perform ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...

Part of the SQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates ...