Call today 0845 643 6463

Azure

  • Azure Data Lake – The Services. The U-SQL. The C# (Reference Guide)

    October 13th, 2017 in Azure, Blog, Community, Reference Guide

    This post is a reference guide to support an event talk or webinar. The content is intended to assist the audience only. Thank you. Abstract How do we implement Azure Data Lake? How does a lake fit into our data platform architecture? Is Data Lake going to run in isolation or be part of a larger pipeline? How do we use and work with USQL? Does size matter?! The answers to all these questions and more in this session as we immerse ourselves in…

    » Read more

  • What’s New in Azure Data Factory Version 2 (ADFv2)

    September 24th, 2017 in ADFv2, Azure, Blog, C#, JSON, PowerShell

    I’m sure for most cloud data wranglers the release of Azure Data Factory Version 2 has been long overdue. Well good news friends. It’s here! So, what new features does the service now offer for handling our Azure data solutions?… In short, loads! In this post, I’ll try and give you an overview of what’s new and what to expect from ADFv2. However, I’m sure more questions than answers will be raised here. As developers we…

    » Read more

  • Chaining Azure Data Factory Activities and Datasets

    August 23rd, 2017 in Azure, Blog, JSON

    As I work with Azure Data Factory (ADF) and help others in the community more and more I encounter some confusion that seems to exist surrounding how to construct a complete dependency driven ADF solution. One that chains multiple executions and handles all of your requirements. In this post I hope to address some of that confusion and will allude to some emerging best practices for Azure Data Factory usage. First a few simple questions: Why is…

    » Read more

  • Azure Business Intelligence – The Icon Game!

    July 11th, 2017 in Azure, Blog, Community, Just For Fun

    As Azure becomes the new normal for many organisations our architecture diagrams become ever more complicated. Articulating our designs/data flows to management or technical audiences therefore requires a new group of cloud service icons in our pretty pictures. Especially for hybrid solutions. Sadly those icons aren’t yet that familiar for most. So, here’s a very simple blog post to help you recognise what’s in the Azure stack from a…

    » Read more

  • Connecting PowerBI.com to Azure Data Lake Store – Across Tenants

    June 29th, 2017 in Azure, Blog, PowerBI

    Welcome readers, this is a post to define a problem that shouldn’t exist. But sadly, does exist and given its relative complexity I think warrants some explanation. Plus, I’ve included details of what you can currently do if you encounter it. First some background… Power BI Desktop With the recent update to the Power BI desktop application we now find the Azure Data Lake Store connector has finally relinquished its ‘(Beta)’ status and…

    » Read more

  • Cognitive Services with U-SQL (Reference Guide)

    May 22nd, 2017 in Azure, Blog, Community, Reference Guide, U-SQL

    This post is a reference guide to support an event talk or webinar. The content is intended to assist the audience only. Thank you. Abstract Microsoft’s Cognitive Services are basically the best thing since sliced bread, especially for anybody working with data. Artificial intelligence just got packaged and made available for the masses to download. In this short talk, I’ll take you on a whirl wind tour of how to use these massively…

    » Read more

  • Recursive U-SQL With PowerShell (U-SQL Looping)

    May 7th, 2017 in Azure, Blog, PowerShell, U-SQL, Visual Studio

    In its natural form U-SQL does not support recursive operations and for good reason. This is a big data, scale out, declarative language where the inclusion of procedural, iterative code would be very unnatural. That said, if you must pervert things PowerShell can assist with the looping and dare I say the possibility for dynamic U-SQL. A couple of caveats… From the outset, I accept this abstraction with PowerShell to achieve some…

    » Read more

  • Calling U-SQL Stored Procedures with C# Code Behind

    April 22nd, 2017 in Azure, Blog, C#, U-SQL, Visual Studio

    So friends, some more lessons learnt when developing with U-SQL and Azure Data Lake. I’ll try and keep this short. Problem You have a U-SQL stored procedure written and working fine within your Azure Data Lake Analytics service. But we need to add some more business logic or something requiring a little C# magic. This is the main thing I love about U-SQL, having that C# code behind file where I can extend my normal SQL behaviour. So,…

    » Read more

  • Storing U-SQL Assemblies in Azure Blob Storage

    March 17th, 2017 in Azure, Blog, U-SQL

    I’m hoping the title of this post is fairly self explanatory. Your here because like me you found that the MSDN language reference page for creating U-SQL assemblies states that it’s possible to store the DLL’s in Azure Blob Storage. But it doesn’t actually tell you how. Well please continue my friends and I’ll show you how. The offending article: https://msdn.microsoft.com/en-us/library/azure/mt763293.aspx The…

    » Read more

  • Creating a U-SQL Date Dimension & Numbers Table in Azure Data Lake

    February 2nd, 2017 in Azure, Blog, U-SQL

    Now we all know what a date dimension is and there are plenty of really great examples out there for creating them in various languages. Well, here’s my U-SQL version creating the output from scratch using a numbers table. Remember that U-SQL needs to be handled slightly differently because we don’t have any iterative functionality available. Plus its ability to massively parallelise jobs means we can’t write something that…

    » Read more