4 ms·

Depending on your tech, staging environments can be very expensive, SQL Server Enterprise licenses at 13k for 2 cores. https://www.microsoft.com/en-us/sql-serve

Depending on your tech, staging environments can be very expensive, SQL Server Enterprise licenses at 13k for 2 cores. https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing https://www.microsoft.com/en-us/sql-server/sql-server-2019-p...

coder543 5y ago
If you're choosing to pay large sums of money for SQL Server instead of the open source alternatives, you should also factor in the large sums of money to have good development/staging environments too. All the more reason to just use Postgres or MySQL. EDIT: as someone else hinted at, it does look like the free Developer version of SQL Server is fully featured and licensed for use in any non-prod environment, which seems reasonable.
- rileymat2 5y ago
  Sure different planning 20 years ago would have made a big difference. Or the will/resources to transition. I am just saying that this scenario exists.
jiggawatts 5y ago
Non-prod is free.
- deleted 5y ago
  [deleted]
- rileymat2 5y ago
  The developer version, yes. But I have not seen the AWS amis for the developer version: https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-ec2-microsoft-sql-server-windows-ami/ https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-ec... You can't install the enterprise non-prod for free. (But the developer version is supposed to have all the features)
  - booi 5y ago
    It's pretty easy to create your own amis with developer versions. It makes sense why AWS doesn't necessarily provide this out of the box. But it still stands for fully managed versions of licensed software, you'll pay for the license even if it's non-prod
    - rileymat2 5y ago
      Yes, that's not to say it is not possible to create a similar env, but I thought the debate was how precisely you are replicating your production env. Sure it may be "good enough", but I thought the debate was about precision. How your own ami setup may differ from the AWS built from the developer version compared to the AWS ami? I don't know. Trying for an identical setup in staging is expensive, this is just a scenario I am familiar with. I am sure there are a lot like this.
      - nickelpro 5y ago
        I was thinking about this line from the article: > More often than not, each environment uses different hardware, configurations, and software versions. They can't even deploy the same software versions to their staging environment. We're a long way off talking about precisely replicating load characteristics
colonwqbang 5y ago
You could call that an infrastructure problem. You have built an expensive infrastructure which you cannot afford to scale to the extent you desire.
bob1029 5y ago
> Depending on your tech, staging environments can be very expensive For our business & customers, a new staging environment means another phone call to IBM and a ~6 month wait before someone even begins to talk about how much money its gonna cost.
Pxtl 5y ago
That's per server, not per database. I have dozens of staging databases on my sql server - product_name_pr_id.

coder543 5y ago

If you're choosing to pay large sums of money for SQL Server instead of the open source alternatives, you should also factor in the large sums of money to have good development/staging environments too. All the more reason to just use Postgres or MySQL. EDIT: as someone else hinted at, it does look like the free Developer version of SQL Server is fully featured and licensed for use in any non-prod environment, which seems reasonable.

rileymat2 5y ago
Sure different planning 20 years ago would have made a big difference. Or the will/resources to transition. I am just saying that this scenario exists.

jiggawatts 5y ago

Non-prod is free.

deleted 5y ago
[deleted]
rileymat2 5y ago
The developer version, yes. But I have not seen the AWS amis for the developer version: https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-ec2-microsoft-sql-server-windows-ami/ https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-ec... You can't install the enterprise non-prod for free. (But the developer version is supposed to have all the features)
- booi 5y ago
  It's pretty easy to create your own amis with developer versions. It makes sense why AWS doesn't necessarily provide this out of the box. But it still stands for fully managed versions of licensed software, you'll pay for the license even if it's non-prod
  - rileymat2 5y ago
    Yes, that's not to say it is not possible to create a similar env, but I thought the debate was how precisely you are replicating your production env. Sure it may be "good enough", but I thought the debate was about precision. How your own ami setup may differ from the AWS built from the developer version compared to the AWS ami? I don't know. Trying for an identical setup in staging is expensive, this is just a scenario I am familiar with. I am sure there are a lot like this.
    - nickelpro 5y ago
      I was thinking about this line from the article: > More often than not, each environment uses different hardware, configurations, and software versions. They can't even deploy the same software versions to their staging environment. We're a long way off talking about precisely replicating load characteristics

colonwqbang 5y ago

You could call that an infrastructure problem. You have built an expensive infrastructure which you cannot afford to scale to the extent you desire.

bob1029 5y ago

> Depending on your tech, staging environments can be very expensive For our business & customers, a new staging environment means another phone call to IBM and a ~6 month wait before someone even begins to talk about how much money its gonna cost.

Pxtl 5y ago

That's per server, not per database. I have dozens of staging databases on my sql server - product_name_pr_id.