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 informed. Organizations can improve the data quality by using the organizational knowledge and third-party reference data providers to profile, clean, and match the data.

The IT department can manage data through a BI Semantic Model, which provides a consistent view across multiple data sources.



781 Reviews of Microsoft SQL Server - BI Edition

Overall rating

4.57 / 5 stars

Filters:

Showing 1 - 20 of 781 reviews

January 2019

Ajmal from The Barkat Foundation

Company Size: 11-50 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

4 of 5

January 2019

SQL for education and commercial use

Pros

One of the best and conveint tool for databease managment I have used ever in my degree course and then at orgnaization. The best DBMS with all features you would love. It is highly recommended both for education and commercial use, since it is easy to use with all langauges and create a switch to connect. Further it can be managed easily and it provide good support to users.

Cons

Sometimes happen problems if you forget the username and password, so be careful.

January 2019

Anonymous

Verified Reviewer

Company Size: 201-500 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Functionality

5 of 5

January 2019

SQL Server

Pros

Ease of functionality and widely used database system

Cons

Expensive upfront costs and complication

January 2019

Joshua from Roanoke Video

Company Size: 1 employee

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

5 of 5

January 2019

A Must for Databases

Pros

I use SQL server in many of the custom web applications that I design and build. The best thing I enjoy about MS SQL is that is works well with other Microsoft products. There is a large learning curve when it comes to being able to know how to create a database for example, but once you learn the basics, its pretty easy. I combine my databases with php based Laravel, a MVC model application to create wonderul front end web applicaitons.

Cons

I'm not a big fan of all the verisons and price ranges that the software has to offer. I wish Microsoft would simply have a couple of tiers of SQL rather than 15 different kinds that you can purchase. It boils down to how scalable you need and I get that, the operations from the admin side of things is pretty much the same, space and speed limits are the main thing.

January 2019

Ajit from delaPlex Software

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

4 of 5

Customer support

5 of 5

Functionality

5 of 5

January 2019

SQL Server is very reliable DB

I create number complex application using SQL Server DB and perfectly work.

Pros

SQL server support to query as well as Designer for creating tables and constraints.

Cons

SQL server auto backup option need to configure on every new server .

January 2019

Ruan from Gemalto

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

5 of 5

Functionality

5 of 5

January 2019

Best Sql Database system

I have been using Microsoft SQL Server and Transact-Sql since SQL Server 2010 and after all those years microsoft sql server is my number one choice. You can perform a clean installation within minutes and then you are ready to work. The engine is real fast and you will have a lot of documentation to implement your specific configuration or to run your custom tasks. For me what is most important in this piece of software is the community behind(with tons of tutorials and how-to) it and the microsoft support, they are doing a really great job!

Pros

it is very simple to install, configure and use

Cons

if you need to execute a more complex task on database you will need an sql script

January 2019

Vijith from Horizon BPO

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

5 of 5

Functionality

5 of 5

January 2019

One of the best software to use at work for database management

Pros

We switched over to Microsoft SQL from a third party service provider and our experience was great. Initially it took a longer time to set things up but made our work life easy. An efficient system to manage the day to day data that comes over and easy to get the result you want.

Cons

We have had a few instances of slow processing of data and responses but that is some what a rare instance. Apart from this all is good about this product.

January 2019

Anonymous

Verified Reviewer

Company Size: 2-10 employees

Review Source: Capterra


Ease-of-use

5 of 5

Functionality

5 of 5

January 2019

Fast, scalable and easy to manage

Pros

Not my first choice if it's about relational databases but i really like it's stability, scalability and gui for management. If you'r from Microsoft world it's definitively database that you should chose. Right now you can even run it od linux!

Cons

If your used to open source databases like postgresql or mysql pricing could be shocking at first.

January 2019

Anonymous

Verified Reviewer

Company Size: 2-10 employees

Review Source: Capterra


Ease-of-use

4 of 5

Functionality

4 of 5

January 2019

Just good

Pros

Microsoft did it! A Relational Database Manager that is also user-friendly. You can run it in windows, mac and linux.

Cons

I would like more hints to the first time user.

January 2019

George from AlgorX, Inc.

Company Size: 2-10 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

3 of 5

Customer support

4 of 5

Functionality

5 of 5

January 2019

One of the best relational DBMS's on the market

Pros

Performance
Capabilities
Ease of use
Toolset

Cons

SQL server can be expensive given that there are alternative solutions (MySQL, Postgres etc).

January 2019

Arpan from Allscripts

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

5 of 5

January 2019

A beast!

It is an industry standard and is a must buy for any business out there.

Pros

- One of the most powerful and complex database management system ever made.
- Keeping SQL server running smoothly at all times is the biggest challenge one can face!
- Modular based architecture.
- There will always be something new to learn and try.

Cons

- One can spend the whole career learning best practices about managing SQL server and still there would be things left to learn.
- Because the software is so complex, it could take years for one to be comfortable with various modules.
- Troubleshooting performance issues could be hard to very complex!
- The cost to implement is massive. Small businesses might not be able to afford.

January 2019

