Data Platform User Group (SQL Server)

Join fellow IT Professionals for an evening of knowledge sharing and networking in an open, friendly environment.

17:30 – 18:00 – Networking (drinks)
18:00 – 19:00 – David Alcock | Guillotines, Sat-Nav and the Query Optimiser
19:00 – 19:20 – Break (pizza / top up)
19:20 – 20:20 – Lightening Talks - Jet2 Data Platform Team
20:20 – 20:30 – Off t’pub.

David Alcock | Guillotines, Sat-Nav and the Query Optimiser
What have guillotines and satellite navigation got to do with querying SQL Server? 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
7-30-8-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)