Microsoft Windows Server 2016 with SQL Server 2017 Enterprise Reviews & Product Details

Microsoft windows 2016 support on SQL 2017 makes the legacy OS (Windows 2012 R2 to 2016) upgrade path much easier without compromising the application performance.

Environment running in hybrid can evolve to cloud adaption smoothly.

Automatic Plan Correction is very great features in SQL 2007 enabled, SQL Server monitors query performance using Query Store data.

Identity cache is helpful to avoid discrepancy in values of identity columns, in the case of unexpected shutdown or patching scenarios.

Support is really good from MS on the database issue guidance and implementation perspective Review collected by and hosted on G2.com.

New Features of SQL 2017 are not added automatically after the upgrade from previous version. Administrators prefer to add the new features automatically which is not impacting performance or affect the application.

Findings the difficulties of In-place troubleshooting documents in MS official site. Availability troubleshooting documentation and known issues during upgrade will be really helpful for administrators to avoid the downtime. Review collected by and hosted on G2.com.

The integration capability between Windows Server 2016 and SQL Server 2017 Enterprise ensures smooth communication, allowing efficient data transfer and processing. There is container support facilitating easy deployment, scaling, and management of applications across various environments. Possibility of cloud integration - seamlessly integrate with Microsoft Azure services, providing a pathway for hybrid cloud solutions. Support for modern data types - like JSON and graph data types in SQL Server 2017, enabling efficient handling of diverse data formats. Windows Server 2016 provides a user-friendly interface and management tools, simplifying the administration of both the server and SQL Server instance. Review collected by and hosted on G2.com.

It is pretty resource-intensive, requiring powerful hardware, which could be a challenge for organizations with limited IT infrastructure. Vendor lock-in - relying solely on Microsoft solutions may result in vendor lock-in, making it challenging to switch to alternative technologies in the future. Review collected by and hosted on G2.com.

We have hosted our lower environment dev and QA with Microsoft Windows Server with SQL Server, which is reliable and easy to use. The GUI is very user-friendly and makes it easy to track all the processes that are running. Even the long-running queries are easily identified, and we are able to solve most of the slowness issues. It's easy to connect with our application from a Kubernetes environment. Review collected by and hosted on G2.com.

When we log in to the machine via Microsoft Remote Desktop app, the Windows machine is very slow to use, and copy-paste between the actual Mac and the Windows machine is not working properly. Other than this, I don't see any issue with this Windows Server. Most of the time, I used to copy SQL queries from local to remote machine, and it's difficult over there. Review collected by and hosted on G2.com.

I like how Microsoft Windows Server 2016 with SQL Server 2017 Enterprise kicks it up a notch! It runs like a champ, super secure with all those fancy features, and the way it smoothly handles databases and servers together is just awesome – makes my tech life a breeze. Review collected by and hosted on G2.com.

Microsoft Windows Server 2016 with SQL Server 2017 Enterprise is pretty solid, but the licensing fees can be a bit steep. And oh boy, setting it up can be a headache, especially if you're not a tech whiz. Plus, every now and then, you run into compatibility hiccups with other apps, which can be a bit annoying. Review collected by and hosted on G2.com.

SQL Server 2017 Enterprise is pre-installed inside the VM with applicable license so that you do not need to worry about installing the SQL software inside the VM after deployment of VM. Performance is quite high and comes up with auto indexing and auto defragment of disk for performance optimizing purposes. Standard Customer support from AWS is quite good. Review collected by and hosted on G2.com.

Since it is pre-installed, you can't customize the pre-configurations of SQL Server. In case we want to deploy the standard or express edition of the license, then this VM is of no use for you. For customer support, you have to reach out to the AWS team without going directly to Microsoft. Review collected by and hosted on G2.com.

First of all I like the ease of installation and its deployments. It offer all enterprise database operation at ease and at the same time keep all data secure. I also like its ability to run SQL scripts in the management console. Review collected by and hosted on G2.com.

There is nothing to dislike except sometime DB query run slow which should be improved upon. Also if DB repair option will be provided in console, it will be great though SQL command are available. Review collected by and hosted on G2.com.

Support in different platforms including several operating systems. Enables security by giving users access depending on roles and permissions outlined by the organization with no limit of speed. Great password policy that enforces users to use strong passwords that are renewed occasionally. Review collected by and hosted on G2.com.

Upgrade to latest windows server version is not easy and sometimes not supported. Recycle bin should be added feature to provide retrieval of documents deleted by mistake. Review collected by and hosted on G2.com.

Microsoft Windows Server 2016 with SQL Server 2017 makes customized configuration implementation very easy, which helps in managing group, policy, and access controls. They have very good customer support who not only helps in issue troubleshooting but also eases the integration process. They have numerous features, some of which include hybrid cloud integration, container support, and flexible integration. Their services are frequently used by business analysts. Review collected by and hosted on G2.com.

Despite multiple advantages, it has a few disadvantages as well. For instance, there is a fixed lock-in period that needs to be signed with the vendor. It is also a bit costly. It requires powerful hardware, which increases the cost of implementation as well. Review collected by and hosted on G2.com.

Microsoft Windows Server 2016 with SQL Server 2017 Enterprise is a great product with the ease of installation and its deployments. It provide features to run SQL scripts in the management console. Also, it provide database operation at ease and at the same time keep all data secure. Review collected by and hosted on G2.com.

Sometime I have seen that database query runs slow involving multi join SQL statements and this definitely needs a improvement. Review collected by and hosted on G2.com.

its provide a smooth transition from Excel and straightforward to use. The best part is that compared to MySQL,it's far more intuitive. Admin Controls and database sources are simple and abuntantly described. Review collected by and hosted on G2.com.

There is a dire dearth of reporting services. For this need, apache might provide an alternative, or it might even provide integration with Windows servers Review collected by and hosted on G2.com.