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.

Learn how to use SQL query tools and frameworks for database development, such as SQL IDEs, query builders, frameworks, performance tools, testing tools, and debugging tools.

Learn how to create, visualize, and analyze a line intersection query using spatial SQL functions and tools in a GIS database. Get tips and tricks to optimize your queries and avoid errors.

A few strategic decisions can help improve your generative AI code and queries, and prevent sending out sensitive data.

Do you ever find yourself juggling queries to get the information you need? Subselects, also called subqueries, may be just what you’ve been looking for. This SQL feature allows you to query ...

Many modern SQL servers support Common Table Expressions (CTE) feature that allows you to declare a temporary named result set derived from a query and use it in the from part of another query. This ...

To perform case insensitive queries in Cosmos DB I can use the SQL function UPPER to convert a string to upper case. Unfortunately, the documentation does not specify how this conversion is done. D ...