Wednesday, January 21, 2015

Great SVG Site

I've been delving into SVG to implement a custom diagram.  Most of the time my searches take me to stackoverflow.com but for SVG a lot of the best answers have come from Jakob Jenkov's site, http://tutorials.jenkov.com/svg/index.html.

Tuesday, January 13, 2015

Promises, Promises

Here's a good post (http://busypeoples.github.io/post/promises-in-angular-js/) explaining promises in AngularJS.

Farewell ng-controller? I hardly Knew Thee

Interesting article (http://teropa.info/blog/2014/10/24/how-ive-improved-my-angular-apps-by-banning-ng-controller.html) about how and why to stop using the ng-controller attribute.  The basic idea is to remove the implied scope inheritance and the confusion and issues that can cause.

I think I'll keep with ng-controller for now but will plan on moving away from it.  Especially if as noted Angular 2.0 kills it off anyway.

Cross Platform Mobile App Development in Visual Studio

Here's an interesting article that gets into some of the nitty gritty of writing cross platform mobile apps in Visual Studio using the upcoming (currently in preview) Apache Cordova integration into Visual Studio 2013 & 2015.

http://msdn.microsoft.com/en-us/magazine/dn879349.aspx?loc=zatfz_zTS4z&prod=zVS10z&tech=zOtScenz&lang=zOtLangz&prog=zTNMz&type=zMagz&country=zUSz

Monday, January 12, 2015

SQL COUNT and Nullable Columns

SQL aggregates ignore NULL values in columns.  I knew that  but here's something I'd never really thought of.  If you run a count against a specific field, say COUNT(MyNullableColumn), it won't count records where the value of MyNullableColumn is NULL.  However, if you use COUNT(*) instead it will count all records.  Makes sense.  Just never really considered it.