/* BeejBløg */

Aug 1, 2013 - 2 minute read - Comments -

What’s this? A pretty decent “Time Machine” built into Win8!?

https://lifehacker.com/5958865/how-to-use-windows-8s-new-file-history-backup-aka-time-machine-for-windows i’ve always considered the Vista/Win7 “previous versions” facility to be pretty similar to Time Machine just lacking Apple’s meticulous care to making it drop dead easy to use. i hadn’t yet noticed the MS boys had taken yet another swipe at simplifying the UI in Win8… i’m assuming there’s still a usability gap that the Mac boys can laugh at us, but gee, first impression is “not bad Balmer you ol’ dog”

Jul 6, 2013 - 2 minute read - Comments -

Light Custom Configuration Section

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 using System; using System.Collections.Generic; using System.Configuration; using System.Linq; using System.Text; namespace WebServiceClient { /*URLElement class below represents a bundle of properties (URL, password, etc) for each endpoint we need to send to... And the following custom app.configuration section allows us to maintain a list of these URLElements. copied from here: https://www.abhisheksur.com/2011/09/writing-custom-configurationsection-to.html and here: https://stackoverflow.com/questions/1755421/c-sharp-appsettings-is-there-a-easy-way-to-put-a-collection-into-appsetting The basic gist is 3 fairly light implementation classes -- URLElement = individual elements, URLCollection = collection of elements, and URLSection = new custom app.

Jun 18, 2013 - 1 minute read - Comments -

[SOLVED] SSRS (2012), Excel export, “Not a legal OleAut date” error

Cause For my situation, it wound up being that executing TimeSerial(0,0,secs) in some vbscript code, when the “secs” param value was greater than 24 hours. Analysis Somehow out of all the different formats SSRS will export to, the Excel output was the only one running into this issue. From the TimeSerial specs I don’t see anything inherently invalid about going that high… the docs indicate it simply rolls it into the day portion of the resulting value as I would expect.

May 1, 2013 - 2 minute read - Comments -

Trailer Hitch Bike Rack

After fair amount of homework, went with the Softride “Element” 4-bike rack… pricing is consistently $210’ish and I went with my local REI for solid local support. Was torn between this Element and the $70 more big brother “Dura” model… which adds “anti-sway cradels” (i.e. seat tube rubber wraps) + built in lockup cable + hitch bolt lock + beefier + 5 lbs… I’m thinking I’ll be good at rigging my own anti sway (via old inner tubes & bungees), the rest really didn’t appeal to me and (I presume since we chose the low end 4 cyl.

May 1, 2013 - 3 minute read - Comments -

Roof Cargo Box

Installed this last night… found in local Pep Boys inventory… blasted them with a $20 coupon that expired that day 🙂 so was out the door at $210 + tax. This PepBoys SKU is barely a rebrand of the SportRack “Voyager XL”… the manual inside is OEM, headered with “90274 Voyager XL” and “A90275 Aero XL”… one forum I read said this bugger gets down around $100 sometimes during PepBoys promos… something to keep an eye on.

Mar 21, 2013 - 1 minute read - Comments -

Mockup / Wireframe / Prototype Tools

Balsamiq “Mockups” demo video Adobe AIR based licensed$$ desktop version – very full featured Web based demo – works well for quick thoughts Pencil free Cross platform desktop app Sketchy stencil for the “low fidelity” look Gliffy free basic web functionality $$ubscription model for featured version SketchFlow is apparently coming back to VS2012 – Microsoft seems to be in a bit of a tizzy buttoning down all the loose ends in the latest transition to all things immersive.

Mar 15, 2013 - 1 minute read - Comments -

iTunes finally has “add to play up next”

WHY did that take till 2013?!? Can’t believe they whacked CoverFlow in iTunes 11… I guess I’ll probably forget how much I liked the full screen CoverFlow eventually but man what a wild judgment call on Apple’s part there.

Mar 7, 2013 - 1 minute read - Comments -

DST T-SQL

-- this code returns the start and end datetime’s for DST in the current year -- DST begins at 2am on the SECOND SUNDAY of March and ends the FIRST SUNDAY of November SELECT DATEADD(HOUR, (MULTIPLIER + 7 /*skip the first week*/) * 24 /*24 hours a day*/ + 2 /*offset to 2am*/, StartWeek) AS StartDate, DATEADD(HOUR, MULTIPLIER * 24 + 2, EndWeek) AS EndDate FROM ( SELECT 0 AS MULTIPLIER, 1 AS DOW UNION ALL SELECT 6, 2 UNION ALL SELECT 5, 3 UNION ALL SELECT 4, 4 UNION ALL SELECT 3, 5 UNION ALL SELECT 2, 6 UNION ALL SELECT 1, 7 ) dow, (SELECT '03/01/' + convert(varchar, DATEPART(YEAR, GETDATE())) AS StartWeek, '11/01/' + convert(varchar, DATEPART(YEAR, GETDATE())) AS EndWeek ) DST WHERE DATEPART(WEEKDAY, StartWeek) = DOW

Feb 4, 2013 - 3 minute read - Comments -

Enable SSL Connections to SQL Server

“SQL Server Transport Encryption” is a good Google phrase for this technology. Reference: https://msdn.microsoft.com/en-us/library/ms191192.aspx Obtain an SSL Certificate A self signed certificate is easy and works fine... here’s one way: Get the IIS 6.0 Resource Kit Tools: https://www.microsoft.com/download/en/confirmation.aspx?id=17275 All you'll need is the "SelfSSL.exe" tool so the custom install is minimal. Find SelfSSL.exe in default install path: C:Program FilesIIS Resources Good reference for SelfSSL usage: https://www.

Feb 2, 2013 - 6 minute read - Comments

Recovering failed SQL Server 2012 Installation

I have to say, SQL Server’s setup.exe seems pretty dang fragile… I realize it’s a complicated script with endless dependencies and such, just saying… year after year I continue to run into various reasons that the setup twists it’s ankle on something, bombs out midstream and leaves behind a partial installation mess that can’t be repaired or uninstalled… maybe I’m just unlucky or perhaps I’m overly hard on poor old Windows.