/* BeejBløg */

Sep 22, 2016 - 2 minute read - Comments -

Using “C# Interactive” aka CSI/CSX for ETL

motivation interactive C# offers typical REPL benefits ala powershell without the mental context switch required to leave our beloved C# syntax =)   notable great MSDN reference article CSX syntax can be executed from either Visual Studio 2015 (as of update 1) > View > Other Windows > C# Interactive -or- C:\Program Files (x86)\MSBuild\14.0\bin\csi.exe then #load file.csx Explantion of the steps in the code sample Extract this example is based on a low fidelity web page as the raw data source

Aug 21, 2016 - 5 minute read - Comments -

GreaseMonkey hacking Gmail

motivation i wanted to see if i could get category bundling working in gmail ala outlook… it’s always been a nice mental flow for me to carve out pending events from littering my “inbox zero” but still see them right there in front so i don’t forget to check up on them vs a click away hidden under a “folder” update – don’t miss the google “labs” functionality for doing exactly this kind of category bundling

Aug 16, 2016 - 4 minute read - Comments -

Script to generate dozens of required iOS app icon images

Motivation there are a number of free icon generating web sites available which begs the question whether a script like this provides any value… but leveraging a robust image manipulation utility like imageMagick to apply unique aesthetics makes a DIY approach like this more compelling… along those lines, in the current script, i’m applying: custom “centering” – for the splash images where the icon sits inside of a larger background, i’ve found positioning the icon 2/7ths of the way down from top to be the most pleasing outer glow

Aug 13, 2016 - 5 minute read - Comments -

[Solved] Greasemonkey/Tampermonkey jQuery sideload and setInterval

i was having a heck of a time keeping a reliable handle on jQuery in the Pandora page… it would be there upon initial Greasemonkey script execution but then upon subsequent setInterval executions, the jQuery global variable was undefined… fascinating… notable: as i was debugging, i started to see that Chrome was cycling through four ( 4 ! ) different VMxxxx “copies” of the greasemonkey script upon each setInterval execution… questions like why?

Jun 24, 2016 - 1 minute read - Comments -

[SOLVED] Bare CNAME with MX record

just thought i’d throw this out into the interwebz since it seems to be such a well known no-can-do that is actually a very handy can-do (where applicable)… Background DNS admin warnings advise against doing a “bare” (no prefix) CNAME along with an MX record, example Disclaimer What i’m successfully demonstrating here is clearly non-standard according to the specs… however, i’ve proven it does work for SOME servers implementation of the standards (including major provider Office 365 on the MX side) so it’s worth trying with your servers if this provides a convenient solution for your needs… and it will be immediately verifiably working or not; no “sometimes” ambiguity to worry about.

Jun 23, 2016 - 13 minute read - Comments -

Configuring VMware ESXi as a Workstation

Virtualizing only Compute Overview i was looking for a single machine Mac + Win solution… working from one primary desktop and remoting to the other… this is of course the general posture of all the popular VM “Workstation” products but they gave me heartburn for one reason or another (see Motivation) ESXi –VMWare’s FREE HyperVisor product– can support Mac (unlike Windows Hyper-V) yet requires some configurations of HDD, Video & USB to accomplish the desired single machine workstation footprint, hence these notes

May 18, 2016 - 2 minute read - Comments -

PowerShell WinForms interactive Prototyping/Debugging

Credits: this post is great. i’m just adding a little packaging on top. Motivation PowerShell’s interactive nature lends it to be a handy way to experiment with .Net objects… including UI elements like WinForms/WPF… Yet firing up UI’s classically take over the active thread to service the user interaction (e.g. mouse events etc)… Without the extra gravy below, our otherwise handy interactive powershell locks up tight until we close down the Windows Forms application thus releasing the main thread back to the command line The following gravy throws a Windows Form onto a background thread such that we can continue to manipulate the UI objects WHILE THEY’RE RUNNING, yay!

Apr 30, 2016 - 2 minute read - Comments

Migrate from Delicious to Diigo

Delicious set the standard but they’ve been a bit of a bumpy ride lately with reliability… according to their blog blog they recently moved back to old code base and Del.icio.us domain (ah memories :)… and then just as of today just got their settings page operational such that I could successfully export my bookmarks and hop to another free link lily pad… the export yields a simple html file full of links.

Apr 23, 2016 - 1 minute read - Comments -

SQL Server PDO PHP7

get the DLL – grab latest x64.zip add to your php.ini extension list: [ExtensionList] extension=php_pdo_sqlsrv_7_nts.dll here’s sample call code: <?php try { $conn = new PDO( "sqlsrv:Server= ip_address; Database = mydb ", $user, $pwd); $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); } catch(Exception $e){ die(var_dump($e)); } $stmt = $conn->query($qry); $result = $stmt->fetchAll(); $row = $result[0]; $colval = $row[“fieldname”]; ?>

Apr 23, 2016 - 2 minute read - Comments -

PHP7 Debugging under Visual Studio 2015

I suggest installing PHP7 through the IIS Web Platform Installer so it does the Handler Mapping vs having to mess with that manually (i.e. assigning PHP extension to php-cgi.exe) – but there’s a lot of guides out there for doing that yourself if you want. That’ll probably leave you with a slightly older version so then just go install latest PHP7 bits over the top – we want the non-thread-safe (NTS) builds when running under IIS FastCGI (supposedly the most performant approach)