jlion – Page 3 – RobotJlion

July 29, 2017February 6, 2020 by jlion

Reflection Notes

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

Types of programming tasks

July 22, 2017

July 23, 2017January 19, 2020 by jlion

HTML5 Clipping

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 …

Javascript, jqGrid and XML

July 17, 2016

July 22, 2017February 2, 2020 by jlion

Types of programming tasks

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

Reflection Notes

July 29, 2017

June 29, 2017July 22, 2017 by jlion

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 …

June 25, 2017February 6, 2020 by jlion

Uber and Ayn Rand

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 …

January 13, 2017October 22, 2019 by jlion

Sql Script Mover

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.

…

Naming conventions for sql

August 10, 2019

SQL Partitioned Tables

March 25, 2019

Making a user DBO for all databases on a server

March 19, 2019

CLR stored procedures in sql server

September 13, 2018

Faster Stored Procedures

January 2, 2017

January 2, 2017October 22, 2019 by jlion

Faster Stored Procedures

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 …

Naming conventions for sql

August 10, 2019

SQL Partitioned Tables

March 25, 2019

Making a user DBO for all databases on a server

March 19, 2019

CLR stored procedures in sql server

September 13, 2018

Sql Script Mover

January 13, 2017

November 7, 2016February 8, 2020 by jlion

Split up facebook!

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 …