Stumbling Around
Programming the Things


Written by Jay Killeen


Connecting Ruby on Rails to an Existing SQL Server Database

Published on October 18, 2017 at 10:14AM

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 07:00AM

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 06:20AM

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 12:51AM

Informally Known As WTF is M

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL

Published on June 20, 2017 at 10:55AM

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 01: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 01:14AM

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

Center Aligned Pagination in Rails using Bootstrap 4 and Kiminari

Published on June 14, 2017 at 12:21AM

Pagination looks nice when it is centered below a table. Here is how I got it to work.

Excel Actually Sucks

Published on May 18, 2017 at 03:23AM

Just a place where I can write all the things I hate about Excel. Remember to just breathe

Simple Power Query M to Display When the Report was Last Refreshed

Published on May 17, 2017 at 12:39AM

Very simple query to show when you last hit the 'Refresh' button in PowerBI