Microsoft SQL

(944)
4.3 out of 5 stars

SQL Server 2017 brings the power of SQL Server to Windows, Linux and Docker containers for the first time ever, enabling developers to build intelligent applications using their preferred language and environment. Experience industry-leading performance, rest assured with innovative security features, transform your business with AI built-in, and deliver insights wherever your users are with mobile BI.

Work for Microsoft SQL?
Informixenterpriseedition 2x

Learning about MS SQL?

We can help you find the solution that fits you best.

Find the Right Product

Microsoft SQL Reviews

Request More Information
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
  • For Category
Ratings
Company Size
User Role
User Industry
For Category
Showing 952 MS SQL reviews
LinkedIn Connections
MS SQL review by <span>Al W.</span>
Al W.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Microsoft SQL Server Serving the Masses

What do you like best?

MS SQL Server is a robust, well-established relational database manager. Support for it exists in so many forms. Microsoft of course provides the primary source as the producer and ultimate authority on the product. However, there is an abundance of forums, blogs and users groups with a wealth of information, whether you need to troubleshoot an error, solve a problem or what tips and shortcuts for everyday tasks.

What do you dislike?

It's a Catch-22. For all of the prestige of being so feature rich and robust, it is a complex product with many nuances that differ from the version in the year 2000 to today. Managing the change and keeping up require real effort and occasionally it's best just to pay an expert.

Let's talk about licensing. If major re-sellers have people whose title and sole purpose is Microsoft Licensing Specialist, then things have gotten out of hand.

Recommendations to others considering the product

If you don't have the expertise in house, look carefully bringing in a consultant to set it up right the first time. It will work with default settings but a few hours with an expert can save a lot of time

What business problems are you solving with the product? What benefits have you realized?

Our primary line of business programs run on Microsoft SQL Server. It is a foundational component of our IT infrastructure and is not implemented to solve problems so much as it carries the load. You could say it solves the problem of needing a fully stable platform upon which to run the business.

Sign in to G2 Crowd to see what your connections have to say about Microsoft SQL
Headshots
MS SQL review by <span>Diego V.</span>
Diego V.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

A robust transactional database, tried and true

What do you like best?

If you are working from scratch, it's relatively easy to set up a new database server and connectivity between clients. Everything is pretty much straightforward, given that you have some database knowledge. The DBMS allows you to easily create several things entirely in design (tables, views, etc) - which is a big plus when you don't know the entire syntax.

What do you dislike?

Some of the setups of older versions (2008 - 2012) are rather clunky and not very well made - I have had several instances of my installer being corrupt and having to redownload. The database administrator is, at some times, slow to load.

Recommendations to others considering the product

Consider all available replìcation scenarios, as newer versions contain even better features (SQL Always On, comes to mind) where log shipping or others may not be necessary.

What business problems are you solving with the product? What benefits have you realized?

All the transactional data for our customer is handled in Microsoft SQL. The customer requires a high availability and quick response system; where SQL helps in.

What Relational Databases solution do you use?

Thanks for letting us know!
MS SQL review by <span>Mayank N.</span>
Mayank N.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Excellent RDBMS

What do you like best?

Integration of other monitoring software like fog light is very easy without time consumption. Great capability to handle all complex queries requirements. Suite of advance sql functions. Provide all excellent functionalities like Reporting Services, Integration Services, Job Scheduler, Resource manager, Query analyser and Profiler etc. Each of these modules are build perfectly and handles the tasks effectively. Configurable at each level. User permission is at every objects and other higher levels. Changes can be done for specific privileges at user level. Window service based Control to the server for starting and stopping the service.

What do you dislike?

Scalability is great but not the best like other new Database there in the market. CPU memory consumption is always more than normal on production specifically by the sql server. Scope of improvement in profiler for most frequently used options.

Recommendations to others considering the product

Sql server has always fulfilled the new requirements and has great features to utilize. This will always exceed your expectation for sure.

What business problems are you solving with the product? What benefits have you realized?

We are using it as backed of application. This is perfect for all kind of client requirements and always meets the expectation.

MS SQL review by <span>Sara  A.</span>
Sara A.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

From a Beginner's Perspective: Great Software to use when Dealing with databases

What do you like best?

I am just beginning to learn, but there are so many things I like. Mainly, the ability to extract the precise data I need has been the best part so far.

What do you dislike?

For a beginner it can get confusing, it takes a while to really get a good handle on it and be able to really use it to its maximum potential.

Recommendations to others considering the product

You definitely need to have knowledge of how to use SQL in order to get the benefits of this program. The more you learn, the more effective your use of this program will be.

What business problems are you solving with the product? What benefits have you realized?

We are able to produce reports using stored procedures for our company. In the past this was only possible with extremely time consuming manual excel reports. I use it now on a daily basis to do different queries for things that come up. Now i can find that information in minutes versus, before when it would take days or weeks.

MS SQL review by <span>Prashansa K.</span>
Prashansa K.
Validated Reviewer
Verified Current User
Organic
Reviewed On

SQL Server developer

What do you like best?

Performance while retrieving the data.

Compatible with several on the shelf products.

Storing the data is easier.

Support for the Kerberos and other security products.

It is useful to manage and obtain data from the network of networks.

It allows us to forget about the files that make up the database.

Asynchronous filling of objects, with the possibility of filtering objects according to their metadata.

Access to the SQL Server Agent in the replication servers for administration.

A new interface for viewing XML results.

What do you dislike?

uses a lot of RAM memory for installations and software.

Difficult to setup permissions and roles.

Support for writing and modifying queries or scripts without the need to connect to a server.

Archieving data is not easier.

Recommendations to others considering the product

If you care about the fast retrieval of the data then MS Sql Server is best product in the market.

What business problems are you solving with the product? What benefits have you realized?

Using for the backend database support.

Archieval of the data.

MS SQL review by <span>Brandon M.</span>
Brandon M.
Validated Reviewer
Verified Current User
Organic
Reviewed On

Microsoft SQL - Excellent DB Platform

What do you like best?

I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and helpful resources that are available. Thanks to the developer network, I’ve been able to learn much more about querying and build more useful and advanced queries over time. Things such as Transact-SQL (T-SQL) come in handy a lot of the time due to the vast amount of new queries you can build after learning T-SQL.

What do you dislike?

I dislike that sometimes the developer network resources can be much more complex than I anticipated. Sometimes you just need a simple answer and not a lecture on every argument that can be used. I would also say that understanding certain failures or issues with SQL could by better documented by Microsoft instead of other community forums i.e. Stack Overflow. It would be nice if Microsoft had an error mapping for each SQL error and what the resolution for it might be. As far as I know, the easiest way to troubleshoot a query on runtime is to paste a portion of the error in to a search engine and then start going through the form pages. Usually within the first several web links, someone will have found a resolution that works.

Recommendations to others considering the product

Microsoft SQL is a great solution and the updates only continue to make it better. Be sure to stay on top of SP updates but make sure the next version (2008, 2012, 2016, etc..) will have everything that you need.

What business problems are you solving with the product? What benefits have you realized?

Financial Inaccuracies, ETL errors (SSIS), IIS Application issues.

Kate avatar
Kate from G2 Crowd

Learning about Microsoft SQL?

I can help.
* We monitor all Microsoft SQL reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.