Celko's SQL Stumper: Eggs in one Basket

Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.

TSQL Challenge #12 - Build sequential ranges of dates with propagation to missing values

Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.

The Bejeweled Puzzle in SQL

Alex Kozak provides another SQL puzzle to hone your SQL Skills with.

T-SQL query

SQL Puzzle 8

A new puzzle that asks about implementing a powersum function.

SQL Puzzle 7

After a gap of sixteen months, Lionel Clarke, the creator of the only 3-D maze game to be written in TSQL, returns with a new SQL puzzle. It is very simple. You have to move as much of the data as you can from the source tables to the destination tables.

Celko's 'Can't Be Your Own Supervisor' SQL Puzzle

A SQL puzzle from the SQL guru.

A Raffle Puzzle

An interesting puzzle from the Orlando SQL Server Users Group

The T-SQL Quiz

Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.

Full Control Over a Randomly Generated Password

All of us need a steady stream of random passwords for the various systems we manage. Peter Larsson brings us an interesting T-SQL solution that generates one for us.