This event has ended

SQL Soton - May 6th User Group

Southampton SQL Server User Group

Monday, May 6, 2013 from 6:15 PM to 9:15 PM (BST)

Southampton, United Kingdom

Ticket Information

Type Remaining End     Quantity
SQL Soton - May 6th 9 Tickets Ended Free  

Who's Going

Loading your connections...

Share SQL Soton - May 6th User Group

Event Details

May SQL Server User group meeting

 

Prizes

1 x £20 Amazon Voucher

2 x Pluralsight One month passes

 

Agenda

 

18:15 - Doors open

 

18:30 - Introductions

 

18:45 - Christina Leo (@ChristinaLeo)

Taming T-SQL:  Why APPLY?

Most T-SQL developers know that the APPLY operator can be used
to invoke a table valued function. But did you know that it can also be used to
join to derived data sets, return multiple columns from a sub-query, shred XML,
create working columns for use with the WHERE and GROUP BY clauses, and replace
the UNPIVOT operator? If not, then why not take your skills to the next level, and
come see each use case in action, using real-world examples. You’ll leave the
session with thorough understanding of the full potential of this versatile
operator, as well as a few new tricks up your T-SQL sleeves.

19:45 - Pizza, Snacks & Chat

20:00 - Christina Leo (@ChristinaLeo)
Taming T-SQL: Leveraging Window Functions
SQL Window functions were introduced in SQL Server 2005 and continue to be enhanced and broadened with each new release. Window functions allow you to apply iterative logic to a defined group of rows, in a set based manner. This functionality allows developers new, and more elegant options for solving real-world business problems while leveraging SQL Server’s set based nature.
This all-demo session aims to demystify these under-utilised T-SQL tools. Starting with a very basic example, I will break apart the OVER clause, the real key to understanding window functions in SQL Server. Subsequent demos will expand on each group of window functions which use the OVER clause:  ranking, aggregate, and analytic. Finally, we’ll look at specific business cases where window functions are invaluable while discussing relevant performance considerations.

21:00 - Raffle and home
Have questions about SQL Soton - May 6th User Group? Contact Southampton SQL Server User Group

When & Where



Avenue St Andrew's United Reformed Church

Southampton
SO17 1XQ

United Kingdom

Monday, May 6, 2013 from 6:15 PM to 9:15 PM (BST)


  Add to my calendar

Organizer

Southampton SQL Server User Group

Southampton SQL Server User Group was established in 2010 to bring together the SQL Server Community.

At our regular monthly meeting we host presentations from first timers to internationally renown speakers.

Whether you have only just downloaded SQL Server or a seasoned pro, there will be something for you.

For more information, please visit http://sqlsoton.sqlpass.org

 

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.