April SQL Server user group meeting.
- Two, one month, Pluralsight passes
- One £20 Amazon voucher from SpectrumIT
18:15 - Doors Open
18:30 - Introductions
18:45 - Christina E. Leo (@ChristinaLeo)
Title: Taming T-SQL: Why Apply
Abstract: 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, drinks & chat.
20:15 - Christina E. Leo (@ChristinaLeo)
Title: Taming T-SQL: Leveraging Window Functions
Abstract: 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:30 - Raffle & End