SQL Server 2017 Enterprise edition a need of an hour for large scaled businesses
What do you like best about the product?
MS SQL 2017 Enterprise edition supports graph databases which are useful when search operation crucial.
Enhanced security protection like Backup encryption.
Support for linux and docker containers.
What do you dislike about the product?
Nothing as such only thing is initial package installation size is large which can be reduced.
What problems is the product solving and how is that benefiting you?
To store large amount of business data in optimized way and to perform business intelligence operation on it by making it available all the time.
Microsoft SQL Server 2017 - Simple and Good
What do you like best about the product?
It is very simple and user-friendly for beginners.
Shows output in different views but can be improved.
You can manage many tasks in different tabs and retrieve them if accidentally closed.
What do you dislike about the product?
The output views can be improved.
Does not have different types of color theam to make a suitable environment for the user
What problems is the product solving and how is that benefiting you?
Manage database for software and websites.
It helps in checking, and resoving issues faced any time.
SQL Server 2017 - Improved Drastically
What do you like best about the product?
Easy to Use and easy to implement in the Premise. It is one of the most user-friendly DBMS which is maintaing our data securely and robustly.
What do you dislike about the product?
Almost every feature that a enterprise needs it caters but the charges are much higher for the same.
What problems is the product solving and how is that benefiting you?
It helped us to implement the AD, Partitioning and other DBMS features
Microsoft SQL Server 2017 Enterprise - Proven platform for enterprise your database operations
What do you like best about the product?
Ease of deployment and installation. Integrates very well with other Microsoft products and the cloud. Very easy administration with Microsoft SQL Manager. Ability to run SQL script on the management console.
What do you dislike about the product?
Sometimes databases need to be repaired/recovered after certain restoration operations when restoring from DB backup. It would have been nice to have a repair option in the interface instead of using the SQL commands to attempt recovery with the restore option.
What problems is the product solving and how is that benefiting you?
Microsoft SQL Server 2017 on Windows 2016 is our main database warehouse for managing all databases within multiple RDBMS platforms. From a single management console, we can easily operate and recover all our databases. In the past we were running several versions on different databases (including different vendors). Management of all those systems required skills as well as a learning curve. Having migrated to a single uniform platform allowed us to manage our database more efficiently and efectifely.
Easy to use, very straightforward
What do you like best about the product?
straightforward installation. Many documents for reference and the community is huge.
What do you dislike about the product?
sometimes DB seems slow and with the operating system getting stucked
What problems is the product solving and how is that benefiting you?
easy to manage, make life easy
Recommendations to others considering the product:
Design with high availability
Works - But needs documentation
Works well - but you need some kind of documentation. I struggled to get onto the SQL server.
Login as a local admin and then login into MS SQL Manager that way. You can then go into Security\Logins and enable the sa account.
How does one login to SQL Server?
Absolutely frustrating to figure out HOW to login to SQL Server on this box. Zero instructions! Happened to come here to the comments to find out from another user
You login using the local Administrator account.
This isn't anywhere in the documentation. Spin up the AMI, Domain Join if necessary. Login to the server as the login administrator, then open up MSSQL Management Studio and login using the Windows Authentication method...Add you login accounts from there. SA is also disabled out of the box.
No documentation on SQL passwords
I guess it might work ok - but I'll never know. There is zero documentation on the default credentials for SQL 2017, making it unusable. How hard would it be to include a brief document along with this AMI? I'd have been better off installing SQL Server myself.
