PASS Manchester Data Platform User Group

Network, learn, ask a question, meet other data folk, get fed - these are all things that happen at PASS user group events. These events are a really great opportunity to socialise in an informal learning experience.

Remember to tell your friends and the people you work with; make sure you register as soon as you can.

17:30 – 18:00 Registration and networking

18:00 - 19:00 - David Alcock - What have guillotines and satellite navigation got to do with querying SQL Server?

19:00 – 19:30 - Break. Time for pizza and beers

19:30 – 20:30 - Lightening Talks - Jet2 Data Platform Team

20:30 – Feedback and Close and head for drinks down the pub

First Session David Alcock - What have guillotines and satellite navigation got to do with querying SQL Server? 18:00 – 19:00

Well, in this session you’re going to find out! We’ll be looking into query performance and that means reading query plans, but in order to do that we also need some background knowledge of how the query optimiser works. With that in mind we’ll be jumping right into optimisation stages, hints and rules. We’ll also learn how to keep track and influence how the engine optimises our queries, and we’ll see if it’s a good idea or not.

Bio:
David Alcock is a Developer turned DBA turned Data Professional and is the Principal Consultant for DTA IT Consultancy, a company he started to help people build and grow their data platforms.

-Second Session-
Lightening talks by the Jet2 Data Platform Team
19:30 – 20:30

A quick introduction to what we do at Jet2 - Dan Thompson (@LeedsDBA)

Followed by 3x lightening talks to cover the following topics:

• Multi-Server Job Administration (with MSX/TSX) - Michal Bronowski (@MikeyBronowski)
• Query Store (SQL 2017) - Simon Gilks
• Auto-tuning (SQL 2017) - Ben Ritson (@BenaldoDBA)