Storytelling & Encouraging Change

Storytelling & Encouraging Change

When working with teams and stakeholders, communicating a vision is paramount to success. Working in technology it’s easy to focus on the technological advantages and forget to include everyone on the journey. A key to getting wider business support on projects requires engagement with stakeholders, business managers and end users of the planned solutions. It’s…

Read More Read More

Visual Studio & diff Tools

Visual Studio & diff Tools

A diff tool (software to compare the difference between two text files) is a valuable asset to those of us who spend more than a healthy portion of the day looking at text files. Mostly this is to understand, what is different between the original and new version of some code. Here I’m looking at…

Read More Read More

RLIKE in hive: Filtering with regular expressions

RLIKE in hive: Filtering with regular expressions

As I previously did a blog post on Querying SQL Server with something LIKE a regular expression (Using simple regular expressions in a LIKE statement), I thought I would use that as a segue into Apache Hive and HiveQL. Because Hive and therefore HiveQL is built using Java, it has the full power of Java regular…

Read More Read More

Dates In Hive

Dates In Hive

After previously spending a lot of time looking at dates in SQL Server and oracle, I wanted to do the same justice to Hive.

Getting LEFT & RIGHT in hive

Getting LEFT & RIGHT in hive

Hive doesn’t have the functions LEFT() and RIGHT() as used in other RDBMS/SQL platforms. Here I demonstrate using hive functions for parsing text values which can emulate LEFT and RIGHT.

Video: View running processes and their children

Video: View running processes and their children

I’ve created a tool/library function using bash for monitoring parallel processes managed by shell scripts in a linux environment. In the video I cover how to download the library to your environment, and demonstrate using it to build trees of processes (and their child processes) which aide in monitoring what is happening on a server at a point in time.

Querying SQL Server with something LIKE a regular expression

Querying SQL Server with something LIKE a regular expression

Most of us are familiar with the LIKE command in SQL Server (and other DBMS environments), but few venture beyond simple text matching and the ‘%’ wildcard. It’s ability to use some regular expression (a.k.a. regex or regexp) syntax is a surprise to many. For this article, I’m assuming that readers have already used the…

Read More Read More

Object Catalog Views: Table Metadata

Object Catalog Views: Table Metadata

It’s handy to programmatically get metadata on tables (column names and datatypes), either to review implementation, or as part of a process automating code creation.