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) …

Interactive Coordinates Charting

October 17, 2016 jlion 0

This past week my son brought home some math homework. The assignment was, given a list of coordinates, to graph those coordinates. The result would be a picture.

My son made a couple of mistakes in his graph and so the picture was a little off. I thought the idea was intriguing. To help him I put together a web …

Programming Zen…

September 21, 2016 jlion 0

One of my favorite books is Zen and the Art of Motorcycle Maintenance, by Robert Pirsig. It’s about a lot of things, but mostly about quality, more specifically, “what is quality?” It’s not explicitly about software but it is about technology in a general sense. “Phaedrus”, the narrator of the novel, is a technical writer, and much of the …

No Picture

Where do bugs come from?

September 11, 2016 jlion 1

“Our Software Sucks”

I was once party to a contentious meeting. A senior executive made the statement that “our software sucks!”. When he said this, he was referring to all of the projects worked on by all of the developers at the company. And he was making this assessment on two points: First, that there were many bugs logged in …

LNW-80 / TRS-80

August 20, 2016 jlion 1

My son recently assembled his own computer. While this isn’t his first computer, it’s the first one he’s put together himself and it’s the best computer in our house (fastest, best video card, most drive space, awesome LED lighting).

My first computer was a TRS-80 Model III. I was about 14, about the same age as my son is …

No Picture

Gantt Chart

August 6, 2016 jlion 0

I’ve posted an javascript version of my simple gantt chart.

It’s not a full-featured gantt chart like you might find in Microsoft Project. The intent is for it to be something like a calendar–to provide a visual representation of a series of events where overlaps are easy to spot. I’ve tried to make it easy to embed this chart …