Itzik Ben-Gan's guest appearances

Itzik Ben-Gan

SQL Server Radio

RunAs Radio

SQL Down Under

The Pete On Software Podcast

Ask SQL Family - SQL Player's show

Kalen Delaney

Kevin Kline

Chris Webb

Grant Fritchey

Brent Ozar

Michael Rys

Aaron Bertrand

Alex Yates

Bob Ward

Rob Sewell

Tomaz Kastrun

Thomas LaRock

Rondale Williams

Graeme Simsion

Andy Leonard

OwlTail

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A Microsoft Data Platform MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server High-Performance T-SQL Using Window Functions, T-SQL Fundamentals and T-SQL Querying. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include SQLPASS, SQLBits, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.This talk has taken place during SQLDay conference in Wroclaw (Poland), on 16th May 2018 (Wednesday).Interviewers: Kamil Nowinski &amp; Damian Widera.Do you know what Itzik does like doing the most? What kind of thing is important when writing a book? Why worth to be at conferences and also when he has started working with Microsoft SQL Server databases? Find out more in this talk.

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A Microsoft Data Platform MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server High-Performance T-SQL Using Window Functions, T-SQL Fundamentals and T-SQL Querying. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include SQLPASS, SQLBits, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities. This talk has taken place during SQLDay conference in Wroclaw (Poland), on 16th May 2018 (Wednesday). Interviewers: Kamil Nowinski &amp; Damian Widera. Do you know what Itzik does like doing the most? What kind of thing is important when writing a book? Why worth to be at conferences and also when he has started working with Microsoft SQL Server databases? Find out more in this talk.

ASF 014: Itzik Ben-Gan interview

Itzik Ben-Gan has many T-SQL tricks. In this show, we talk about a few of them:  How to get Batch Mode Processing with regular tables How to share Identity between different tables How to use Cross Apply for Unpivot  In addition, we talk about what SOS_Scheduler_Yield means and answer the question - is it always the DBA's fault? If you would like your question to be featured on the show, just head over to SQLServerRadio.com, drop us a line, and we'll talk about it in one of the upcoming shows. Items mentioned in the show:  Itzik Ben-Gan - What You Need to Know About Batch Mode Window Aggregate Operator in SQL Server 2016 

<a href="http://sqlmag.com/author/itzik-ben-gan" rel="nofollow" target="_blank">Itzik Ben-Gan</a> has many T-SQL tricks. In this show, we talk about a few of them: <ul> <li>How to get Batch Mode Processing with regular tables</li> <li>How to share Identity between different tables</li> <li>How to use Cross Apply for Unpivot</li> </ul> In addition, we talk about what SOS_Scheduler_Yield means and answer the question - is it always the DBA's fault? If you would like your question to be featured on the show, just head over to <a href="http://www.sqlserverradio.com" rel="nofollow" target="_blank">SQLServerRadio.com</a>, drop us a line, and we'll talk about it in one of the upcoming shows. Items mentioned in the show: <ul> <li><a href="http://sqlmag.com/sql-server/what-you-need-know-about-batch-mode-window-aggregate-operator-sql-server-2016-part-1" rel="nofollow" target="_blank">Itzik Ben-Gan - What You Need to Know About Batch Mode Window Aggregate Operator in SQL Server 2016</a></li> </ul>

The Itzik Ben-Gan Trick

Here in Episode 13, I interview T-SQL Legend Itzik Ben-Gan. As I talk about in the episode, Itzik's work has had a huge impact on my career and I'm very honored to have him on my show as a guest. We talk about T-SQL features that are underused, features that are powerful, and ones that are outright missing from the product. Along the way, Itzik points us to some great resources. Links Mentioned in this Show: Microsoft Virtual Academy - Boost your T-SQL With the APPLY Operator Microsoft Connect - SQL Server SolidQ Home Page Itzik's Site Itzik's Twitter Heartbleed Tool LastPass Listen To This Episode:

Here in Episode 13, I interview T-SQL Legend Itzik Ben-Gan. As I talk about in the episode, Itzik's work has had a huge impact on my career and I'm very honored to have him on my show as a guest. We talk about T-SQL features that are underused, features that are powerful, and ones that are outright missing from the product. Along the way, Itzik points us to some great resources. Links Mentioned in this Show: <a href="http://www.microsoftvirtualacademy.com/training-courses/boost-your-t-sql-with-the-apply-operator" rel="nofollow" target="_blank">Microsoft Virtual Academy - Boost your T-SQL With the APPLY Operator</a> <a href="http://connect.microsoft.com/directory/?keywords=sql+server" rel="nofollow" target="_blank">Microsoft Connect - SQL Server</a> <a href="http://www.solidq.com/" rel="nofollow" target="_blank">SolidQ Home Page</a> <a href="http://tsql.solidq.com/" rel="nofollow" target="_blank">Itzik's Site</a> <a href="https://twitter.com/itzikbengan" rel="nofollow" target="_blank">Itzik's Twitter</a> <a href="https://filippo.io/Heartbleed/" rel="nofollow" target="_blank">Heartbleed Tool</a> <a href="https://lastpass.com/" rel="nofollow" target="_blank">LastPass</a> Listen To This Episode:

Episode 13 - Itzik Ben-Gan on T-SQL

SQL Server MVP Itzik Ben-Gan discusses techniques for using the T-SQL language to solve common problems, shows how considering a negative point of view might help and discusses the upcoming enhancemen