This session is aimed at anyone with basic level T-SQL experience or above looking to improve their code; especially when writing long, complex queries.
We will cover topics including getting the most out of Management Studio, Common Table Expressions, the APPLY operator, Window Functions, methods of pivoting and unpivoting data and more.
Through this you will expand your tool-belt of techniques to help you produce T-SQL code that's not just faster to run but also easier to read and faster to write.
Barney Lawrence has over a decade's experience on the Microsoft data platform having moved from the guy who knows Excel, to Data Analyst, to Accidental BI Developer and finally to Actual BI Developer. He currently works as a Senior BI Developer for Jet2.com