Microsoft Windows Server 2016 with SQL Server 2017 Enterprise Pros and Cons

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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 guidence and implementation perspective Review collected by and hosted on G2.com.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

The integration capability between windows server 2016 and sql server 2017 enterprise ensures smooth communication which allows efficient data transfer and processing

There is a container support facilitating easy deployment, scaling and management of applications across various environments

Possibility of cloud integration - seamlessly integrate with Microsoft azure services providing 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.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

It is pretty resource intensive requiring powerful hardware which could be a challenge for organization 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.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

we use have hosted our lower env dev and qa with microsoft windows server with SQL Server which is reliable and easy to use. GUI is very friendly to use and easy to track all the process that are running. even the long running quries are easyly identified and we would able to solve most of the solwness issues.Its easy to connect with our application from k8 enviroment Review collected by and hosted on G2.com.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

When we login to the machine via microsoft remote desktop app, 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 dont see any issue with this windows server. Most of the time i used to copy sql quries from local to remote machine its difficult over there. Review collected by and hosted on G2.com.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

Since it is pre-installed so you cant customize the pre-configurations of sql server, In case we want to deploy standard or express edition of license then this vm is of no use for you, For customer you have to reach out to AWS team without going directly to microsoft. Review collected by and hosted on G2.com.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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 password tha are renewed occassionally. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

Upgrade to latest windows server version is not easy and sometimes not supported.

Recycle bin should be added feature to provide retrival of documents deleted by mistake. Review collected by and hosted on G2.com.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

Microsoft Windows Server 2016 with SQL Server 2017 makes customized configuration implementation very easy which helps in managing goup,policy and access controls .They have very good customer supports who not only helps in issue troubleshooting but also ease the integration process . They have n numbers of feature out of which some of them are hybrid cloud integration,container support,flexible integration. There services are frequently used by business analysit. Review collected by and hosted on G2.com.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

Despitre of multiple advantages it has few siadvantages as well. Like there is a fix lock in perior needs to be sign with vendor.It is bit costly as well.It required powerfu; hardware well which increase the cost of implementation as well. Review collected by and hosted on G2.com.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you like best about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.

What do you dislike about Microsoft Windows Server 2016 with SQL Server 2017 Enterprise?

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.