Gap Analysis Using Algebra

This article shows how to solve a gaps and islands problem using simple algebra.

Implementing Date Calculations in SQL

This article explains a way to use labels (last year, YTD, etc.) for report parameters.

Introduction to STRING_SPLIT function in SQL

This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.

Casting Tiny Numbers

Mean Median Mode using SQL and DAX

This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.

Exploring the DATE Functions in SQL

Learn more about using the DATEADD function in SQL...

Identity Guarantees

Introduction to Indexed Views in SQL Server

This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.

Database Normalization in SQL with Examples

Gouri Shankar provides an overview of normalizing a database.

Handling Aggregations on a Poorly Designed Database

When the database design is not great, you may have to write some creative queries to get what you need.