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 cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes and Ezra Parker and Dan Wilson and John Mason and Jason Dean and Luis Majano and Mark Mandel and Brian Kotek and Wil Genovese and Rob Brooks-Bilson and Andy Matthews and Simeon Bateman and Ray Camden and Chris Rockett and Joe Bernard and Dan Skaggs and Byron Raines and Barney Boisvert and Simon Free and Steve 'Cutter' Blades and Seth Bienek and Katie Bienek and Jeff Coughlin

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 »