Most Recent Blog Posts

man throwing javelin
02/23/2011 - 4:21pm

SQL Server 2012 T-SQL at a Glance – THROW

Itzik provides a preview of the new THROW command introduced in SQL Server 2012....More
01/27/2011 - 5:49pm

Clarifications Regarding TSQL Challenge: Packing Date and Time Intervals

Itzik provides a status update and clarifies a few points regarding the open T-SQL challenge involving packing date and time intervals....More
01/16/2011 - 4:36am

TSQL Challenge: Packing Date and Time Intervals

Test your T-SQL querying skills by trying to solve a fundamental problem in the relational model known as packing intervals....More
12/23/2010 - 3:18pm

Solutions to TSQL Challenge with Denali’s Sequence Object

Itzik covers solutions to the T-SQL challenge from last week involving Denali’s sequence object....More
12/15/2010 - 4:39pm

T-SQL Challenge with SQL Server 2012’s Sequence Object

Itzik provides a T-SQL challenge involving sequences in SQL Server 11, code-named Denali....More
11/22/2010 - 4:00am

SQL Server 2012 T-SQL at a Glance – Sequences

Itzik continues the preview of the new T-SQL features in Microsoft SQL Server 11 code-named Denali, covering sequences in this entry....More
11/20/2010 - 8:27am

SQL Server 2012 T-SQL at a Glance – OFFSET/FETCH

Itzik provides a preview of the new T-SQL features in Microsoft SQL Server 11 code named Denali, starting with the OFFSET/FETCH option....More
10/29/2010 - 12:21pm

Tip: APPLY and Reuse of Column Aliases

Itzik provides a tip showing how you can use the APPLY operator to allow reuse of column aliases....More
10/25/2010 - 12:56pm

Mailbox Peak Trail

Itzik describes a hike called Mailbox Peak in Snoqualmie Pass—North Bend area, WA, USA....More
09/17/2010 - 2:49pm

Window Functions (OVER Clause)—Help Make a Difference

Itzik talks about window functions, explains how powerful they are, and why it’s so important to encourage Microsoft to enhance support for those in....More
08/20/2010 - 7:50am

Solutions to the Travel Puzzle

Itzik covers solutions to the T-SQL challenge provided in his previous post....More
08/17/2010 - 7:21am

T-SQL Travel Puzzle

Itzik provides a T-SQL challenge involving travel related calculations....More
07/29/2010 - 4:24pm

Largest Known Prime and the Great Internet Mersenne Prime Search

Itzik talks about the largest known prime and the program that was used to find it....More
07/06/2010 - 4:46pm

Solutions to Proximity Puzzle

Itzik covers solutions to the proximity puzzle provided last week....More
06/29/2010 - 8:32am

TSQL Proximity Puzzle

Itzik provides a TSQL challenge involving matching rows based on proximity of values....More
What's Puzzled By T-SQL Blog?

T-SQL tips and logical puzzles from Itzik Ben-Gan.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×