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
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Vendor
Senior Analyst Programmer at Crimsonwing
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»

Which solution did I use previously and why did I 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»
Aju Mathai
Real User
User 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»

Which solution did I use previously and why did I 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.
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: February 2020.
398,567 professionals have used our research since 2012.
Consultant
User at ResEvo d.o.o.
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.

Which solution did I use previously and why did I 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.
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

Which solution did I use previously and why did I 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
Royden Akerley
Real User
User at a logistics company with 10,001+ employees
Nov 25 2018

What is most valuable?

Traditional DB toolkit closely integrated into Microsoft Office. This makes it truly easy to deploy in a light non-business critical environment.

How has it helped my organization?

It is cost effective with easy integration into the core MS Office tools. Hence user adoption is easy. Also, being a commodity product there is an abundance of cheap resources having experience with the toolkit, but very few senior or truly expert support personnel are available. Again because it is viewed as a commodity product even by developers, no serious time is spent on skills development… more»

What needs improvement?

* It does not scale up to a truly global environment. We operate in 220+ countries and territories with data services centralized in three data centers. The ability for MS SQL to operate in this environment is a challenge for anything spanning regions or having a global footprint. * It is best suited to supporting a single functional instance by business domain or a single country. * MS needs to… more»
Rahul Kumar Singh
Real User
Software Developer at a tech vendor with 501-1,000 employees
Aug 12 2018

What is most valuable?

* SQL Server Profiler: Know exactly which procedures and functions are being called and how much read and write they are taking. * Tuning Advisor: It suggests where to add indexes and from where to remove them. It works like an adviser. *… more»

How has it helped my organization?

* SQL Server has maintained my database problem in an arranged manner. * SQL Server Profiler makes finding and debugging easy. * Support for third-party tools, like SQL Search.

What needs improvement?

* Third-party services from Redgate should be built-in to it, like SQL Search. * Debugging from the debugger tool functionality should be enhanced.

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

The setup cost is high, but it will return every penny.

Which solution did I use previously and why did I switch?

I have been using SQL Server from the start.
Daniel Du Toit
Real User
User with 1-10 employees
Jan 20 2019

What is most valuable?

It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools.

What needs improvement?

It would be nice to search for specific value across multiple tables. This would save a lot of time.

What other advice do I have?

It is definitely important for someone looking at a new vendor to consider the support of the solution. In addition, the customer should really do their research and understand what their needs are, and make sure the new solution will solve those needs.
Vendor
IT Technician / Support Supervisor at GHASSAN ABOUD GROUP
Mar 13 2018

What is most valuable?

Ability to convert to bigger DBs. It makes it easier to move or upgrade between branches.

How has it helped my organization?

All our main DBs run on SQL.

What needs improvement?

From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week.

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

Plan ahead, and make sure do not pay for something you are not going to fully use.

What other advice do I have?

Naming conventions are very very important. Make sure that your principle and mirror servers have the same disk space from the outset.
See 5 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: February 2020.
398,567 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!