Dave Heavy Industries - A journal of tech-findings and ramblings

28 May 2020

Cisco AussieBB FTTC NBN Config

We had AussieBB install an FTTC service to our premises, it took a little bit of poking to get going, here’s what ...
28 May 2020

MSSQL T-SQL Pivot Example

I’ve been using Microsoft SQL Server for a long time. Most things I do have become muscle memory and I don’t...
28 May 2020

SSTP/PPTP VPN using VPN credentials instead of windows to access remote resources

I had to get an emergency vpn up and running as our Palo Alto GlobalProtect vpn had a few issues that were tricky to ove...
12 Aug 2013

NGINX snmp monitoring

12 AUG/13 0 So far as I could tell, nginx doesn’t provide any stats out to snmp. This is something we like to watc...
28 Apr 2011

Decoding Windows Script Encoder encoded scripts

isn’t that a mouthful? Microsoft released this in 2001 - http://www.microsoft.com/downloads/en/details.aspx?Family...
25 Feb 2011

Distance between two points with curvature (vbscript)

The earth isn’t flat. Sometimes you feel like over engineering a simple problem just because you can. Late last ye...
11 Feb 2011

MS SQL Server - index fragmentation

Sometimes it doesn’t make sense to rebuild all of your indexes as part of a maintenance plan. You may have mirrori...
08 Feb 2011

Cisco Rommon priv password

Cisco rommon has a “secret”(not very well kept) section where you can execute some privileged commands. Cisc...
08 Feb 2011

Wordpress permalink via SQL

Today someone asked how to get the wordpress permalink from another language via SQL. Well, after a little bit of head s...
07 Feb 2011

Cisco 877 TPG Config

Well, TPG uses PPPoE rather than PPPoA like most ISP, and there were a few issues with the MSS before my TPG was working...