SQL Server Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
Real User
Senior Developer at a tech vendor with 201-500 employees
Mar 04 2018

What is most valuable?

Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as… more»

How has it helped my organization?

In the current organisation there was no centralised data repository. Thus, statistics, reporting, and generic management information were not existent. With the… more»

What needs improvement?

An area that definitely needs improvement is the Reporting Service side with the actual report server. Although to be fair, Microsoft has developed a new branch of tools… more»

What's my experience with pricing, setup cost, and licensing?

My advice is quite straightforward. If you know the number of users who really and truly need access to the Server then it is a no-brainer. If you do not know, then get… more»

If you previously used a different solution, which one did you use and why did you switch?

Yes, in the past I have worked with different versions of SQL server and have switched due to upgrades to utilise the latest version. I have also used Oracle, Tableau… more»

What other advice do I have?

I rate it eight out of 10. It is quite a good product and has improved dramatically. Like all products, it has bugs here and there and some areas still need improvement. I… more»

Which other solutions did I evaluate?

Within the current organisation, we did not look at other options. I was pretty confident that the product would do the job, based on my previous experience with similar… more»
Недашковский Евгений
Real User
Senior SQL DBA at a financial services firm with 51-200 employees
Feb 25 2018

What is most valuable?

Always On is my favorite feature. I do like availability groups and cannot imagine how I lived with them before. Microsoft tries to release new features with every version, but I cannot say that they are killer features. Usually these are… more»

How has it helped my organization?

I am not sure, as we have been working with it from the start. Comparing with other database management systems that I tried in other companies, SQL Server is quite easy to install, configure, and maintain. It is also quite reliable in… more»

What needs improvement?

I like it the way it is, though I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups. I am aware of Connect and Trello pages, and there are a lot of good… more»

What's my experience with pricing, setup cost, and licensing?

This is a downside of enterprise Microsoft products. Currently, almost all of my machines are in Azure and I think it is the best way of licensing now (VM+software).

What other advice do I have?

Though I do like the SQL Server, I must say it is very hard to find a good DBA nowadays and having a DBMS without a DBA is like having a car without a driver and skills to drive it yourself. Before choosing or switching to this DMBS, check… more»
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: October 2019.
372,374 professionals have used our research since 2012.
Aju Mathai
Real User
Database Architect at Huron Consulting
Apr 04 2019

What is most valuable?

* Performance-wise, it is an excellent tool. * It is a Microsoft product, so there's a lot of support. * It's not a new tool; it has been around for a while. * It is one… more»

How has it helped my organization?

I am in the process of creating a data strategy to consolidate multiple siloed data centers. Once my plan is finalized and approved, then we are going to execute it on the… more»

What needs improvement?

I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have… more»

What's my experience with pricing, setup cost, and licensing?

It is expensive, but you get what you pay for. Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can… more»

If you previously used a different solution, which one did you use and why did you switch?

Our company has probably been using this solution since it was released.

What other advice do I have?

I would definitely recommend SQL Server. It's not cheaper any more, like it used to be, but if you can afford it, then it's the best. When I select a vendor, from a tool… more»

Which other solutions did I evaluate?

From my perspective, the two vendors for this are Microsoft and Amazon (AWS). They are working on making it better with every release, compared to Oracle Db2 and IBM.
BethWiebusch
Real User
Sr. Database and Application Administrator with 10,001+ employees
Feb 05 2018

What is most valuable?

* Ease of installation. * Ease of creating your databases. * Ease of changing what your databases look like when you need to. * Creating tables is simple. * They have lots of different options that… more»

How has it helped my organization?

It allows me to obtain access to data that I would not otherwise obtain access to from different programs. It has helped pull statistics and data, then put it into a report form to do some Power BI on… more»

What needs improvement?

Right now, the tool you use to query the system updates every month. It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly… more»

What's my experience with pricing, setup cost, and licensing?

It has the easiest licensing.

If you previously used a different solution, which one did you use and why did you switch?

We previously used MySQL, because it is a free product. It was just hard to operate, do backups, and make automated. Also, it was not scalable.

Which other solutions did I evaluate?

We are a Microsoft shop, so we use Active Directory. That integrates well with this product, but we did look at Oracle. We also looked at IBM. This was the best price point for us for what we were… more»
Gh0ce
Real User
Systems Analyst/DBA at a comms service provider with 501-1,000 employees
Dec 05 2017

