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...

Author: Bluewater SQL Date: 06/03/2015

Geospatial Queries Using Hive

During one recent engagement, I was helping my customer align ETL activities that were originally...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL Date: 02/25/2015

Introduction to Apache Storm

The Apache Storm project delivers a platform for real-time distributed (complex event) processing...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL Date: 12/19/2014

Programmatically Executing SSIS Packages

While working on the next iteration of my SSIS ETL Framework, I’ve discovered that the...

Author: Bluewater SQL 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...

Author: Bluewater SQL Date: 10/01/2014

Streaming #Pig

As a C# developer there are a number of opportunities available for writing code that is either used...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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....

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL 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...

Author: Bluewater SQL Date: 10/01/2014