• 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

  • Wearing Four Hats at SQLBits 2017

    April 13th, 2017 in Blog, Community, Just For Fun, Purple Frog Systems

    I know there are lots of great blog posts already out there from great people sharing their experiences from SQLBits. However, I hope none of them can offer an account quite as unique as mine from this years event. Why? Well, most people go to SQLBits as attendee’s to learn, network and socialise. This certainly applies to me. But ‘attendee’ was just 1 of my 4 hats (roles) at SQLBits 2017. In this post I’d like to…

    » 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

  • Passing Parameters to U-SQL from Azure Data Factory

    February 1st, 2017 in Azure, Blog, U-SQL

    Let’s try and keep this post short and sweet. Diving right in imagine a scenario where we have an Azure Data Factory (ADF) pipeline that includes activities to perform U-SQL jobs in Azure Data Lake (ADL) Analytics. We want to control the U-SQL by passing the ADF time slice value to the script, hopefully a fairly common use case. This isn’t yet that intuitive when constructing the ADF JSON activity so I hope this post will save…

    » Read more

  • Using Azure Data Factory Configuration Files

    January 23rd, 2017 in Azure, Blog, JSON, Visual Studio

    Like most things developed its very normal to have multiple environments for the same solution; dev, test, prod etc. Azure Data Factory is no exception to this. However, where it does differ slightly is the way it handles publishing to different environments from the Visual Studio tools provided. In this post we’ll explore exactly how to create Azure Data Factory (ADF) configuration files to support such deployments to different Azure…

    » Read more

  • Writing a U-SQL Merge Statement

    December 13th, 2016 in Azure, Blog, C#, U-SQL, Visual Studio

    Unlike T-SQL, U-SQL does not currently support MERGE statements. Our friend that we have come to know and love since its introduction in SQL Server 2008. Not only that, but U-SQL also doesn’t currently support UPDATE statements either… I know… Open mouth emoji required! This immediately leads to the problem of change detection in our data and how, for example, we should handle the ingestion of a daily rolling 28-day TSV extract,…

    » Read more

  • Azure Data Lake Authentication from Azure Data Factory

    December 2nd, 2016 in Azure, Blog, C#, PowerShell, Visual Studio

    rereTo set the scene for the title of this blog post lets firstly think about other services within Azure. You’ll probably already know that most services deployed require authentication via some form of connection string and generated key. These keys can be granted various levels of access and also recycled as required, for example an IoT Event Hub seen below (my favourite service to play with). Then we have other services like SQLDB that…

    » Read more