AutoHotKey script for mapping the Apple Key to Control Key

Posted on August 24, 2017 by Michael Roma

Script:

LWin::Ctrl

Fix for git not fetching all branches

Posted on February 26, 2017 by Michael Roma

Below is a fix for if your git fetch does not fetch all branches

First run the following command:

$ git config --get remote.origin.fetch

If the value returned is not equal to:

+refs/heads/*:refs/remotes/origin/*

Then run this to set the config:

$ git config remote.origin.fetch "+refs/heads/*:refs/remotes/origin/*"

SQL Script to find all SQL Agent Jobs for SQL Reporting Services Subscriptions

Posted on December 18, 2016 by Michael Roma
select 
    job.name as SQLAgentJob,
    subscr.SubscriptionID,
    report.Name, 
    report.Path,    
    subscr.Description,
    subscr.LastRunTime,
    subscr.LastStatus

from 
    Subscriptions subscr
    join
    ReportSchedule sched
    on subscr.SubscriptionID = sched.SubscriptionID
    join
    Catalog report
    on sched.ReportID = report.ItemID
    join
    msdb.dbo.sysjobs job
    on cast(sched.ScheduleID as nvarchar(50)) = job.name

order by 
    report.name

Dynamics AX X++ function to get today's date

Posted on October 27, 2016 by Michael Roma

Use the follow function:

systemDateGet();

How to stop tracking a file already committed in git

Posted on October 26, 2016 by Michael Roma

Use the following command to remove a file or pattern from git:

git rm -r --cached my-file.js

You would then update your .gitignore to exclude this file or pattern