The Agenda

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