Sign in
Categories
Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

SQL Server 2016 Express on Windows Server 2016

Cognosys Inc. | 22.05.1400

Windows, Windows Server 2016 Base 22.05.1400 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

2 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    David W.

Light version of a robust, reliable database engine on a secure, modern operating system

  • March 15, 2022
  • Review provided by G2

What do you like best?
I've always loved Microsoft SQL Server, and for .NET developers it is an excellent choice of database engine. The Express version is the lightest form but can still be managed through SSMS, however is more license-friendly and this combination - SQL Server 2016 Express on Windows Server 2016 - makes a lot of sense for a data-driven website platform, for example. You can host it outside your organisation and know your .NET apps will run reliably and robustly, your developers and DBAs can work with the data easily, and your licensing costs are reduced. SQL Server 2016 is where Microsoft added a lot of great features like query store and in-memory facilities.
What do you dislike?
On the downside, if you're hosting this product outside your environment and rely on a third-party provider there is, of course, a licensing fee for Windows Server 2016 and SQL Server 2016 Express, compared to open-source options like Linux and MySQL.

Additionally, the way SQL Server Express installs itself can lead to some developers or administrators inadvertently creating database servers like hostname\sqlexpress instead of simply hostname. It's important to be careful when setting it up to ensure you do so in the way you really want.
What problems are you solving with the product? What benefits have you realized?
We used it for our externally-hosted public-facing website. Our website was an in-house app with many facilities to capture customer requests, provide services, etc., with a lot of API-driven components, content management for our marketing team, and other dynamic features. Being a Microsoft / .NET environment this combination of server and DB was ideal for us and for the team who had a lot of SQL Server experience and affection.


    Computer Software

Great features out of the box

  • March 08, 2022
  • Review provided by G2

What do you like best?
The installation process is very simple. Replication is easy to configure and understand unlike other flavours of SQL. The management tool SSMS is very mature and comes with functionality to help you administrate your clusters.
What do you dislike?
There is nothing to dislike about the product. The one thing to consider though is the pricing, which can be quite expensive for small to medium businesses. It's best to obtain using enterprise agreement with MS.
What problems are you solving with the product? What benefits have you realized?
On premises to cloud replication has been easier than anticipated using SQL Server 2016. We have found the replication to be very reliable thus far since being setup with not too much maintenance required.


showing 1 - 2