SQL Server – Welcome to the Blog & Website of Paul Andrew

Interacting with SQL Server 2019 Big Data Clusters

Posted on November 16, 2018April 7, 2020 by mrpaulandrew

Just a very quick post with lots of pictures 🙂 SQL Server 2019 Big Data Clusters are still in private preview and I'm currently running with version CTP 2.1. However, I wanted to share some of the exciting new features we can expect from this latest big data tech in terms of tools, management and … Continue reading Interacting with SQL Server 2019 Big Data Clusters →

Azure Data Lake Store – Files Dashboard

Posted on March 27, 2018June 16, 2018 by mrpaulandrew

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 →

mrpaulandrew

Avanade Centre of Excellence (CoE) Technical Architect specialising in data platform solutions built in Microsoft Azure. Data engineering competencies include Azure Synapse Analytics, Data Factory, Data Lake, Databricks, Stream Analytics, Event Hub, IoT Hub, Functions, Automation, Logic Apps and of course the complete SQL Server business intelligence stack. 15+ years’ experience working within healthcare, retail, manufacturing, and gaming verticals delivering analytics through the definition of industry leading design patterns and technical architectures. STEM ambassador and very active member of the data platform community delivering training and technical sessions at conferences both nationally and internationally. Father, husband, swimmer, cyclist, runner, blood donor, geek, Lego and Star Wars fan!

View Full Profile →