Niall is a data engineer / architect that has been working with the Microsoft Data Platform tools for over 13 years. Originally working with SQL Server and SSIS, these days he's busy building Modern Data Platforms in Azure using Data Factory, Databricks, Data Lakes and a few other tools. Niall is actively engaged in the data community, blogging occasionally, and regularly speaking at user groups and conferences in the UK, including SQLBits in 2019 & 2020. Niall is a committee member for Data Relay, and has been a helper at SQL Bits for many years.


Previous 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.