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.

Run the SQL that comes back on your data set to calculate your answer. (Optional) Create an interactive application to make it easy to query a data set in plain English.

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

Get started with BigQuery for content analysis using Google Search Console data. Tips, tricks, best practices, and queries are provided.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...