April 30, 2008
Itzik shares a tip that he got from a waitress that makes beer drinking a better experience.
April 24, 2008
Itzik describes changes to the MERGE statement and the HIERARCHYID datatype that will appear after CTP 6.
March 20, 2008
Itzik describes how you can enforce a unique constraint with multiple NULLs in Microsoft SQL Server 2008.
March 10, 2008
Itzik provides a tip regarding highlighting code in SQL Server Management Studio.
February 28, 2008
Itzik describes an enhancement to the CONVERT function in Microsoft SQL Server 2008 which allows new types of conversions between character strings and binary values.
February 20, 2008
Itzik describes an undocumented feature of Microsoft SQL Server 2005 client tools.
January 31, 2008
Itzik provides the solutions for the T-SQL challenge – Combinations from last week.
January 23, 2008
Itzik provides a T-SQL challenge to compute all possible sums of combinations of elements.
December 30, 2007
A Happy New Year greeting from Itzik in dozenal base.
December 18, 2007
Itzik describes a tip he learned from Umachandar Jayachandran regarding forcing join algorithms.
November 29, 2007
Itzik explains how to calculate nondeterministic row numbers.
November 19, 2007
Itzik discusses solutions to the primality test challenge.
October 29, 2007
Itzik provides a challenge to write a function that checks whether the input number is Prime.
October 9, 2007
Itzik provides solutions to the Mode puzzle.
September 27, 2007
Itzik introduces a T-SQL puzzle where you need to figure out how to isolate the most frequently occurring value (also known as Mode).
September 10, 2007
Itzik talks about a change in behavior of RAND and NEWID in SQL Server 2005 that you may have overlooked.
August 30, 2007
Itzik talks about his experience in the last couple of years hiking in the Pacific Crest Trail (PCT) and the Slovenian Alps.
July 17, 2007
Itzik encourages you to vote for a proposal for a T-SQL enhancement that has to do with NULL treatment.
July 7, 2007
Itzik discusses a simple CLR user defined function that gives you rich flexible capabilities in formatting DATETIME values.
July 1, 2007
Itzik discusses two different logical approaches to calculating age.
Add these Headlines to your Website