Mahendran from Lanka Financial Services Bureau (SWIFT Service Bureau of Sri Lanka)

Company Size: 11-50 employees

Review Source: Capterra


Ease-of-use

3 of 5

Value for money

5 of 5

Customer support

4 of 5

Functionality

5 of 5

January 2019

Humen life with SQL database sever.

SQL gives GUI which helps to user to work freely.

Pros

- SQL server is a database management system giving by Microsoft.
- Data transfer option is available. Therefore, if any case user can get backup and replace with another SQL server.
- SQL server contained graphic user interface. Therefore, the implementer can work independently.
- This server automatically perform the resource allocation itself.

Cons

- The server installation will be done through Internet Explorer, therefore, the installing part takes more time to complete.

January 2019

Anonymous

Verified Reviewer

Company Size: 11-50 employees

Review Source: Capterra


Ease-of-use

5 of 5

Functionality

5 of 5

January 2019

Great way to store tables and query them

Pros

The SQL on SQL Server is Transact-SQL. It's easy to write queries and execute them.
You can save the SQL queries to access later.
Easy to upload excel files to the DB and create new tables.

Cons

Don't have any cons on the software, very easy to use.

January 2019

Anonymous

Verified Reviewer

Company Size: 1,001-5,000 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

3 of 5

Functionality

5 of 5

January 2019

Using SQL Server for the past 10 years

Relational databases, my overall experience has been great,

Pros

Because it runs on Windows it´s easier to install and deploy than Oracle (wich runs better on unix like systems than in windows). high availability solutions are great, speciallly failover clusters and always on, Reporting Services is also a great tool for easily creating and automiting business reports.

Cons

The error log is a mess because the error code system does not work as well as Oracle (wich has an ORA- nomenclature).

January 2019

Justina from Intermedix

Company Size: 1,001-5,000 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

4 of 5

Functionality

4 of 5

January 2019

The optimal database storage solution

Pros

I like SQL Server for its reliability, easy navigation and easy diagnostics when problems arise. In addition, the software is stable and allows you to conveniently manage even a large amount of data.

Cons

Visually, the interface looks too outdated and needs to be updated. If failures occur, find a solution yourself, and contact the support service is problematic.

January 2019

Petar from Cleaning Floor London

Company Size: 201-500 employees

Review Source: Capterra


Ease-of-use

5 of 5

Functionality

5 of 5

January 2019

Very good product of Microsoft

I've been using it for six years since I changed my job. Now I use it every day.

Pros

It helps me a lot and there is a lot of useful information on the web

Cons

The software is great, I do not think of things I do not like.

January 2019

Sean from Awmous

Company Size: 11-50 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

5 of 5

January 2019

Price and security for the win

Overall it has been a great experience and we feel confident in our choice. Backed by a big name like Microsoft has been comforting.

Pros

The security features of SQL Server are the best. This was of most important of features when we looked for a product to use. The features are amazing but without proper security, the features wouldn't much matter.

Cons

With all the offered features offered, sometimes it can seem a bit daunting especially if you aren't fully aware of what they all mean. It was a bit of a learning process at first.

January 2019

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

4 of 5

Customer support

3 of 5

Functionality

4 of 5

January 2019

SQL Server Review

All in all, I still enjoy using SQL Server on a daily basis and would recommend it as a high quality DBMS.

Pros

I have used other database management systems such as PostgreSQL but I really like the user interface of SQL Server. It is very intuitive and easy to use. The "intellisense" is also really quick and helpful.

Cons

The search function of SQL Server is almost nonexistent. Once your database gets really big, it's hard to navigate to the table that you want to check its schema, etc, or trying to find a keyword in a stored procedure.

January 2019

Anonymous

Verified Reviewer

Company Size: 501-1,000 employees

Review Source: Capterra


Ease-of-use

2 of 5

Functionality

4 of 5

January 2019

A useful advanced software

Pros

Many features, large capacity, having free versions

Cons

The excessive complexity that makes it hard for amateurs

January 2019

Michael from MRC Computing

Company Size: 1 employee

Review Source: Capterra


Ease-of-use

5 of 5

Functionality

5 of 5

January 2019

The new standard for the future

I have been using it for years, keeps getting better, faster, more secure with every release. It is easy enough to use as a developer, but still has all the bells and whistles that you would need for almost every use case.

Pros

Easy to setup, configure and maintain for someone with limited knowledge of database systems. Powerful enough to run corporations.

Cons

Initially the pricing that they had. I realize that Microsoft has to make money, but sometimes these prices for a small business are a little to much.

January 2019

Brandon from LPi

Company Size: 201-500 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

3 of 5

Customer support

4 of 5

Functionality

4 of 5

January 2019

Industry Standard

MSSQL Server is an industry standard (obviously). I've worked with it for quite a few years. It's relatively easy to pick up and learn the ins and outs of it. There is a lot of potential with it.

Pros

For IT shops that are on the MS stack, MSSQL Server is the obvious choice. Ties in perfectly. Easy to use.

Cons

As a consultant, I think my biggest issues were dealing with version differences.