Vancouver PASS

 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 receive any of the newsletters and updates on meetings please register starting at the top right-hand corner.  Any questions can be address to us at Vancouver@pass.org.  Thanks for dropping by!

Next Meeting: Wed, Aug 16 2017

VANPASS MEETING - AUGUST 2017

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVP URL: https://www.eventbrite.ca/e/vanpass-august-2017-tickets-36610308418?aff=es2

VANPASS - AUGUST 2017

 Join us for a night with Itzik Ben-Gan

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

Title: T-SQL Window Functions

Abstract:

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.

When

iCal
Event Time : Wed, Aug 16 2017 17:30 - 20:30 Pacific Daylight Time

Where

Suite 2400 - 555 West Hastings Street

Vancouver, British Columbia, Canada V6B 4N6

Direction: Access via elevators at the Hastings & Seymour entrance to the 25th floor.

Featured Presentation

T-SQL Window Functions

Speaker: Itzik Ben-Gan, T-SQL Trainer SolidQ

Summary: 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.

About The Speaker(s):

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, T-SQL Querying, and T-SQL Window Functions. Itzik’s speaking activities include PASS Summit, SQLBits, 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.

Attachments

Documents

 TitleOwnerCategoryModified DateSize 
PASS Community News Deck - April 2019Diane SithooCommunity4/26/20195.17 MBDownload
PostgreSQL - A Discussion for SQL Server ProfessionalsDiane SithooEducational4/26/20191.05 MBDownload

Next Meeting

Next meeting Thursday, October 24th​, 2019 to be announced.

We don't just match, we engineer your happily ever after   

Careers at 
POF.com
   
 

 Vancouver SharePoint User Group                              

VanTUG.com

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

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

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

                 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids