Preparing My Community Sessions for 2019

Hey friends & SQL family, its been a great year of tech and events so far, but now with several big conferences planning next years agendas its time to think ahead. Below I've prepared titles and abstracts for talks I'd like to deliver to our awesome data platform community in 2019. 5x regular sessions. 2x … Continue reading Preparing My Community Sessions for 2019

Azure Data Lake Store – Files Dashboard

A tool I've used in the past to query my local disk drives is WinDirStat. It's great for finding out where large files are hiding in your directories using a heat map visual. In this post I talk you through how I've created a similar tool for Azure Data Lake Store using PowerShell, SQL Server … Continue reading Azure Data Lake Store – Files Dashboard

Azure Data Factory v1 & v2 Service Principal Authentication for Azure Data Lake

Sadly this post has been born out of frustration, so please accept my apologies from the outset if that comes across in the tone. That said, I imagine anyone reading it will empathise and will have come across the post while searching for an understanding of some inconsistencies when using service principals to authenticate against … Continue reading Azure Data Factory v1 & v2 Service Principal Authentication for Azure Data Lake

Using U-SQL Split to Handle Variable Width Datasets

Happy New Year folks and welcome back to work! I hope you had a nice break. 🙂 I decided to kick off the new year of blogging with something fairly simple following some support work I did helping out a friend in the community. The problem encountered was twofold when dealing with data in Azure … Continue reading Using U-SQL Split to Handle Variable Width Datasets