Microsoft SQL Server Reviews & Product Details

Ease of ability to write easy SQL Queries and manipulate Data model and Data. Review collected by and hosted on G2.com.

Not much, but the support of multiple SQL joins could be significant. Review collected by and hosted on G2.com.

Query part, storing database, declaring variables, excetion handling, stpred procedure, parameterized query and many more thing Review collected by and hosted on G2.com.

No dislikes so far. Its good tool but functionality wise UI frature could improve Review collected by and hosted on G2.com.

Assuming you know the basics of SQL, pulling data is a fairly simple process. Review collected by and hosted on G2.com.

When a query does not work, it would be helpful if there was some guidance. Review collected by and hosted on G2.com.

The queries in MS SQL are easy to understand. There is no complexity in writing or understanding the queries. Easy and simple query structures and commands makes you understand the purpose of the statement easily. Installation is easy Review collected by and hosted on G2.com.

Licensing is a complex part. One need to be careful. UI takes time to understand. Cost for the enterprise editions is not affordable. Review collected by and hosted on G2.com.

easy to use

normalization

great UI

good connectivity Review collected by and hosted on G2.com.

Nothing as such. This tool has global presence Review collected by and hosted on G2.com.

Relational Data Workhorse which does great Reporting, Agent tasks, ETL, I have been using it for over 20 years and is an extremely solid platform Review collected by and hosted on G2.com.

It does not scale very well, and handle large workloads and do key value caching. Also it does not Natural Language Processing very well Review collected by and hosted on G2.com.

As I am using this product from last 6 years I am very much happy with the features that SQL provides some of them are:-

1. SQL is best for managing data in the relational forms so that the data integration and consistency maintain properly.

2. As SQL supports most of the data types like (int, char, varchar, float etc..) which makes developer life easy to integrate with and application and language.

3. SOL also provides the bulk insertion and extraction of data and also supports the different data source like excel , notepad and all..

4. SSIS and SSRA are the best and ever green feature of the SQL. Review collected by and hosted on G2.com.

I do not have much complaints on dislike about the product .But just wanted to highlight one observation

Error handling mechanism can be much better so that the developer can get to know exact issue in SQL scripting.

Because most of the time SQL compiler not showing expected error message and no suggestion as well.

This is the only one I would like to highlight in dislike section. Review collected by and hosted on G2.com.

Power to pull data out of tables and create information. Review collected by and hosted on G2.com.

Learning curve necessary to install and build scripts. Review collected by and hosted on G2.com.

Microsoft SQL Server is a long and well established database product that provides complete relational db possibilities for integrating into cloud, web, and windows projects. In addition it's connectors have the ability to relate to the full microsoft ecosystem of products which comes in handy setting up power platform apps, workflows, and sharepoint sites. microsoft has taken great pains to continually improve performance, indexing and integration abilities over the years. The product enables us to provide best in class relational database management capabilities to all over our client's websites. Review collected by and hosted on G2.com.

it is large scale so if you are looking for something lightweight for smaller websites it is probably not for you. it also takes some learning curve and is helpful to have a dedicated admin in full IT environments. however this can be overcome by the wealth of information available out there due to it's longevity as a product. Review collected by and hosted on G2.com.

It is a powerful relational database that projects a sophisticated scope in the analytical areas of each document or in the information sources of a particular department, highlighting that I love its flexibility to an environment that is easy to use and understand once that its servers are installed on a platform, logically being one of my favorite aspects in relation to the system, mentioning that it maintains extraordinary access for users and its proper administration in general areas, since they are very simple in their entirety. Review collected by and hosted on G2.com.

One of the most outstanding nonconformists of this system is related to payments for its support, which is somewhat incoherent, in which most similar systems proceed to establish these free services, highlighting that it is a very nefarious quality, since on occasions it tends to fail frequently, and requires the use of its support, being a very high economic commission, when it comes to constant use, without excluding that you must acquire more capabilities for generating reports. Review collected by and hosted on G2.com.