Stumbling Around
Programming the Things

Written by Jay Killeen


Add a Date Model to PowerBI or Power Query

Published on December 08, 2017 at 10:10AM

I regularly add a model to my Power BI or Power Query to represent the date and functions around date.

Tell MSYS2 Terminal to use existing .bashrc and .bash_profile from Git Bash

Published on November 15, 2017 at 12:57PM

You have been using something like Git Bash and now switch to MSYS2 but want to use your old .bashrc like before

Alias Database Table Column Names in trails.js using trailpack-sequelize

Published on October 30, 2017 at 09:58AM

You want a column to be called 'id' instead of 'TableID' because you don't have access to the database to rename the field directly

Connecting Ruby on Rails to an Existing SQL Server Database

Published on October 18, 2017 at 08:14PM

Notes I took when trying to connect a Ruby on Rails web app to an existing on premises Microsoft SQL Server Database

IFNIL formula in Excel

Published on August 30, 2017 at 05:00PM

Often you don't want to wrap an IF statement when you just want to turn a 0 result into another value such as blank

Macro to Backup Excel VBA Code within an Excel Workbook

Published on August 24, 2017 at 04:20PM

Backup all the VBA codes to Git

Writing a Blog Post About M Lang/M Language/Power Query Formula Language/Power BI/Get & Transform

Published on June 21, 2017 at 10:51AM

Informally Known As WTF is M

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL

Published on June 20, 2017 at 08:55PM

You read the brochure but you just can't get that hot tub workin'

Quickly Switch Between Worksheets in Excel using Shortcut (Alt+Backtick)

Published on June 19, 2017 at 11:31AM

Copy this to your PERSONAL.XLSB to quickly switch between Worksheets on the ActiveWorkbook

Permanently Set the PostgreSQL datestyle to ISO, DMY, European or Australian

Published on June 14, 2017 at 11:14AM

I keep setting up servers with default postgresql.conf which is MDY