Microsoft SQL Server Reviews & Product Details

It is very easy to create store procedures, at the same time it is simple to use triggers and jobs, easy to access within the Intranet, working with multiple users is smooth, Shirink transactions are a feature that makes it easy for me. Review collected by and hosted on G2.com.

I use it for my personal work both in my company and at home, and I haven't found any aspect of my menu that I don't like. Review collected by and hosted on G2.com.

When Application required most important aspect its the performance which is directly propotional to large volume of Transaction . In that area Microsoft SQL Server stands best once you choose the Right DB , rest effortlessly SQL server handles all .Also it is best of breed in analytics sector which helps me to tell my Data as story where to improve . Hence I like the most . Review collected by and hosted on G2.com.

Scalability has some configration challenges but with stiff learning curve this can be overcome . During consistency check of Transaction , it may have certain challenges like other Relational Databases . Review collected by and hosted on G2.com.

First thing I really like about MS SQL server is how we can run a part of the query by just selecting that part and just running it.

In MS SQL server it's really easy to switch databases, and it's really convenient to upload files on SQL server.

It conveniently handles different types of files. Review collected by and hosted on G2.com.

Downside of Microsoft SQL server is that some functionalities does not work like openJson and similar that works in Mysql. Also while handing bigger data like (100 gbs) it becomes slower and it makes other processes slow as well. Review collected by and hosted on G2.com.

Being able to make queries in different tables to cross-reference information Review collected by and hosted on G2.com.

The SQL backup takes a long time and slows down the system. Review collected by and hosted on G2.com.

There are multiple versions of SQL servers like Developer and Express which can be separately used for development and production making it easy to enable advanced flags and features using development for debugging. Review collected by and hosted on G2.com.

There is no inbuilt High Availability and Disaster Recovery mechanism. So we have to manually set this causing us to maintain multiple servers. Review collected by and hosted on G2.com.

I think any furture Analyst should know how to use the SQL. It is not difficult to learn how to write an query. SQL help us to track and organize data from big database quickly. Review collected by and hosted on G2.com.

it does not have an AI to help us to create queries or write an optimized query. Review collected by and hosted on G2.com.

Microsoft SQL server enable user to easily implement datawarehousing and machine learning it has n number of features like sealization,snapshot,backup it also allows to integrate data from multiple sources which helps in analysing and process data at one place there customer support team always stand by your side if you face any challanges. They provide good platform for beginners which increases the frequncy of use .Its disk management and partitioning algorithms makes it very ease to use for data management. Review collected by and hosted on G2.com.

Sometimes we face challenge to run microsoft SQL servers on multiple processor so we generally give one strong processor. Review collected by and hosted on G2.com.

Microsoft SQL server also have a free option for small applications. Review collected by and hosted on G2.com.

Performace issue occur when use with bigger databases. Review collected by and hosted on G2.com.

●Ease of Implementation

●Easier learning platform for queries

●Much secured than others

●A Microsoft original product which is still trusted even after 40 years Review collected by and hosted on G2.com.

The biggest issue is it's slowness with large dataset Review collected by and hosted on G2.com.

Ease of data handling and software integration. Review collected by and hosted on G2.com.

Support required for patch installations. Review collected by and hosted on G2.com.