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.

Sales summary
Sales summary

Sales summary

Buffer pool extensions

Buffer pool extensions

Query

Query

OLTP

OLTP

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



625 Reviews of Microsoft SQL Server - BI Edition

Overall rating

4.5 / 5 stars

Write a review

Showing 1 - 20 of 625 reviews

Start your review of Microsoft SQL Server - BI Edition

Write a review
LinkedIn icon
Verified Reviewer

Number of employees:  10,000+ employees

Ease-of-use

Value for money

Functionality

November 2018

Try running a business without SQL

Pros

There are spreadsheets and then there are databases. SQL is king when it comes to creating a useful database. One can store millions and millions of rows of data and call them back with complex views and queries

Cons

There is a steep learning curve when trying to get a grasp of sql statements, but it's worth it. Do yourself a favor and learn how to code in SQL and watch your back for that next promotion.

Review Source: Capterra
LinkedIn icon
Verified Reviewer

Number of employees:  51-200 employees

Ease-of-use

Functionality

November 2018

Another solid Microsoft product

Great database application with worldwide use and support. You will be hard pressed to find a more reliable and trustworthy software provider than Microsoft.

Pros

SQL server is an industry-leading database application. The fact that it is a Microsoft product means that there are millions of people who know how to use it and plenty of online help available.

I am a fairly basic user of SQL server, so I don't know all the tips and tricks. However, I do find the feature of being able to query the database useful. Also, being able to do mass changes to selected records in the database is powerful, as well as being able to test your code using rollback first.

Cons

It requires a lot of training to really master SQL server. However, for a basic user, it is easy enough to navigate around and complete basic tasks.

Review Source: Capterra

Gayani from Sri Lanka Institute of Information Technology

Number of employees:  1 employee

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Software developer's best software

Used for projects in university.

Pros

It has high performance. It has great data base.

Cons

Take lot of space. It is very expensive for some countries .

Review Source: Capterra

Winston from Castle Biosciences, Inc.

Number of employees:  51-200 employees

Ease-of-use

Functionality

November 2018

No Frills SQL Server for any Database

We started out as a small business and did not even have an IT department. Most our users are storing and sharing data via spreadsheets. Once we exceeded 25-30 employees, we knew that we had to implement a more permanent solution as our company grew. Microsoft SQL Server was the solution and it has been doing its job for the last few years.

Pros

There are lots of examples available online when I get stuck or require additional assistance. It seems like the majority of companies use Microsoft SQL Server so it is very easy to integrate with other platforms as needed.

Cons

The learning curve was a bit steep for me. I never had a formal education in IT but all the samples and resources on the internet was enough for me to provide the business with everything they need.

Review Source: Capterra

Chirag from CitiusTech

Number of employees:  1,001-5,000 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

SQL - World biggest and Most powerful RDBMS database

All business needs are satisfy with this Product. One of the most powerful feature we are using is SQL JOBS.

Pros

SQL is the only one database which is used by almost every organization on earth. Its have hugh and rich variety of feature. One my personal favorite its schema and SQL Jobs. We are using almost 10% of its capabilities and still serving all the business needs for the entire organization.

Cons

SQL is RDBMS database. That means its having Schema. Every time if new objects are added, its require deployment for all environment. That makes sometime really challenging.

Review Source: Capterra

Michael from Opus

Number of employees:  51-200 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

SQL Server - Keeps Getting Better

I have spent more than a decade working with SQL Server and various technologies from a Sys-Admin/Sys-Analyst role in modern day IT organizations. I've had the opportunities to install, maintain, worked on and within, and develop throughout several versions of SQL Server. I've worked in SaaS and Web App for providers that combined have covered the entire Fortune 50 and more than half of the Fortune 500. I've worked in JavaScript prior to and throughout it's massive growth creating projects in NodeJS using mssql and node-mssql to transform SQL data into useful JSON object sets on the fly since before SQL could even output JSON. I've authored several helpful tools over the years combining SQL Server with bleeding edge platforms to provide tools to previous organizations that were better at the time than even some leading tools performing those functionalities today.

Pros

SQL Server is an industry standard software. It is highly configurable, capable of multiple setups, and deeply ingrained with the Microsoft Windows platform. Administration is quick, effective, and easier than ever.

