10 Microsoft SQL Server 2017 Web on Windows Server 2019 Reviews
One of the most important reasons for using this SQL server is that it provides seamless integration with the codebase. Easy to extract databases, supports most of the programming languages and the user interface is also very easy to interact with. Review collected by and hosted on G2.com.
One of the major drawbacks is that it is not very compatible with Windows 11. Initially, it works fine but eventually SQL server takes a large chunk of memory which as a result makes the overall system slow. As the database size increases it leads to an increase in retrieval time and even hangs sometimes. Review collected by and hosted on G2.com.
From my experience, Microsoft SQL Server 2017 Web on Windows Server 2019 offers a solid balance between performance and cost for web applications. I’ve found it particularly effective for small to medium-sized projects where you need reliable speed and good scalability without overspending. Review collected by and hosted on G2.com.
While it’s great for basic web applications, you miss out on advanced features like SQL Server Agent for scheduling and certain performance optimizations that are available in the Standard or Enterprise editions. I’ve also found the licensing model a bit restrictive since it's tailored specifically for web hosting, which can limit flexibility if your needs grow beyond that. Review collected by and hosted on G2.com.
I think that the best part is that it is compatible with any programming language you use. I have used SQL Server 2017 with Java, .NET and C#. A very good data management tool which helps you to store, retrieve, modify and delete records in the DBMS. The SQL queries used are also very easy to learn. The software is very easy to install and use. Review collected by and hosted on G2.com.
Storage is the biggest problem. The SQL Server takes up a lot of memory space, by which the system becomes extremely slow. Another concern is about a technical issue we faced, but the free customer support was not adequate, so we had to go for the paid support. Other than that, no other issues so far. Review collected by and hosted on G2.com.
- The hybrid cloud integration capability let us run the application easily in containers
- Automaticdatabase tuning feature is really a gamechanger in improvising the query performace . Review collected by and hosted on G2.com.
the web feature has some limitation when compared to standard edition of the software. Review collected by and hosted on G2.com.
the reliability of the solution along with security gives developer good confidence to use it along with the maturity and less issues. Review collected by and hosted on G2.com.
windows pathing along with sql server patching can make it unstable at times and also the licensing cost is also a concern Review collected by and hosted on G2.com.
Fond of the ease of development it comes with regarding to my web APIs irrespective of programming language boundaries. Data handling and management is truly commendable as there's no negotiation in the performance. Review collected by and hosted on G2.com.
While utilising the service during my data analysis I often face difficulties due to the memory space constraint. Often due to excessive data load, the service tends to fail in run-time. My suggestion would be increasing the memory division more effectively. Review collected by and hosted on G2.com.
I appreciate how I can quickly utilise it to construct my core Java web APIs and entity foundation using code and database approaches. Aside from that, it helps me with my Machine Learning projects. It has excellent data handling capabilities. Review collected by and hosted on G2.com.
The overall cost of subscribing to this database server is quite expensive. Memory restrictions are the major drawback at times. We need to extend the database's limit, which doesn't go well here. The limit is up to 64 GB only. Review collected by and hosted on G2.com.
I like how I can easily use it to develop my .Net Core web API and entity framework using both methods, code first and database first. I have also been using this database for my Data Science projects both small machine learning projects and data analysis Review collected by and hosted on G2.com.
The maximum memory utilized per instance is only 64GB which is a problem when I want to run instances that require a memory that is larger than 64 BG Review collected by and hosted on G2.com.
Retreiving records from sql server is quite easy. Easy to store data. Compatible with many languages like c++, java, kotlin, c sharp. Can be used as a db storage tool and which can be connected to fromt end like react js. Review collected by and hosted on G2.com.
its expensive like all microsoft products, licensing is bit complex and sometimes takes time in loading. Review collected by and hosted on G2.com.
It is easy to use but still provides high perfoamance. Review collected by and hosted on G2.com.
It was only designed with small organisations in mind. Review collected by and hosted on G2.com.
