• xsevensinzx - Sunday, January 7, 2018 9:10 AM

    I wouldn't put it all on the engineers though. Plenty of cases where the business process is not defined and therefore a proper model can't be defined. With that, no amount of RDBMS will likely save you. It's true, there are solutions out there that allow you to get away without defining that model or process. That makes it easier for you to push forward without having to define relationships, constraints, indexes and so forth. Those solutions chosen could not just be the engineers, but just the fact it seemed like the best solution for the problem.

    Like you said, if one can do it why can't we all? Is SQL Server really that complicated that another man (or woman) can't duplicate what another company did? In my mind, I don't think so. But there is more to a solution than just the tech. A lot of things have to align to make something that shined for one happen for another that has nothing to do with the whole RDBMS versus NoSQL argument.

    There's no question that the requirements that a system must meet do need some proper definition that the Engineers will need to design things properly but... I will put it all on the Engineers.. 😉  Good Engineers also understand when they don't actually have the necessary requirements (both happy path and the alternatives) and won't put fingers to keyboard unless it's a Proof-of-Principle to help determine the requirements and other possibilities.  Certainly, good Engineers won't pass something on just to "get it off their plate" to give the semblance of being "productive".  They also know when "good enough" actually isn't even when there's a looming deadline.

    And, no... I'm not saying that Engineers will/should always chose to use an RDBMS or chose to not use one.  I do agree that their job is to figure out what "seemed like the best solution for the problem".  The key here is that that choice isn't based on whether or not an RDBMS can handle the problem nor the size of the problem.  Rather, it's a choice made by a given set of Engineers on how they can handle the problem and, as we can see by the incredible success examples of NASDAQ and Amazon, the Engineers for both companies did one hell of a good job on all fronts.

    Here's to all Engineers that say "What if" and "We can"!

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)