Microsoft SQL Server Reviews & Product Details

Microsoft sql is a wonderful tool for doing data analysis, even for those without a huge technical background. it is easy to learn. Review collected by and hosted on G2.com.

There are some built in functions within other data base software that would be beneficial to use. Review collected by and hosted on G2.com.

Functionality:

The amazing provided functions made available for data sorting, analysis and manipulation is a strong selling-point for the software.

It also provides leverage to interact with other microsoft softwares (like powerpoint) for obtaining data Review collected by and hosted on G2.com.

A step towards making the software more interactive especially in terms of error statements can improve its user-friendliness. Artificial intelligence can be used to achieve this Review collected by and hosted on G2.com.

Great Database to manage large data storage with efficient update and delete operations. Provides numerous inbuilt library to use in writing sql queries efficiently. Sql server provides many handy tools like Query analyzer, Resource manager, Profiler, Sql job agent etc which are very helpful tools in debugging and fixing potential issues in production. Query execution plan is a great feature to find resource consuming query. Integrating third part plugin is easy with SQL Server. Review collected by and hosted on G2.com.

There is nothing i could say incorrect about it but i think there should be some warning for performance affecting queries. Review collected by and hosted on G2.com.

Easy to install, good set of management tools included at no extra charge. Stable and very versatile. Review collected by and hosted on G2.com.

It has been a while since I used reporting services, but at the time I felt it was a little too basic. Review collected by and hosted on G2.com.

Easy to use, has less complicated user interface than many other db developer tools. There are buttons for all execution actions. User interface is very easy and less complex. Can be trained in 2-3 days to use it after installation for development tasks and testing. Review collected by and hosted on G2.com.

No easy way to see schemas and other structures of the data base. Seeing schemas used to help me with a lot of decisions I had made in my past client projects. But here it's not so easy to find tables easily. Review collected by and hosted on G2.com.

I have used this tool for Production planning and quality management purpose where the database was limited in size for a specific project and I have found it very lite and easy to use Standard SQL commands works but there are minor difference from PLSQL but I found MS SQL more easy to use Review collected by and hosted on G2.com.

Only few commands are different only because I had a experience in PLSQL.

Otherwise it is fine

Review collected by and hosted on G2.com.

Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases Review collected by and hosted on G2.com.

Only I know very least number of disadvantages this MS SQL server 2016 is having:

1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having.

2 With the performance tuning, Microsoft SQL Server will be having some gobble resources Review collected by and hosted on G2.com.

Really, MSSQL is like most any other DB on the market. The biggest perk for me is the ability to integrate certain features of it with AD natively, as opposed to having to make it work with AD, this is particularly in terms of user authentication. Review collected by and hosted on G2.com.

Nothing really. It does the job. However if I had to pick one thing, it would be the licensing as it can be a bit painful to navigate. Review collected by and hosted on G2.com.

The tools around and the ability to write store procedures for automation. Review collected by and hosted on G2.com.

The price and the need of good server to run (big databases) Review collected by and hosted on G2.com.

i like the data recovery part from the SQL server compared against the other RDBMS, using the help of log files and cache. i would also like the standards that are defined in SQL server compared to the other competitor products. Review collected by and hosted on G2.com.

Cost is the part where i think it's on the high side compared with other RDBMS also with the limited compatibility. Review collected by and hosted on G2.com.