Post reply

How to define Production, Non-Production and Development

  • January 6, 2015 at 7:02 am

    #294057

    Hi

    Not sure which forum to post this question but here goes.

    My company has a stand alone sql instance with no front end application. The data in this instance is used for importing data to develop and create data sets that are exported in files for analyst to use locally in other applications. How would the licensing be define on this server Production, Non-Production or Development?

  • January 6, 2015 at 7:04 am

    #1768074

    Real data that is used for business decisions? Production.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 6, 2015 at 7:23 am

    #1768085

    Thanks Gail!

  • January 6, 2015 at 8:32 am

    #1768115

    jdbrown239 (1/6/2015)

    Hi

    Not sure which forum to post this question but here goes.

    My company has a stand alone sql instance with no front end application. The data in this instance is used for importing data to develop and create data sets that are exported in files for analyst to use locally in other applications. How would the licensing be define on this server Production, Non-Production or Development?

    If the data sets are, say, less that 4GB or so and exist only long enough to pass them to something else, then "BRICK" would be my classification. You could use an instance of SQL Express to handle the imports, conversions, and exports. SQL Express is free. 😉

    --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)

  • January 6, 2015 at 1:10 pm

    #1768226

    10GB limit for SQL Express 2008 R2, 1 core, 1 GB memory, no SQL Agent.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply