Niall has been building data solutions on the Microsoft platform for 12 years. In the past few years Niall has been focused on helping clients with data engineering in Azure.


Niall helps run the Bristol user group, has been a helper at the last 2 SQLBits. He speaks regularly at user groups and conferences.

Sessions

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.
In this session we look at a simple way to implement Kimball durable keys on a SCD2 dimension. This provides an easy, performant, way to support reporting on data using historical and current hierarchies.
Niall_Langley120902.png