Principal consultant and architect specialising in big data solutions on the Microsoft Azure cloud platform.

Data engineering competencies include Azure 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.

Many years’ experience working within healthcare, retail and gaming verticals delivering analytics using industry leading methods and technical design patterns.

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!

Paul Andrew has submitted 5 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Azure Synapse is not a simple veneer of existing resources its a game changer. In this introduction to Synapse we'll cover the what, that why and importantly the how for this emerging bundle of exciting services.
Based on real world experience lets think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Platform solution.
The desire to use real-time data is constantly growing, businesses need to react to market trends instantly. In the new data driven age a daily ETL load/processing window is not enough. Stream Analytics can help.
Having mastered the basics of ADF you may now be looking to advance your knowledge of the tool. In a series of short lessons you'll learn how to orchestrate everything and deploy Data Factory in production environments.
What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a feature rich, graphical, scalable data flow environment to rival any ETL tech we’ve previously had available in Azure.

Sessions

Previous Sessions

Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.
Let’s understand the role of this hyper-scale two tier big data technology and how to harness its power with U-SQL, the offspring of T-SQL and C#. We’ll cover everything you need to know to get started developing solutions with Azure Data Lake.
If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you.
Paul_Andrew161242.jpg