Imagine you live in a communist country with no hope of freedom, democracy, or a living wage. Your job is to toil your entire life in miserable conditions and make frivolous, expensive toys for your rich neighbor across the ocean. Now, is suicide really an irrational response to that Kafkaesque environment?
It took me several minutes of reading through their marketing speak, but I believe it is a content management system with some additional features like mailing lists tacked on (I cannot be 100% sure, though... even after going through the sample sites). If the product description is any indication, the code is probably a mess.
I think most (?) languages already have this. It's called using a parameters collection or prepared statements instead of SQL & "CONCATENATION" & HAX. The frameworks already exist. The solution is to fire or brutally "retrain" the programmers who are writing this sloppy code to begin with.
The security problem is so widespread that the language or compiler should flag any concatenated string as "dirty" and disallow passing it into the database API to begin with... Maybe that is what this "framework" from Kaminsky is actually doing.
Yes, Bill's target net wealth when he dies is $0, and he is working through his foundation to reach that goal. Hopefully that makes everyone feel a little better about all those copies of Win 95 we bought back in the day, right?;)
Build your resume (hopefully with a focus on what you want to be doing long term), and dump your current employer once you get a better opportunity. And you will, if you focus on the right business / IT combination. The economy will eventually get better. And besides, it will take you a lot longer to realize your true potential in earnings if you stay with the same company.
So, a corollary:
1) Apple has a majority of the market share in smart phone app sales. Good for them.
2) Apple uses its majority market share in smart phone app sales to force everyone into their mobile ad platform. Monopolistic behavior, bad for the economy.
You would need an FK to the other table's unique index / PK, and then the inner join could be removed (if it is not referenced in the select list). In theory the FK has already been checked so the join is not really acting as part of the predicate / filter in that situation.
Note that join removal is only going to work on OUTER joins in some cases, as an INNER join is implicitly part of the predicate. If the joined columns are already related by a constraint, though, it may still be able to eliminate an INNER join.
Smart people are more tightly compact when.... the entire population is more tightly compact? Whoa! This is some serious science. He could have maybe (I don't know) thrown in some statistics to see if the density of degree holders (what a great definition of "smart") is greater than the mean you would expect for the density in question. But whatever... San Francisco #1!!!!