Microsoft SQL Server Reviews & Product Details

What I like most about Microsoft SQL is the ability to link servers across and standardized architecture. We use it as a relational database for over 30 different systems. Review collected by and hosted on G2.com.

What I don't like about Microsoft SQL is the complicated user permissions within the software. We have multiple users that need different profiles and find it difficult to manage. Review collected by and hosted on G2.com.

This application works well on cross platforms. Integration and connectivity with other tool is easy.

We are easily able to manage the different database activities like create new db, table, stored procedue, cursor, trigger, function, data archiving etc. We can supply privilege to user(s) as per the need.

Sql server stored procedure are useful to avoid sql injection etc. because SP efficient code is good enough to validate the things nicely.

Sql server execution plan generates the query cost, reveals estimation of cpu, I/O cost etc. all these things helpful to analyse the performance of query. Application is good enough responsive. It's inbuilt automatic tuning functionality fixes the potential performance problem.

Database tuning is seamless as tuning advisor generates the details of missing indexes, statistics etc.

Sql server profiler is pretty much helpful to capture the details of sql queries.

It's Trace functionality allows us to extract the query execution information like query text, read and scan counts, db name where query actually executed, result count etc.

Database backup process is simple and quick. During backup it allows to set a password for the dbdump.

We are able to create and automate the jobs with different parameter like job run frequency and steps etc. Review collected by and hosted on G2.com.

Installation process takes a bit more time except that no issue observed. Review collected by and hosted on G2.com.

My favorite parts of Microsoft SQL Server are 1) the way Microsoft has implemented T-SQL to make it very easy to use and get information out of, and 2) the SQL Server Management Studio tool, my favorite SQL Database Management tool and code editor. Review collected by and hosted on G2.com.

I use a 3rd party add-on from RedGate called "SQL Prompt" to improve upon Microsoft's already great Intellisense. RedGate just takes things a little further than Microsoft does. Review collected by and hosted on G2.com.

It has a huge community to give you support which is great advantage. Has a good performance and simple to install/manage. Also, it came with disaster recovery which provide high availability. Review collected by and hosted on G2.com.

Licensing costs too high which yields limited features for standard version. Review collected by and hosted on G2.com.

Microsoft SQL comes as the Windows based systems, data storage for any scale of a data set. It can easily handle, manage the large scale of a data set. Its capability to provide online data and fail over management has helped to provide high availability. Review collected by and hosted on G2.com.

For commercial use you have to purchase licences, it has many licenses you have to choose and purchase the correct one. Review collected by and hosted on G2.com.

Microsoft SQL is very developer friendly and highly responsive tool. It made developer life very ease. I like the performance of the SQL even though you have data in GB. Debugging is of SP are very ease in SQL as compared to Oracle.This is a widely used DB with software developed in .net because the integration is very simply. Even in java product also it is widely used tool.Execution plan is vert helpful in tracking the performance and optimization of queries. Introduction inbuilt function for developer to make their work ease Review collected by and hosted on G2.com.

You have to be very certain in writing queries in SQL or else it will be a disaster in the performance. Because it u have huge data and your joins or indexes are not accurate then your performance will degrade heavily. Review collected by and hosted on G2.com.

There are many benefits of Sqlserver but the mail benefits that I love about sqlserver is its improved reliability, better performance. It has a increased scalibility over other databases and also reduced network traffic which makes this database to be one of the best database. It can be used mainly in various organisations which requires database to run their medium or large business.One best feature of microsoft sql server is its Express version or trail version which could be easily available without any cost so that users can try and use its some of the features prior to offering it to Microsoft. Review collected by and hosted on G2.com.

The worst part of SQL server is its deployment Cost means a very large amount of cost will be payable to Microsoft in case we have to use full features of SQLSERVER. Also another drawback is its limited compatibility means SQL server is designed to work on windows platform only and not on any other platform. All other part of Sql server is good. Review collected by and hosted on G2.com.

Store procedure, different sections for different projects , eaisy to insert, update and delete function. Use of multiple projects data in one SQL with perall processing. Review collected by and hosted on G2.com.

When we creating temp data table then we are unable to modify it after saving one time. Also problem in connecting with local server. Review collected by and hosted on G2.com.

The report on the changes and analysis of the system gives me stability and confidence in the system, it is perfect to have everything correctly configured and running. Review collected by and hosted on G2.com.

I have no complaints about this system, I like all its operation and support. Review collected by and hosted on G2.com.

SQL Server on Linux

Resumable online index rebuild

SQL Server machine learning services

Query processing improvements

Automatic database tuning

TempDB file size improvements

Smart differential backup

Smart transaction log backup

Improved SELECT INTO statement

Distributed transaction support

New availability groups functionality

New dynamic management views

In-memory enhancements

Security enhancement

High availability and disaster recovery

Performance improvements Review collected by and hosted on G2.com.

One of the major disadvantages to using Microsoft SQL Server instead of an alternative relational database management system is that the licensing options are pretty pricey. Although using the software for development or educational purposes is free, any sort of business use incurs a licensing fee. Review collected by and hosted on G2.com.