Cons

SQL Server 2017 has a weak implementation of Graph databases which will be a much more prevalent database type once big data and IoT really kicks in. In my opinion, Microsoft should be forcing the graph database capabilities forward and trying to match products like NEO4j in performance.

Review Source: Capterra

Anas from Omnitracs

Number of employees:  501-1,000 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Good and easy to use

Pros

Microsoft SQL Server is a good, user-friendly database management tool.

Cons

The only issue is that they dont have the program available on Mac OS. You have to download 3rd party ones to connect to it and it's a pain.

Review Source: Capterra

Sunita from Infosys

Number of employees:  10,000+ employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

My views on Microsoft Sql server

In our organization,, we are using widely this tool to create new database objects like table, stored procedure, function in our existing application. SQL server's profiler, database tuning functionality a reporting services etc. helped a lot in daily development work. By creating master key in database used decrypt and encrypt feature on required tables and maintained confidentiality. Greatly helped in performance monitoring. I'll say its a great database storage engine.

Pros

SQL server support numerous data type on a database table column name.
SQL Sever's profiler is a great tool to find out running query on sql instance.
SSMS and SSIS reporting services functionality are easy to generate the data report.
Database tuning is great feature to improve the performance of db as this provides good suggestion during this activity.
Its linked server functionality is great to retrieve data from remote server.

Cons

Sql server constrained to a single cpu. There is a limit on stored procedure's parameter but this is still sufficient number 2100.

Review Source: Capterra
LinkedIn icon
Verified Reviewer

Number of employees:  51-200 employees

Ease-of-use

Functionality

November 2018

Enterprise software, probably the go to if the company commits to it

Like many who use SQL Server, it's because it's 'what the company uses', and I don't have a lot of experience with other enterprise level databases, but with the support and attention it gets, it's stable and don't have to worry about it not being able to handle anything we throw at it. With that said, it does take attention to make sure things are written so it's parsers can interpret things correctly. Very small differences in filters and joins mean the difference between using an index and ignoring it, which can be the difference in milliseconds and minutes for some queries. Have used MySQL at similar levels of use and that was capable too, but was seen as less 'enterprise' worthy, and maybe missing some features of MSSQL which must have been worth the additional investment from higher up. I would say the toolsets are significantly better, as well as demanding more support, so I've basically benefitted from the upgrade.

Pros

Widely used, google search will almost always come up with high quality results
Stable, trusted

Cons

Infrastructure required, installing tools is a little clunky at times
lots of overhead

Review Source: Capterra
LinkedIn icon
Verified Reviewer

Number of employees:  11-50 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Great RDMS tool

I have been a user for more than 7 years and MS SQL SERVER is the Management tool which I will stick into as it gives everything for my development needs

Pros

This is a software which will be used by most developers daily for business and for their personal use. Features are not limited to running scripts as it also provides monitoring, scheduling and even debugging your scripts.

Cons

SQL services likely to use more memory than others and hard disk space is getting filled up with logs if it has not been configured properly.

Review Source: Capterra

Brian from Koku

Number of employees:  11-50 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Been using SQL server for 5+ year and I'm a happy customer

We can seamlessly upgrade SQL server as our companies needs grows. We will be using SQL server for many more years to come. Its a great piece of software.

Pros

The fact anyone can start using it from free to enterprise and seamlessly upgrade as your startup grows is impressive.

Cons

Running the SQL server locally sometimes becomes a issue. And for people who is experimenting and learning, SQL server has locked some features from the free edition. If we had things like the SQL profiler free, we can learn how to use them and improve our skills.

Review Source: Capterra

Chathuranga from KPMG Sri Lanka

Number of employees:  1,001-5,000 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Patch Managemnt

I was a system administrator and i was used the SQL Server 2014. The Microsoft are give critical updates daily basic and they help to administrators protect their data.

Pros

Database is very critical because of the organization data will stored in the Database Server. Windows Sql server will provides the lot of critical patches daily basics. If do not patch the server attackers can be attacked to the DB and get all information within the organization. So SQL Server vendors are maintain the patches for zero day exploits.

Cons

If we patch the DB some of functionality will be not working properly. Therefore we have to use the UAT system to check the accuracy of the functions.

Review Source: Capterra
LinkedIn icon
Verified Reviewer