What is most valuable?

Everything is valuable. It is a relational database system which is critical for storing reporting data or any data that is highly relate-able. Plus your data is one of… more»

How has it helped my organization?

In a manufacturing system, storing test data in an Excel file has limitations in how much data can be stored at one time and how many people can manipulate the data at one… more»

What needs improvement?

Setting up some of the more complex systems could be simpler. Things like service broker can be tricky to set up for the inexperienced.

What's my experience with pricing, setup cost, and licensing?

Pricing and licensing is based on a per core and/or per-processor license. Try to keep these low, but keep it above four. (Four is the minimum number of cores.) If you are… more»

If you previously used a different solution, which one did you use and why did you switch?

I did not use a previous solution. I have heard of other companies using Microsoft Access or Excel for similar problems. However, after hearing the headaches they have, I… more»

What other advice do I have?

If you don't have a DBA on site, hiring a consultant is recommended to help get things setup and configured. This will reduce headaches down the line.

Which other solutions did I evaluate?

We did not evaluate other options. The other options lacked support, lacked performance, or were too expensive.
Real User
Managing Director at a tech services company with 11-50 employees
Feb 28 2018

What is most valuable?

Analysis Services, because we are an independent software vendor in the business-intelligence area.

How has it helped my organization?

It's a very capable, efficient, price-performant OLAP server on which we can build our solutions.

What needs improvement?

The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own… more»

What's my experience with pricing, setup cost, and licensing?

The price has been going higher and higher. The market is quite price sensitive.

If you previously used a different solution, which one did you use and why did you switch?

We used PostgreSQL, and we also used some other OLAP servers.

What other advice do I have?

It's good if you need OLAP services. I give it a seven out of 10 overall, because of the things mentioned: First is that during the version upgrades, sometimes things are… more»

Which other solutions did I evaluate?

At that time there was also Sybase, Oracle, MySQL. That's at the time those databases were up.
Consultant
Lead Software Engineer at a tech services company with 11-50 employees
Jan 28 2018

What is most valuable?

The AlwaysOn high-availability feature is the most valuable feature of SQL Server to us. This is because of the relative ease of the configuration, rather than configuring for OLTP-OLAP distinction.

How has it helped my organization?

There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. Before my arrival, the numbers… more»

What needs improvement?

As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes. Improvements must not be stopped and must not end. When business needs arrive… more»

If you previously used a different solution, which one did you use and why did you switch?

Yes I did use another solution previously. The switch was mainly for the performance. Secondly, it was for the technology compatibility.

What other advice do I have?

I’ve been working on Microsoft SQL Server since 2005, and currently I’m using SQL Server 2014 in my development environment and SQL Server 2012 in the production environment.

Which other solutions did I evaluate?

I’m not a "product" fan. I try to use "the" product which will comply smoothly with the software I’m working on.
Lei Liu
Real User
DBA,data architectuire at a tech services company
Feb 21 2019

What is most valuable?

table partition options, that is very useful to separate unnecessary cost. For legacy data, we can do partition swith out and store into flat files or old tables. When it… more»

How has it helped my organization?

It is easy to establish, and the license price is lower than that of Oracle. Otherwise, our customer could can replace primary databases from Oracle into MSSQL AG Base on… more»

What needs improvement?

Horizontal partitioning. In that case, cold , warm and hot data can be distributed into different database not only table partition located on different FGs .

What's my experience with pricing, setup cost, and licensing?

Migration local database into cloud

If you previously used a different solution, which one did you use and why did you switch?

I have no choice. our customer choose MS SQL

What other advice do I have?

subpartition is necessary

Which other solutions did I evaluate?

No, I have to accepted it
See 10 More SQL Server Reviews

Articles

User Assessments By Topic About SQL Server

Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: October 2019.
372,374 professionals have used our research since 2012.

SQL Server Questions

What is SQL Server?

SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

Also known as
Microsoft SQL Server, MSSQL, MS SQL
SQL Server customers

Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.

Read Archived Reviews
BUYER'S GUIDE
Download our free Relational Databases Report and find out what your peers are saying about Microsoft, Teradata, Oracle, and more!
Sign Up with Email