About Microsoft SQL Server

Microsoft SQL Server Business Intelligence (BI) Edition is a database management and BI software solution designed for companies of all sizes. The system offers relational database management, which allows users to access enterprise data using structured query language. The solution allows users to perform complex analysis on the database. The product also features a BI Semantic model that allows users to extract and analyze data from heterogeneous sources.

Microsoft SQL Server features "in-memory analytics," which allows users to perform queries and analytics while the data is in the RAM, thereby improving the speed of access. The software has scalable and corporate reporting features that help management to make decisions that are more inform...


Read More

Supported Operating System(s):

Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

1,507 Reviews of Microsoft SQL Server

Average User Ratings

Overall

4.59 / 5 stars

Ease-of-use

4.5

Value for money

4.0

Customer support

4.5

Functionality

4.5

Ratings Snapshot

5 stars

(907)

907

4 stars

(504)

504

3 stars

(37)

37

2 stars

(3)

3

1 stars

(1)

1

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 1507 results

March 2020

User Profile Picture

Kudakwashe from Madrush Technologies

Verified Reviewer

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

March 2020

Data Management made so easy with MS SQL Server

Pros

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

Cons

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

Reasons for Choosing Microsoft SQL Server

In the case of Oracle DB vs MS SQL Server, MS SQL Server is easy to manage, easy to configure and has a huge community in case when you are stuck with any problem you are guaranteed to get a solution online.

November 2019

User Profile Picture

Imi from IT

Verified Reviewer

Company Size: 201-500 employees

Industry: Political Organization

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Customer support

1.0

Functionality

5.0

November 2019

SQL is getting better as it grows older

SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It is super fast for loading data from the server, and allow large data set that will normally take hours, or even crash the Excel spreadsheet to load without any issue. When I am ready for a web app.. SQL server is easy as piece to develop a simple CRUD application and push live. It seem to connect to every thing - from MS Word Mail merge, MS Excel, MS Access and of course for development environment such as Visual Studios. One Database ( Centralized) and many presentation modes for the end users. I love it!

Pros

MS SQL Server is certainly a competently relational database engine, with reporting service and now R. Easy to install for small onpremise application. Easy to administer, easy to backup, easy because it is a Microsoft application. It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI. You can start from free version and expand as time goes by. The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting. If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.

Cons

The new the version, the more memory intensive this management studio will become. Microsoft need to create some more easy to use tool for change control and change tracking. Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.

Reasons for Choosing Microsoft SQL Server

Cost and community of supporters, access to information on the open internet . Available of training.

Reasons for Switching to Microsoft SQL Server

Ease of use, Easy to learn, easy to teach easy to integrate with well know tools.

May 2021

User Profile Picture

Eric from A&B Courier Service Ltd

Verified Reviewer

Company Size: 51-200 employees

Industry: Transportation/Trucking/Railroad

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

5.0

Functionality

5.0

May 2021

MS SQL Server for location based tracking

The overall experience with MS SQL From version 2006 thru to 2016 has been a very good one. We've utilized new features when presented in version upgrades. The DB reliability is excellent, the licensing cost is well within the range of "norm" for a comparable product. Would highly recommend MS SQL when considering other database servers.

Pros

We utilize MS SQL for its ease of installation, ease of migration between versions, and the access to developers familiar with the product within our price range. Its widely adopted, and readily supported by a large number of companies.

Cons

The cost and the fact that its purely windows based. Also kinda a memory hog if not setup properly.

Reasons for Choosing Microsoft SQL Server

We wanted a product that was easy to find developers within our price range.

March 2021

User Profile Picture

Muhammad Yousuf from NCR Corporation

Verified Reviewer

Company Size: 5,001-10,000 employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

3.0

Customer support

3.0

Functionality

4.0

March 2021

Easy solution for data management

I have been using sql server for almost 10 years. It has become indispensable tool in my software development career.

Pros

I found SQL server user interface undoubtedly most easy and functionality wise very rich. From database creation to analysis it provides one click operations that has made my life easy. Although, I am web developer but thanks to sql server I can easily handle and work on databases.

Cons

I have trust issues with Data restore functionality. Most of sql server backup fails most of time because of multiple issues.

Reasons for Switching to Microsoft SQL Server

User interface not rich.

April 2021

Chirag from Risk Administration Services, Inc.

Company Size: 51-200 employees

Industry: Insurance

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

3.0

Functionality

5.0

April 2021

Rock solid, reliable and efficient database

We have enjoyed using SQL Server for various OLTP and data warehousing workloads. It is a workhorse. Its performance is fantastic. Tooling surrounding it is great. We have not encountered a single issue with it. We also have a great local meetup where we discuss the constant improvements SQL Server brings each year.

Pros

We love SQL Server's versatility. Every single application we purchase for insurance has support for SQL Server. We have not come across any situation where SQL Server didn't meet our needs.

Cons

License models are a bit confusing. Some years Microsoft make it easy to understand. Other years Microsoft makes it even more confusing. Can we run SQL Server in our data centers? Can we run it on the cloud? Do we need to change licensing to run in the cloud? Those questions sound easy to answer but the answers we get from Microsoft or resellers confuse us more. It just seems like the confusion is intentional.

Reasons for Choosing Microsoft SQL Server

The cost and feature/functionality of SQL Server was a great fit for company our size compared to Oracle. We also use MySQL and PostgreSQL for various workloads, SQL Server being the workhorse for majority of OLTP workload.