Number of employees:  5,001-10,000 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

SQL Sever Review

Overall, a good database management system and has a lot of career scope.

Pros

SQL server was developed by Microsoft and is a relational database management system. It includes of a lot of queries in which tables can be created, deleted or truncated. Also, this is used in many IT industries and many people have built there careers successfully by just playing around with the queries.

Cons

It takes a lot of memory on computer to install SQL server which will definitely slow down it. In addition, it also requires a lot of experience to master it as a little mistake can interrupt the entire functioning of product.

Review Source: Capterra
LinkedIn icon
Verified Reviewer

Number of employees:  2-10 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Awesome

Pros

Super trusty
fun to work with
very secure

Cons

this is the best database ever, thanks SQL

Review Source: Capterra

Martin from Sonata Services

Number of employees:  51-200 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

DataBase System

I use the tool in some of my projects and it was fun to learn how to use it and how to install and configure

Pros

Great database manager you can use for your proyects you can do your relations in your database system with primary keys and much more

Cons

its dificult to install if you dont know the basics of the instalation the integration wirh other systems takes a lot of steps to do and to work

Review Source: Capterra
LinkedIn icon
Verified Reviewer

Number of employees:  51-200 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Great Data Maintenance Tool

One stop solution for all database related need

Pros

Great Tool for maintenance of Data. Specially great performance if the data is huge.
As it is being used by large community of engineers so that help is easily available

Cons

This tools requires lot of RAM while installations and running queries

Review Source: Capterra

Brian from Mercy Health

Industry:  Healthcare / Social Services

Number of employees:  10,000+ employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

Includes a much more powerful and user freindly analytics capabilities than other sql products, but still has the integration superiority of sql server

Pros

The analytics and modeling tools have a very user friendly user interface that allows much less advanced users to create useful reports in an SQL product. SQL BI also includes the powerful query and transformation capabilities common in all sql server editions and necessary for robust BI and analytics including Integration Service for ETL and Report Service for querying and sharing models. These user friendly analytics tools and powerful data prep and data expression tools are integrated relatively seamlessly, and combine to from a product that combines SQLs DB/Query power and systematic product integration with user friendly (but still powerful) data and analytics tools.

Cons

Even this version of sql with some relatively user friendly tools has a pretty steep learning curve and intense resource requirements. In fact, in some ways the nice GUI for tabular modeling is misleading because it seems similar to Excel at first look, but can be deeply discouraging to users when they find out they are nothing alike. Also, no matter how user friendly and integrated the analysis service tools are, you can't avoid writing sql and searching for obscure table names as always.

Review Source
LinkedIn icon
Verified Reviewer

Number of employees:  201-500 employees

Ease-of-use

Value for money

Customer support

Functionality

November 2018

SQL Server is one the best there is!

I solve business needs with SQL Server by running sql codes easily and efficiently all the time. It executes commands very quickly with no errors. I just love SQL Server.

Pros

Running query commands easy and simple every time.

Cons

I do not really dislike anything but customization maybe time consuming.

Review Source: Capterra

Jaysser from Yondu Inc.

Industry:  Software / Technology

Number of employees:  501-1,000 employees

Ease-of-use

Functionality

November 2018

Great DBM tool!

Pros

This tool provides a secured database connections and it can also handle multiple connections for your database. You can easily manage your data's and dabatase structures.

Cons

If you are first time to use this tool, you really need to explore this and this is actually become useful for your database.

Review Source

Monique from Blue Link Associates

Number of employees:  11-50 employees

Ease-of-use

Functionality

November 2018

Manage your data easily

Overall, it is easy to switch from other databases to SQL. Provided flexibility and ease of use. Integrates very well with all kind of software.

Pros

Very well integrated with other apps and software, not only Microsoft apps but other software too. I love the activity monitor, shows you what is locking each database. Gives you ability to add triggers, indexes, create views for reports and stored procedures. Great autofill options and great colouring of key words in queries.

Cons

There are a few bugs like when restoring a database and user wants to change the path of the mdf and ldf file, you need to browse to the folder, as copying and pasting a path does not work. Also, killing a task or renaming a database that is being used, takes forever before an error pops up.

Review Source: Capterra

Displaying 1 - 20 of 625 reviews