/* BeejBløg */

Jun 18, 2013 - 1 minute read - Comments - Uncategorized

[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 - Uncategorized

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 - Uncategorized

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 - Uncategorized

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 - Uncategorized

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 - Uncategorized

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 - Uncategorized

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.

Dec 19, 2012 - 2 minute read - Comments - Uncategorized

Loading Ice Cream Sandwich (ICS – Android v4.0) on Samsung Galaxy Tab 7.7 (P6800)

Links: ClockWorkMod (CWM) “Recovery” booter for our device – Direct link to binary The actual ICS ROM (file name – P6800XXLQ1_ICS_IT168.zip) MD5 Checker Steps: Check model – First make sure you have the same exact model as me = GT-P6800… it will be on the back in small print at the bottom. Download the links Check ROM file – use MD5 Checker to confirm P6800XXLQ1_ICS_IT168.zip checks to 16A167C9 – 7B1B892D – BA6884AD – 36434CFE Install CWM – Follow link #1 for install instructions… they’re clear… don’t skim, follow them closely Backup – Boot into CWM menu and do the full backup of your current system.

Dec 9, 2012 - 1 minute read - Comments - Uncategorized

Blogger Custom Domain

(taken from here) Enter Blogger Dashboard Settings Under Publishing section: Enter your custom domain in the first box complete with the www prefix. Check the redirect box under it. Save those settings. You’re done with the Blogger side. Log in to your domain registry account (Name.com, GoDaddy, etc.) First, especially if you ported your domain from another registrar like me, make sure that your domain is set to use your new registrar’s Nameservers.