No Image

Service Trace Viewer

December 9, 2019 jlion 0

Recently I had to do some debugging of a WCF service. I used trace logs for this, but the output format of the tracelogs is a wall-of-text xml file.

Luckily, Microsoft has created a viewer that facilities working with these …

No Image

HTML5 and transparency

October 24, 2019 jlion 0

As an experiment I decided to create a couple of gears that would appear as an overlay on a web page.

My thinking was that I might use HTML5 to create UI controls that could be …

No Image

Certifications

October 22, 2019 jlion 0

Recently I’ve completed the Microsoft 70-761 and 70-762 certifications. I’ve been using SQL Server for years now, since version 6.0, and I’ve seen it evolve a lot.

There’s a lot of debate about the value of certifications. Forums abound with …

No Image

SOLR open source search

October 22, 2019 jlion 0

I’m setting up a SOLR environment. Here are the steps I’m taking to do this.

Set up environment

I’m using Oracle VirtualBox and Windows 7 pro, with a 60GB virtual hard drive and 4gb of memory. I’m using Chrome as …

No Image

Some thoughts on architecture

September 30, 2019 jlion 0

It’s October.

One of the tasks I’ve set for myself this month is to document an application that is complex and undocumented. Not only is there no technical documentation for this application, but the specifications and requirements that determine whether …

No Image

Javascript calendars…

September 11, 2019 jlion 0

Recently I wanted a countdown calendar to more visibly track progress toward a goal a few years away.

I created this calendar page where you can specify the number of days into the future you would like calendars for, and …

No Image

Excel VBA function for writing to a file

August 25, 2019 jlion 0

Every so often I work on a project that involves extracting data from excel where it’s easier just to code the extraction up as a macro. For these projects, these two functions serve me well by enabling my macros to …

No Image

Naming conventions for sql

August 10, 2019 jlion 0

I have some coworkers that haven’t worked a lot with sql subqueries. Subqueries are a great tool, but can be confusing for folks who have limited sql experience. It’s my opinion that, like any code, good naming, proper formatting and …