Niall Langley

Information & Communications Technology

Microsoft Azure Microsoft Data Platform Azure Data Platform Azure Data Factory SQL SSIS Modern Data Warehouse Data Warehousing Business Intelligence

Bristol, England, United Kingdom

NOLOCK - The Good, the Bad & the Ugly

In this session we will use lots of demos to look at what the NOLOCK hint actually does and the ways it can return incorrect results, before looking at how we can use optimistic concurrency to solve the same issues more reliably.

Niall Langley

Data Developer

Niall has been working with SQL Server since 2007, mostly designing and building data warehouses, most recently building modern data warehouse platforms in Azure.

Niall blogs occasionally, and regularly speaks at user groups and conferences in the UK, including presenting at SQL Bits for the first time in 2019. Niall also
helps run the Bristol user group, and is a helper for SQL Bits and Data Relay.

Niall's full speaker profile