The finale of the SQLRelay events
THIS EVENT IS NOW FULL, you may register but you will be placed on a waiting list
6:00 – 6:30pm Registration and networking
Meet and greet.
6.30 – 7:30pm
A - Z of SQL Nuggets
7.30 - 8.00pm BREAK: Light refreshments
More time to network and ask questions...
8:00 – 9.00pm
Session: T-SQL Window Functions in Microsoft SQL Server Denali
Window functions are an extremely powerful concept in T-SQL allowing you to apply calculations against a set of rows. Window functions have several advantages over alternative, more traditional methods to achieve similar calculations, resulting in simpler and more efficient solutions. SQL Server 2005 introduced partial support for window functions and SQL Server Denali adds more complete support. This session covers window functions and their support in SQL Server Denali, and explains why they are so powerful and preferable to the more traditional alternatives.
Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft 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 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written articles for SQL Server Magazine, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. 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.