What we're about

Birmingham Microsoft Data Platform Group - Bringing the West Midlands Microsoft Data Platform Community together.

What?

A virtual meeting held on the first Thursday of every month @ 1pm GMT/BST. It's a free-to-attend, informal gathering of like minded people, with 1-2 speakers presenting hour long sessions including tips, techniques and information on old, new and upcoming technology.

The event is kindly sponsored by Purple Frog Systems, Power BI Sentinel and RP Analytics.

Where?

Anywhere!
All of our meetings are currently held virtually on Microsoft Teams.

When?

The first Thursday of every month @ 1pm GMT/BST.

Our next session is on:

*02/12/2021

(Note we are not holding a session in January 2021).

Join our group to keep up-to-date with the latest meeting announcements!

Upcoming events (1)

A Slice of Time: Window Functions in SQL Server

Online event

Microsoft Data Platform Group Birmingham - Thursday 9th June 2022 @ 13:00 BST.

Speaker:

Kevin Feasel

Title: A Slice of Time: Window Functions in SQL Server

Window functions are a powerful technique for analyzing data in SQL Server. In this session, we will understand when to use a window function like ROW_NUMBER() or LAG(), including specific use cases.

We will understand:
* The performance implications of window functions
* Performance tuning of queries with window functions
* Using window functions to make certain classes of queries faster
* Performance implications of having multiple windows in a single query.

This talk will also review some of the limitations in SQL Server's implementation of window functions and how to work around many of these.

Agenda:
12.45 - 13:00 : Setup and Join
13:00 - 13:05 : Open Lobby and Introductions
13:05 - 14:00 : A Slice of Time: Window Functions in SQL Server

Venue:
Wherever you have access to Computer or Smart Device! This session will be online only!

Other Details:
*** Please note registration on MeetUp is required to gain access to the Teams remote link!***

You MUST RSVP to this event to gain access to the remote link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help.

***Update: Event link to follow soon!***

Event Organiser Contact Details:
If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

Contact:
Email: [masked]
Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

Sponsors:
Purple Frog Systems
Power BI Sentinel

Past events (58)

Options for Securely Sharing Power BI Content

Online event

Photos (30)

Find us also at