Microsoft SQL Server 2016 Express on Windows Server 2016 logo

    Microsoft SQL Server 2016 Express on Windows Server 2016

    SQL Server on AWS has lower TCO, higher performance, and the broadest and deepest capabilities. This SQL Server Amazon Machine Images (AMI) is built by Amazon Web Services (AWS) for use on Amazon EC2, the proven, reliable, and secure place for SQL Server.

    Ratings and reviews

    4.3
    2 ratings
    3 star
    2 star
    1 star
    50%
    50%
    0%
    0%
    0%
    0 AWS reviews
    |
    2 external reviews
    External reviews are from G2 .

    Filters

    Review type

    AWS Marketplace reviews
    External reviews
    Reviews (2)
    David W.

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

    Reviewed on Mar 15, 2022
    Review provided by G2
    What do you like best about the product?
    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 about the product?
    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 is the product solving and how is that benefiting you?
    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

    Reviewed on Mar 08, 2022
    Review provided by G2
    What do you like best about the product?
    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 about the product?
    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 is the product solving and how is that benefiting you?
    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.