Speaker

David Alcock

David Alcock

Principal Consultant for DTA IT Consultancy

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

Dastardly Demo's in SQL Server

This session covers things you shouldn't ever do in SQL Server. We'll look into corrupting pages, causing security headaches and dive into undocumented trace flags to cause chaos and destruction with the query optimiser.

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 phases, stages and transformation rules. We'll also take a look at influencing the optimiser with hints, and if it is a good idea or not!

#DataWeekender v3.1 Sessionize Event

May 2021

Data Relay 2019 Sessionize Event

October 2019

DATA:Scotland 2019 Sessionize Event

September 2019 Glasgow, United Kingdom

David Alcock

Principal Consultant for DTA IT Consultancy

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top