Show 11 – T-SQL

Did you know that SQL was initially called “Sequel” (Structured English Query Language)?

On this show, we go back to basics and talk about our favorite language – Transact-SQL (T-SQL).

We cover a lot of topics in the fields of development, performance and maintenance. Among them:

• The logical phases of query processing
• Our favorite and least favorite T-SQL features
• T-SQL development best practices
• How to avoid writing long Stored Procedures
• How to avoid writing the “mother of all queries”
• The Axis of Evil T-SQL featrues
• Why you should (almost) never use table variables

Items mentioned in the show:

• Matan Yungman – The Axis of Evil
• Itzik Ben-Gan – Creative Uses of the APPLY Operator (Part1)
• Itzik Ben-Gan – Creative Uses of the APPLY Operator (Part2)