Microsoft Azure Microsoft Data Platform Azure Data Platform Azure Data Factory SQL SSIS Modern Data Warehouse Data Warehousing Business Intelligence
Bristol, England, United Kingdom
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 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.