Bluewater SQL
Business Intelligence, Big Data & Other Ramblings
Using #PolyBase in #SQLServer2016
It’s been a few weeks since the numerous Build and Ignite announcements ushered in the latest...
Date: 06/03/2015
Geospatial Queries Using Hive
During one recent engagement, I was helping my customer align ETL activities that were originally...
Date: 06/02/2015
Automating Update of Azure-Powershell
Just a quick post to share a useful script. The PowerShell script below will download and update the...
Date: 05/28/2015
Building an Azure ML SSIS Task
In several previous blog posts (HERE and HERE), I’ve introduced and discussed the Azure...
Date: 04/04/2015
Ooooh I'm Telling: Doing Swear Word Analysis with Storm on HDInsight
As promised, this is the first of three (maybe more) posts that will present an end-to-end example...
Date: 02/25/2015
Introduction to Apache Storm
The Apache Storm project delivers a platform for real-time distributed (complex event) processing...
Date: 02/23/2015
Something's Brewing with Azure Data Factory - Part 3
In the first two parts of this blog series (HERE and HERE), we used Azure Data Factory to load Beer...
Date: 02/04/2015
Something's Brewing with Azure Data Factory Part 2
In my last post (HERE), I started hacking my way through the new Azure Data Factory service to...
Date: 02/02/2015
Something's Brewing with Azure Data Factory
Awhile back I put together a presentation to show off HDInsight using Mahout and most...
Date: 01/27/2015
Hello…..Azure Data Factory!
Overview The boundaries between on-premise and cloud-born data continue to blur with more and more...
Date: 01/26/2015
SSIS Catalog and Project Deployment with PowerShell
This may be my shortest blog post ever as I get ready to sign off from work for the next three...
Date: 12/19/2014
Programmatically Executing SSIS Packages
While working on the next iteration of my SSIS ETL Framework, I’ve discovered that the...
Date: 12/11/2014
3 Little Piggy's: Advanced #Pig Join Scenarios
One of the most common operations in any Pig job is the join. A join, much like what you like the...
Date: 10/01/2014
Streaming #Pig
As a C# developer there are a number of opportunities available for writing code that is either used...
Date: 10/01/2014
Oink: Improving #Pig Development
Over the last couple (ok more than a couple) of months, we've taken a meandering stroll through the...
Date: 10/01/2014
Indexes & Views in #Hive
In my last Hive post, we introduced partitions and bucketing both of which allow you to horizontally...
Date: 10/01/2014
Partitions & Buckets in #Hive
In my previous post, we discussed the map, array and struct data types and their implementation in...
Date: 10/01/2014
Introduction to #Hive Collections
After a much needed vacation in the sunny Florida Keys and some time away from the work and...
Date: 10/01/2014
MapReduce Ninja Moves: Combiners, Shuffle & Doing A Sort
Who's driving this car? At first glance it appears that as a developer, you have very little if no...
Date: 10/01/2014
Azure Machine Learning – Data Preparation
In my last post (HERE) we started a more pragmatic look at the Azure Machine Learning service using...
Date: 10/01/2014
Azure Machine Learning – Data Understanding
Continuing on with our introduction of the Azure Machine Learning service, we will step back from...
Date: 10/01/2014
Azure Machine Learning – A Deeper Look
In the previous post, we took a cursory look at the newly announced Azure Machine Learning Service....
Date: 10/01/2014
Azure Machine Learning – First Look
An intriguing new Azure-based service was recently announced that has an opportunity to be a game...
Date: 10/01/2014
Fun with PowerShell: Part 1 – Loading Demo Data
I know I am relatively late to the game when it comes to PowerShell, but I’ve found myself...
Date: 10/01/2014
An End-to-End HDInsight Demo
I’ve got one last post in me before vacation starts… By now, the big data buzzword...
Date: 10/01/2014
Building Custom SSIS Azure Service Bus Components
Over the last couple of weeks, I have been experimenting and working on a set of custom SSIS Service...
Date: 10/01/2014