3 ms·

Pretty close to free for me, $5 month basic sql server to play around with (only 2 gigs of data though). Wish they would make it free...

by tcarn 9y ago

lev99 9y ago
Mssql is significantly more expensive to run than postgres, Mongo, dynmodb, or mysql when you need a real sql server. This is true for both self hosted and cloud solutions. Dynmodb in AWS offers 25gb free. That's twelve times the storage without charging you a dime.
- philliphaydon 9y ago
  Dynamo db is not cheap at all. Writes are expensive and the structure of Dynamo is far from flexible and very limited in regards to querying. I don’t know what the usecase is for it.
  - lev99 9y ago
    >usecase Dynamo db handles burst traffic (scaling up and down on server count) better than mssql. Dynamo also handles big data better than sql. The last time I tried (2015) no amount of indexing or sharding was allowing for decent performance on joins across tables with 300+ million rows in sql server. I've seen dynmodb used in map reduce functions with more data. Dynamo also doesn't completely suck at typical transcational work, and it's convient to have one datasource across the warehouse and application layers.
    - philliphaydon 9y ago
      When I worked in Australia we had a client with ~1.5tb database in SQL Server, largest main table was about 2.5b records. Had no problem returning joined records in low ms times. Wouldn't be good if it had really high traffic but we wrote about ~1-2m records per day into the tables without issue reading it out. SQL Server can perform. But requires a lot of massaging. --- We tried using DynamoDB for logging, not sure why but the team had trouble with document sizes, write limits, in the end it was growing and going to cost more than SQL Server, was replaced with logging to PostgreSQL with much more flexibilty and runs on a t2.micro instance without issue.
- gigatexal 9y ago
  If windows licenses were free and SQL was too but they just upped the support contract pricing say by double I think that would change the game.

Pretty close to free for me, $5 month basic sql server to play around with (only 2 gigs of data though). Wish they would make it free...

by tcarn 9y ago

Pretty close to free for me, $5 month basic sql server to play around with (only 2 gigs of data though). Wish they would make it free...

lev99 9y ago

Mssql is significantly more expensive to run than postgres, Mongo, dynmodb, or mysql when you need a real sql server. This is true for both self hosted and cloud solutions. Dynmodb in AWS offers 25gb free. That's twelve times the storage without charging you a dime.

philliphaydon 9y ago
Dynamo db is not cheap at all. Writes are expensive and the structure of Dynamo is far from flexible and very limited in regards to querying. I don’t know what the usecase is for it.
- lev99 9y ago
  >usecase Dynamo db handles burst traffic (scaling up and down on server count) better than mssql. Dynamo also handles big data better than sql. The last time I tried (2015) no amount of indexing or sharding was allowing for decent performance on joins across tables with 300+ million rows in sql server. I've seen dynmodb used in map reduce functions with more data. Dynamo also doesn't completely suck at typical transcational work, and it's convient to have one datasource across the warehouse and application layers.
  - philliphaydon 9y ago
    When I worked in Australia we had a client with ~1.5tb database in SQL Server, largest main table was about 2.5b records. Had no problem returning joined records in low ms times. Wouldn't be good if it had really high traffic but we wrote about ~1-2m records per day into the tables without issue reading it out. SQL Server can perform. But requires a lot of massaging. --- We tried using DynamoDB for logging, not sure why but the team had trouble with document sizes, write limits, in the end it was growing and going to cost more than SQL Server, was replaced with logging to PostgreSQL with much more flexibilty and runs on a t2.micro instance without issue.
gigatexal 9y ago
If windows licenses were free and SQL was too but they just upped the support contract pricing say by double I think that would change the game.