Microsoft SQL Server 2016 Standard on Windows Server 2016

What do you like best about the product?

What i like most about microsoft sql server is cost effectiveness supporting the web based applications and hosting scenarious.SQL Server 2016 Web Edition supports scalability, allowing businesses to scale their web applications as needed. This is crucial for accommodating growth and increasing demand without facing significant limitations.SQL Server 2016, including the Web Edition, incorporates robust security features to protect data integrity and confidentiality. This includes encryption, access controls, and auditing capabilities.

What do you dislike about the product?

Depending on the scale and complexity of your web applications, SQL Server 2016 Web Edition may be resource-intensive. Businesses with high transaction volumes or complex queries may need to carefully manage server resources to ensure optimal performance.The Web Edition lacks certain enterprise-level features that are available in editions like SQL Server Standard or Enterprise. Organizations with advanced requirements may find themselves needing features that are not present in the Web Edition.

What problems is the product solving and how is that benefiting you?

SQL Server 2016 Web Edition supports scalability, allowing organizations to scale their web applications as needed. This is particularly beneficial for businesses experiencing growth in web traffic or data volume.SQL Server 2016, including the Web Edition, incorporates robust security features. This helps organizations protect sensitive data and maintain the integrity and confidentiality of their databases, which is crucial for web applications dealing with user information. SQL Server Management Studio (SSMS) provides a user-friendly interface for managing and administering SQL Server databases. This ease of management is beneficial for organizations with web developers and administrators who need efficient tools for database tasks.

What do you like best about the product?

Many more features like DB backup, monitoring and SQL server job creation features are also used and liked

What do you dislike about the product?

I feel that they should bring a document type of database concept

What problems is the product solving and how is that benefiting you?

maximum benefits to GUI application while support to provide data visibility from the back end.

What do you like best about the product?

Cross platform usability along with very complete business intelligence capabilities. Ability to integrate with various applications is another added features.

What do you dislike about the product?

Just need to be more developer friendly with detailed and comprehensive error message. Also need to have additional new and modern functions.

What problems is the product solving and how is that benefiting you?

Storing high frequency data and a data warehouse for analytical purposes

What do you like best about the product?

The questions which had asked in the assessment made me to learn few new things and that helped me to enhance the skill , competitors feel this is hard assessment to finish

What do you dislike about the product?

I have nothing like dislike there is nothing that is missing or nothing like not working properly , there is nothing to be improved you people are the best and improved me

What problems is the product solving and how is that benefiting you?

You're dealing with an application whose newest supported version is only SQL Server 2014 , but not 2016. Or newer . you want to use Always On Availibility Groups

Recommendations to others considering the product:

Yes I will recommend considering Microsoft SQL

What do you like best about the product?

In memory improvements
Row level support

What do you dislike about the product?

Database may face out of space error
Client loses connection to the sql server

What problems is the product solving and how is that benefiting you?

Provides optimized performance
Better security and offers large sized database

What do you like best about the product?

Easy to learn quiries and procedures for users

What do you dislike about the product?

I don't have any thing to dislike sql server

What problems is the product solving and how is that benefiting you?

Sql provides very fast db access to get huge data.

Recommendations to others considering the product:

I

What do you like best about the product?

Microsoft has made it easy to export databases. It is easy to configure/implement.

What do you dislike about the product?

There is no graphical report, so when you run the reports, it is all in script, which makes it hard to read.

What problems is the product solving and how is that benefiting you?

It takes a lot of data from multiple sources and consolidates it into one. It helps when you have many employees that they are all working off of

What do you like best about the product?

The scalability option is an advantage to mission-critical applications.

What do you dislike about the product?

2016 SQL server has OLAP queries performance issues

What problems is the product solving and how is that benefiting you?

SQLserver 2016 Web is being used for hosting databases and storing records, and many more.

What do you like best about the product?

Easy to create and write queries comparing to other sql servers

What do you dislike about the product?

nothing, everything is there in the best

What problems is the product solving and how is that benefiting you?

Customer data and sales data and purchase data

What do you like best about the product?

TOP relational databases are MS-SQL , Oracle and others.
MS-SQL server has very compatible with normal companies to do their Billing System, Customer care , Data management .
Oracle Database is much complicated than MS-SQL , but usually better to use big companies who has TB Data-s.

What do you dislike about the product?

I will say migration Data-s to new Versions usually takes lots of time and knowledge.

What problems is the product solving and how is that benefiting you?

Easy to optimaize, Text search is different, quick.

Recommendations to others considering the product:

Best relational database