In this puzzle, we’re going to learn how to do some basic data modeling.  Many of you have expressed an interest in

Read More
Data Modeling Principles in Action

In this puzzle we’ll explore a SQL bill of materials example. Companies use a BOM (Bill of Materials) to itemize the components

Read More
SQL Bill of Materials Example

In this SQL minute we’ll look at how to create a SQL server hierarchical query using the hierarchyid data type.  This is

Read More
SQL Server Hierarchical Query using the hierarchyid type

In this puzzle, we’re going to learn how to write a SQL UNION without using Set Operations.  Set operations allow us to

Read More
Full Outer Join as Union

In this puzzle, we’re going learn to about SQL set operators.  Set operators allow us to compare rows from two or more

Read More
SQL Set Operators

In this puzzle, we’re going to learn about joins vs subqueries.  In many queries you can substitute joins and subqueries.  Yet, since

Read More
Joins vs Subqueries SQL Puzzle

In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.  Knowing about a subquery versus inner join

Read More
Rewrite Subquery as a Join

In this puzzle we’re going to learn how to find the person whose birthday, among others, is in the middle.  Knowing how

Read More
Use SQL to Calculate Median Values.

In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.  A dynamic pivot table is

Read More
What is a Dynamic Pivot Table?

In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.  Cross tabs are a great

Read More
Use SQL Server to Create a Cross Tab Query

In this puzzle, we are going to learn how to join dirty data using the SQL Server. There are many instances that

Read More
Learn how to Work Joins and Messy Data

We are going to learn how to create a bar chart using SQL server in this puzzle. It can sometimes be fun

Read More
How to Create A Bar Chart Using SQL Server

In this puzzle, we’re going to learn how to find a gap in a sequence using SQL Server.  I was recently reviewing

Read More
How to Find a Gap in a Sequence using SQL SERVER

In this puzzle, we’re going with with SQL Percentile Rank to work through a problem to identify the top and bottom student

Read More
SQL Percentile Rank Puzzle