No Picture

Sql Script Mover

January 13, 2017 jlion 0

I’ve just posted an updated version of my SQL Script Mover utility on codeplex, here: This is a utility for extracting schema from a sql server database. It supports views, stored procedures, functions, tables, triggers and DDL triggers.  

No Picture

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 space from a table without a clustered index when rows from that table are removed. A table without a clustered index is called a heap, and heaps are generally considered to be bad. Here’s the MSDN description of heap tables […]

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 the future that has to be? What if those giant tech companies that have been so efficient at eliminating middle class employment were subject to rigorous anti-trust regulations designed to prevent too much of our country’s economic power from falling […]

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: 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) that Amazon and eBay have no interest in helping you grow your business. They are interested in having you help them grow theirs.

No Picture

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 page that uses HTML5 canvas to help him chart the coordinates. The interactive coordinates charting page is here, in case you’d like to take a look:

No Picture

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 book is about technology and how we work with it. There are a lot of lessons in the book that I think particularly apply to a personal philosophy of software development: Writer’s Block This one in which Phaedrus provides advice on how […]

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 our bug tracking software, and second, that other executives that he met with, representing customers who used our software, were complaining to him about those bugs. I found the statement a little offensive, although he wasn’t referring specifically to the project on which I had […]

No Picture

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 now, and I subscribed to 80-Micro magazine. Each month I’d receive a fat magazine filled with printed source code. I’d spend hours laboriously typing in the listings, save my work to a cassette tape drive, then spend hours more finding typos […]

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 in another page or application. I’d welcome any suggestions or comments regarding this version of the gantt chart. I’ve also added a section on TFS programmming, which I’ve done quite a lot of dabbling with recently, and have added sections for […]

No Picture


July 20, 2016 jlion 0

The excellent Joseph Albahari, author of LINQpad, wrote a blog post: Why LINQ beats SQL and while I really like LINQpad (how else would I debug LINQ?)  I do think Joseph misses the point a little with SQL. He says: “Compared to SQL, LINQ is simpler, tidier, and higher-level” and my first reaction is that SQL and LINQ are bulldozers and Cadillacs here, not good subjects for direct comparison. I think there is a place for LINQ to entities but I do not believe that all database functions and access can be replaced by LINQ queries. I’d propose that any query […]

1 2