Niall has been working with SQL Server since 2007, mostly designing and building data warehouses.

Niall helps run the Bristol user group, and has recently taken up speaking to try and share some of the things he has learnt along the way.
Niall Langley has submitted 3 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

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.
The traditional star schema used in many data warehouses still has plenty to offer. In this talk we will look at some design patterns, tips and tricks to make loading and querying your data simpler, faster, and more reliable.
With GDPR and the number of data breaches we see in the news, encrypting sensitive data is incredibly important. In this talk we start with the basics of encryption, moving on to look at the ways we can encrypt data in SQL Server and Azure SQL DB.