No Picture

Microsoft Dynamics

August 4, 2017 jlion 0

One of the things that I really like about Microsoft products (and one of the reasons for their success) is the very well documented and very capable APIs that Microsoft provides. Dynamics is no exception.

Here are some helpful links that describe how to access the Microsoft Dynamics APIs, if you wish to create applications that query or report on …

No Picture

Reflection Notes

July 29, 2017 jlion 0

I’ve been doing quite a lot of work with C# reflection recently. Reflection is nifty stuff. It’s cool to have code that can inspect itself, execute itself dynamically.

I’ve been using reflection to create applications that use “plug-ins”. For example, the user might have a management GUI that allows them to select one of several similar but not identical assemblies. …

No Picture

HTML5 Clipping

July 23, 2017 jlion 0



Canvas is not supported

I love how easy it is to use HTML5 for animation. Recently I discovered another cool feature of the HTML5 graphics API: Clipping.

Clipping is a little like photoshop paths. You use the HTML5 api to draw shapes and then you can use clipping to show content only inside the boundaries of that path.

In a …

No Picture

Types of programming tasks

July 22, 2017 jlion 0

Not all programming work requires the same set of aptitudes and skills. Here is my take at some groupings:

  • Systems. This is the black art of developing software drivers or other software that requires an intimate knowledge of hardware or operating systems. Testing can be very difficult to do and is often a large part of the overall scope

The Fab Lab

June 29, 2017 jlion 0

My oldest son and I just completed a three day course in “mold making and resin casting” at the Northhampton Community College Fab Lab. It was a great experience. I signed us up because my son had been 3D printing fidget spinners. He had sold a couple that he made to friends, but they were relatively expensive to make …

No Picture

Uber and Ayn Rand

June 25, 2017 jlion 0

I’ve been following the trials and tribulations of Uber for quite a while. Uber was initially celebrated as disruptive and a game changer, a company that would radically transform American transportation. However, even in the beginning there were complications. Heavily licensed and inspected taxi cab drivers were up in arms at competition from an upstart free from the mandates that …

Sql Script Mover

January 13, 2017 jlion 0

I’ve just posted an updated version of my SQL Script Mover utility on codeplex, here: https://sqlscriptmove.codeplex.com

This is a utility for extracting schema from a sql server database. It supports views, stored procedures, functions, tables, triggers and DDL triggers.

 …

Faster Stored Procedures

January 2, 2017 jlion 0

Here are some thoughts on optimizing stored the performance of stored procedures.

In no particular order:

Clustered Indexes

Make sure your tables have clustered indexes.

It’s amazing to me that folks create tables without clustered indexes. A clustered index is the physical order of data in the table and it’s my understanding that it is difficult for SQL to reclaim …

No Picture

Split up facebook!

November 7, 2016 jlion 0

We live in a time when the middle class is rapidly disappearing, when the divide between wealthy and not-wealthy is as great as it’s ever been, and when the future appears poised to bring us a bleak landscape of uber-wealthy gated cities separated by sophisticated technology from warring, impoverished multitudes.

It’s right out of a Paolo Bacigalupi novel.

Is this …

No Picture

Why ebay and amazon are bad (if you’re a vendor)

October 31, 2016 jlion 0

I just happened across a great post by the guy (Jamie Salvatori) who runs VAT19:

http://www.practicalecommerce.com/columns/the-ecommerce-corner-office/11024-Why-we-abandoned-Amazon-and-eBay

In case you’re not familiar with them, VAT19 is a retailer of fun and funky things (giant lollypop, giant unicorn lamp) and I know them because my kids love surfing their web site (and watching their videos).

Jamie argues (and I wholeheartedly agree) …