Microsoft Azure Microsoft Data Platform Azure Data Platform Azure Data Factory SQL SSIS Modern Data Warehouse Data Warehousing Business Intelligence
Bristol, England, United Kingdom
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.
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.
In this session we take an overview of the Azure services that are of interest to data professionals, looking at the intended uses and comparing to the equivalent on premises technologies.
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.