Login  |  Register


You are here :: Home Friday, August 18, 2017






 Welcome to VanPASS!

If you are new to this site the first thing to know is that membership and attendance to any meeting is absolutely free.  All that we ask is that you RSVP for any meeting so we can get enough pizza for everyone.   Also, to recieve any of the newsletters and updates on meetings please register starting at the top right-hand corner.  Any questions can be address to me, Richard Baumet, at rbaumet@shaw.ca .  Thanks for dropping by!

 Vancouver IT Community


Vancouver BI 
PASS Chapter


 Vancouver Chapter of The Data Warehouse Institute                

 Vancouver SharePoint User Group                              


.NET User Group of British Columbia, Canada - netbc.ca                        

Canadian Information Processing Society, Vancovuer Chapter - vancouver.cips.ca                          

PMI, Canadian West Coast Chapter - pmi.bc.ca                                           

 Vancouver BC Chapter of the IIBA - vancouver.theiiba.org



   Join us for a night with Itzik Ben-Gan!


Date: Wednesday, August 16, 2017      Time: 5:30-8:30 PM PDT

LocationPlentyOfFish 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:

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.

Sponsored By:

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!

Register now: https://www.sqlsaturday.com/635/RegisterNow.aspx
Submitted Sessions: http://www.sqlsaturday.com/635/Sessions/SubmittedSessions.aspx

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.

Home | Meetings | Resources
Privacy Statement  |  Terms Of Use
Copyright 2008 by Vancouver PASS Chapter