none
Purchasing SQL server RRS feed

  • Question

  • Hi 

    I need to install a employee login and payroll application on physical server on premises. The requirement is Windows server 2019 and sql server 2017 or above.

    I am very new in this matter. I could not choose what to buy. I had a look sql server 2019.

    The standard edition is very expensive. What is best to buy since only one application will be using this sql server.

    Suggestions will be great help.

    Thank you

    sasraj

    Friday, July 10, 2020 12:35 PM

All replies

  • SQL Server 2017 standard would not be much cheaper but yes would be cheaper than SQL Server 2019. Still for long run SQL Server 2019 is suggested. If you find standard edition expensive then I believe you would have to redefine your database strategy

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Friday, July 10, 2020 1:41 PM
    Moderator
  • What is the capacity(Storage) of database, If the DB size would not go beyond 10 GB you can install SQL Server express edition which is free from Microsoft. You can install developer edition too as it is free till 90 days after that you can upgrade to either standard or enterprise (depends upon business) , for Licensing you need to contact to Microsoft.

    Br

    ChetanV

    Please mark me as answer if my post helps you.



    Friday, July 10, 2020 2:46 PM
  • Check this:editions-and-components-of-sql-server-version-15 and downlaod here: sql-server-downloads to test.


    And for detailed information about the license issue and price issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. 
    For international customers, please use the licensing_worldwide to find contact information in your locations. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web. People there will help you more effectively.


    Monday, July 13, 2020 1:49 AM
  •  You can install developer edition too as it is free till 90 days after that you can upgrade to either standard or enterprise (depends upon business) , for Licensing you need to contact to Microsoft.

    Dev edition is free for life time starting from SQL Server 2014. Before that 50$ was charge and you can use it for lifetime. What you are talking about is evaluation edition which is valid for 180 days only

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Proposed as answer by MIAOYUXI Tuesday, July 14, 2020 1:15 AM
    Monday, July 13, 2020 6:59 AM
    Moderator
  • Hi sasraj,

    Is the reply helpful?

    BR,

    MIAOYUXI

    Tuesday, July 14, 2020 1:18 AM
  • MIAOUXI can you let me know why you again proposed an answer which is not correct ? I unproposed an answer giving an reason and if you are proposing it again I believe you have give reason, explaining if I am wrong. 

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, July 14, 2020 8:31 AM
    Moderator
  •  You can install developer edition too as it is free till 90 days after that you can upgrade to either standard or enterprise (depends upon business) , for Licensing you need to contact to Microsoft.

    Dev edition is free for life time starting from SQL Server 2014. Before that 50$ was charge and you can use it for lifetime. What you are talking about is evaluation edition which is valid for 180 days only

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Yes Shashank, That's correct.
    Tuesday, July 14, 2020 8:43 AM
  • Hi Shanky_621,

    Strictly speaking, his response is indeed not rigorous enough, and even the validity period and the version are confused.However, some of the suggestions in the response are worth considering. Perhaps the questioner will be inspired and will go to google to find what he want. 

    BR,

    MIAOYUXI

    • Edited by MIAOYUXI Wednesday, July 15, 2020 1:12 AM
    Wednesday, July 15, 2020 1:11 AM
  • Hi sasraj,

    Is the reply helpful?

    BR,

    MIAOYUXI

    Wednesday, July 15, 2020 1:14 AM
  • Hi Shanky_621,

    Strictly speaking, his response is indeed not rigorous enough, and even the validity period and the version are confused.However, some of the suggestions in the response are worth considering. Perhaps the questioner will be inspired and will go to google to find what he want. 

    Not to take anything from Chetan but an express edition can go beyond 10GB it can have 10 GB data file and 20 GB log file making it 30 GB database. The 10 GB restriction is ONLY for data file so again the answer is not complete, yes mentioning express edition was good idea. But when you propose answer you are saying this is correct in all form. If you wanted to propose you could have asked Chetan to correct missing information and then propose. The fact is you did not read his answer completely. 

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Wednesday, July 15, 2020 8:18 AM
    Moderator
  • Hi sasraj,

    Is the reply helpful?

    BR,

    MIAOYUXI

    Thursday, July 16, 2020 1:15 AM
  • Hi,

    I'm following this open case and is the issue solved?

    You can choose to mark the helpful reply as answer  to close this case.

    BR,

    MIAOYUXI

    Friday, July 24, 2020 9:32 AM