Join us for a night with Itzik Ben-Gan!
Date: Wednesday, August 16, 2017 Time: 5:30-8:30 PM PDT
Location: PlentyOfFish Media Inc., Harbour Centre - 25th Floor 2525-555 W Hastings St, Vancouver, BC V6B 4N4
Title: T-SQL Window Functions
T-SQL window functions allow you to perform data analysis calculations like aggregates, ranking, offset and more. When compared with alternative tools to achieve similar tasks like grouping, joining, using subqueries, window functions have several interesting advantages that allow you to solve your tasks often more elegantly and more efficiently. Furthermore, as it turns out, window functions can be used to solve a wide variety of T-SQL querying tasks well beyond their original intended use case, which is data analysis. This session introduces window functions and their evolution from SQL Server 2005 to SQL Server 2017, explains how they get optimized, and shows practical use cases.
Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A Data Platform 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 T-SQL Fundamentals Third Edition and T-SQL Querying. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik’s speaking activities include SQLPASS, SQLBits, SQL Nexus, SQLU, SQLTeach and various user groups around the world. 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.
PlentyOfFish Media Inc.
Harbour Centre - 25th Floor 2525-555 W Hastings St, Vancouver, BC V6B 4N4
(access via elevators at the Hastings & Seymour entrance)
To register for this event please visit: https://www.eventbrite.ca/e/vanpass-august-2017-tickets-36610308418?aff=es2
Share this event on Facebook and Twitter
We hope you can make it!
SQLSaturday Returns to Vancouver August 26th!
You are receiving this email because you are a member of the Vancouver PASS Group.
As you may recall, SQLSaturday is a FREE 1 day conference for Data Professionals with expert speakers from across the Globe! Don't come to the event alone, bring some friends or co-workers to learn and share together. You can't see 7 sessions at once, so divide and conquer - regroup afterwards at the office and fill one another in on what you each learned.
This year's event is Saturday, August 26th from 8 AM to 6 PM at the UBC Robson Square Campus. For full details, be sure to check our event homepage located here: http://www.sqlsaturday.com/635/EventHome.aspx
Most of all, don't forget to register, as further updates will ONLY be sent out to registered attendees of SQLSaturday #635. And why wait? You can register RIGHT NOW by clicking here: https://www.sqlsaturday.com/635/RegisterNow.aspx
Once again we will see local celebrities in addition to rock stars from around the globe! This year, in addition to our normal tracks, we also plan to have a dedicated Azure Track as well as a SharePoint Data and .NET Data sessions.
Always wanted to try your hand at speaking? Here's your chance! We're bringing back the Lightning Talk to encourage people to take a risk and get up to share a #TechTidBit in a 10 minutes mini presentation.
We look forward to seeing you at Vancouver's largest PASS event.
Did I mention that it's free?
Scott & The SQLSaturday #635 Organizing Committee.