SQL Server Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Real User
Applications Business Intelligence Analyst at a aerospace/defense firm with 10,001+ employees
Jul 16 2017

What is most valuable?

There are many, but I would have to say the two most important for me have been SQL Server Profiler -- to run traces and the ability to kill sessions in the enterprise manager tool. This command-based functionality lets you search and sort... more»

How has it helped my organization?

In an effort to forego a data warehouse purchase, one company I worked with used a second SQL Server instance loaded to separate hardware as a reporting environment avoiding the need to hire additional employees to support a data warehouse.... more»

What needs improvement?

Multiple operating systems support should improve. The ongoing and newly marketed support for Linux and Unix environments running SQL Server is a big win for Microsoft, in my opinion. Previous hold back related to open source environments... more»
Real User
Software Architect at a tech consulting company with 51-200 employees
Aug 15 2017

What is most valuable?

* SQL Server Integration Services tools * Data Quality Services tools * Master Data Services tools * SQL Server Reporting Services tools * Data Partitioning (Horizontal Partitioning) tools * ColumnStore Indices * In-Memory OLTP tables

How has it helped my organization?

We design and implement DW solutions with SS 2016 Dev Ed tools. This solution has given us high levels of productivity, which has allowed us to use an Agile approach to the design and implementation of DW solutions for our customers, and this... more»

What needs improvement?

We do not have much to complain about SS 2016 Dev Ed in itself, we do have some complaints regarding licensing for SQL Server 2016 Enterprise Ed. In an emerging market like Argentina, it is very steep for our customers to pay U$S 28,000 or... more»
Find out what your peers are saying about Microsoft, SAP, Teradata and others in Relational Databases.
278,683 professionals have used our research since 2012.
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 collation for the data warehouse, Cube-generation, and ad-hoc processes.... 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 introduction of SQL Server, we have consolidated relevant business data into one... 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 for reporting; presumably that is why they have not improved the... 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 ideas... more»
Real User
CEO/CTO at a tech services company with 51-200 employees
Jul 20 2017

What is most valuable?

Probably the most useful feature of SQL Server is the ability to write and execute SQL on the fly. Even though there are some very useful features on Oracle, MySQL, and other platforms, the SQL Server by far has the most robust capabilities... more»

How has it helped my organization?

The most recent example is a data warehouse I've created for a client that enables us to use a "no-SQL" construct. This is only possible due to the dynamic SQL capability. Our client collects data from dozens of sources with little to no... more»

What needs improvement?

The only real improvement I've been looking for is finally being addressed by Microsoft. Since SQL Server only ran on Windows, it was not competitive with other platforms which could run on Linux. This has recently been realized with the... more»
See 23 more reviews

Articles

User Assessments By Topic About SQL Server

Find out what your peers are saying about Microsoft, SAP, Teradata and others in Relational Databases.
278,683 professionals have used our research since 2012.

SQL Server Questions

SQL Server Projects By Members

SQL Server Consultants

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.

BUYER'S GUIDE
Not sure which Relational Databases solution is right for you?

Download our free Relational Databases Report and find out what your peers are saying about Microsoft, SAP, Teradata, and more!

Sign Up with Email