I started working on setting up OpenHab as a home automation hub using an old laptop and a Z-Stick. My main requirement is to be able to hook up my thermostat, as everything Z-Wave looks pretty straightforward. My thermostat is Read More
Connect Pentaho/Mondrian Schema Workbench to Amazon Redshift
The more you play with big data technologies, the more you end up circling back to the basic question “How does my end user get access/value?”. Currently we’re using Amazon Redshift as a down and dirty query window on top Read More
Setup Mondrian on Mac OSX
The Mondrian documentation is terrible, and Java isn’t something you get to easily “dabble” in. My goal was to setup Mondrian on my Mac OSX machine, starting with Mondrian 3.5. While trying to set up the initial FoodMart sample dataset Read More
EASILY Bulk Load files into a table with different columns
with NO FORMAT FILE! I consider this a gem just hiding on the MSDN docs : Using BULK IMPORT on a View The following example creates the v_myTestSkipCol on the myTestSkipCol table. This view skips the second table column, Col2. Read More
ADD NEW COLUMN TO GOOGLE SPREADSHEET
Yes, ALL CAPS, here is EXACTLY what I want to do: Add new column to google spreadsheet using java api Maybe now that term will be google-able? As with everything handy, it’s impossible to find what you need in the Read More