T-SQL for the Experienced Practitioner

2016

TL; DR

This full day seminar covers advanced T-SQL querying and programming topics.

Session Details

This full day seminar covers advanced T-SQL querying and programming topics. It is recommended for T-SQL practitioners (developers and DBAs) who have at least one year of experience writing and tuning T-SQL code. The seminar explains how to solve common problems elegantly and efficiently. Following are the topics that will be covered:

Window Functions and their Advanced Uses
Advanced Uses of the APPLY Operator
OFFSET-FETCH
Performance Problems with UDFs
Parameter Embedding with Dynamic Filtering and Sorting
Using the HIERARCHYID Datatype
In-Memory OLTP
Temporal Tables
Sequences
MERGE Statement Tips

3 things you'll get out of this session

Itzik Ben-Gan's previous sessions

Beware of nondeterministic T-SQL code

Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.

T-SQL tips and tricks focusing on backdoors and workarounds

This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.

This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.

Window Functions

This session covers T-SQL Window Functions.

Boost your T-SQL with the APPLY Operator

The session starts with a brief overview of the operator and it

T-SQL Tips and Tricks

The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.