Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at NCDevCon 2011 (Raleigh, NC) with:

William Bowen

Member since Dec 11, 2008

Recent Blog Comments By William Bowen

  • Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

    Posted on Mar 28, 2008 at 1:53 PM

    @Jeffrey, Fair points, reasonable rebuttals, I probably won't address them all (a lot of them get more into matters of opinion/personal experience). A note about the constants. I don't want to have to pass them different places (including the database). That's why they get created in an easily ava... read more »

  • Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

    Posted on Mar 28, 2008 at 9:36 AM

    @Jeffrey Bouley - One good reason I've found to support application SQL versus stored procedures is the fact that I get to leverage my constant variables in the SQL I wrote within the application, versus having to define them again in my DBMS or hard code those values. That can be very handy for tr... read more »

  • Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

    Posted on Mar 27, 2008 at 3:00 PM

    I think when you say "Never Join Tables Using Commas" you're really advocating two things: 1. Don't use a FULL OUTER JOIN (this is what happens if you take the full cross-product with no WHERE or ON). I can't ever remember a time where I even needed one. 2. Use ANSI-standard SQL joins (e.g., FROM t... read more »

  • Kinky Solutions Valentine's Day Give Away

    Posted on Feb 5, 2008 at 2:43 PM

    Hey Ben, My girl Katya is swell because she loves ColdFusion, knows the difference between Java and JavaScript, validates her XHTML to W3C standards, strictly scopes all her variables, and writes reusable modular code. Well, in my dreams she does. But I looked past those shortcomings and instead ... read more »

  • Ask Ben: Simple Recursion Example

    Posted on Dec 5, 2007 at 12:06 PM

    Good article, and there are tons of practical applications of recursion. Some of the most common tasks I find myself applying recursion to are multi-tiered menus and breadcrumbs. I've seen some more novice programmers use a finite series of loops as Ben suggested and then set an "unlikely" upper bo... read more »