Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

The statements use a SQL string varchar data type, then you execute the command. Even though. ... Build the query string to create a SQL statement that selects records.

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

SQL Server 2016 provides new support for working with JSON objects. In a previous column, I discussed how to generate JSON from SQL queries. This column looks at the reverse process: accepting JSON ...

So, let’s celebrate SQL turning 50, and consider how we can continue to develop and use it in the future. Charly Batista is PostgreSQL technical lead at Percona .