Itzik Ben-Gan

Advanced Search

Itzik Ben-Gan
Itzik Ben-Gan is a mentor with Solid Quality Mentors. He teaches, lectures, and consults internationally. He’s a SQL Server MVP and is the author of several books about T-SQL, including Microsoft SQL Server 2008: T-SQL Fundamentals (Microsoft Press, 2008). Email address: Itzik@SolidQ.com Web site: http://www.SolidQualityLearning.com
336 results found for Itzik Ben-Gan, displaying items 1 - 20

December 30, 2008

Smoke Free
Itzik talks about his previous New Year’s resolution—quitting smoking.
SQL Server Magazine

January 2009

Handling Arrays as Inputs
Learn how to use a T-SQL split function to handle arrays as inputs for SQL Server stored procedures.
SQL Server Magazine

January 2009

Tracking the Use of Deprecated SQL Server Features
SQL Server 2008 provides performance counters and trace events that you can use to track which deprecated features are being used in your environment.
SQL Server Magazine

January 2009

Deprecated T-SQL Features
Find out which features are missing or are deprecated in SQL Server 2008, as well as which features SQL Server won’t support in a future version.
SQL Server Magazine

December 19, 2008

Inline Scalar Functions
Itzik explains how you can improve the performance of queries that use scalar user defined functions.
SQL Server Magazine

December 2008

Handling Arrays
One way to use arrays as input for stored procedures is to employ dynamic SQL.
SQL Server Magazine

November 22, 2008

Time Only
Itzik demonstrates a technique to extract only the time part from a DATETIME value.
SQL Server Magazine

November 3, 2008

Live Chat with SQL Server Magazine’s Authors
Join a live chat with SQL Server Magazine’s authors Andy Kelly, Mike Otey and Itzik Ben-Gan.
SQL Server Magazine

November 2008

Calculate Percentiles
Use T-SQL to implement statistical calculations such as percentile and percentile rank.
SQL Server Magazine

October 29, 2008

Normalizing HIERARCHYID Values
Itzik explains how you can normalize or shorten HIERARCHYID values that became too long.
SQL Server Magazine

October 22, 2008

Microsoft SQL Server 2008: T-SQL Fundamentals Book
Itzik talks about his new T-SQL Fundamentals book that was just published.
SQL Server Magazine

October 2008

Query Temporal Data
Learn how to handle temporal data in SQL Server queries despite limited support.
SQL Server Magazine

September 9, 2008

Solutions to T-SQL Sorting Challenge
Itzik provides solutions to last week’s T-SQL sorting challenge.
SQL Server Magazine

September 1, 2008

T-SQL Sorting Challenge
Itzik provides a T-SQL challenge involving sorting separated lists of values.
SQL Server Magazine

August 30, 2008

SQL Server 2008 RTM MERGE Bug and Fix
Itzik describes a bug involving the MERGE statement in SQL Server 2008 RTM, and provides a pointer to the bug fix.
SQL Server Magazine

September 2008

Discover the Benefits of Filtered Indexes and Statistics
Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.
SQL Server Magazine

August 4, 2008

Equilateral Triangles Puzzle Solutions
Itzik provides solutions to the equilateral triangles puzzle.
SQL Server Magazine

August 2008

SQL Server 2008’s HierarchyID, Part 2
Use the new HIERARCHYID data type to move a subtree from one parent location in the hierarchy to another, and to convert a parent-child representation of the hierarchy to a representation that uses the HIERARCHYID data type.
SQL Server Magazine

July 28, 2008

Equilateral Triangles Puzzle
Itzik provides a puzzle involving equilateral triangles.
SQL Server Magazine

July 21, 2008

Bug with NEWID Function
Itzik describes a bug involving the NEWID function and table expressions.
SQL Server Magazine

[1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

ADS BY GOOGLE

SPONSORED LINKS		FEATURED LINKS
Download Data Protection Manager 2007 Disaster recovery at a low cost Maximize speed, performance and reliablity of your PCs and servers—automatically! Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.		Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Empower Your Processes with PowerShell 201 Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. New Release: Windows IT Pro Master CD 13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

IT Job Hound

ITTV
IT Library

Technology Resource Directory

Connected Home

Windows Excavator

Windows SuperSite