Most Recent Blog Posts

man throwing javelin
Feb 23, 2011

SQL Server 2012 T-SQL at a Glance – THROW

Itzik provides a preview of the new THROW command introduced in SQL Server 2012....More
Jan 27, 2011

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
Jan 16, 2011

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
Dec 23, 2010

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
Dec 15, 2010

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
Nov 22, 2010

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
Nov 20, 2010

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
Oct 29, 2010

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
Oct 25, 2010

Mailbox Peak Trail

Itzik describes a hike called Mailbox Peak in Snoqualmie Pass—North Bend area, WA, USA....More
Sep 17, 2010

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
Aug 20, 2010

Solutions to the Travel Puzzle

Itzik covers solutions to the T-SQL challenge provided in his previous post....More
Aug 17, 2010

T-SQL Travel Puzzle

Itzik provides a T-SQL challenge involving travel related calculations....More
Jul 29, 2010

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
Jul 06, 2010

Solutions to Proximity Puzzle

Itzik covers solutions to the proximity puzzle provided last week....More
Jun 29, 2010

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) ×