Microsoft SQL Server BI Software


 

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.

 

Microsoft SQL Server - BI Edition - Sales summary
 
  • Microsoft SQL Server - BI Edition - Sales summary
    Sales summary
  • Microsoft SQL Server - BI Edition - Buffer pool extensions
    Buffer pool extensions
  • Microsoft SQL Server - BI Edition - Query
    Query
  • Microsoft SQL Server - BI Edition - 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

60 Reviews of Microsoft SQL Server - BI Edition

 

Start your review of Microsoft SQL Server - BI Edition

Click to start
http://www.softwareadvice.com/bi/microsoft-sql-review/
Software Advice Reviews (2)
More Reviews (58)

Showing 1-2 of 2

Chris from Edfinancial Services
Specialty: Banking & Financial Services
Number of employees: 201-500 employees Employees number: 201-500 employees

April 2017

April 2017

Senior BI Developer

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

I use Microsoft SQL Server daily and generally enjoy the product.

Pros

Microsoft's SQL server is extremely affordable and is relatively easy to use. You can quickly manage data, permissions as well as provide consumers access to the data through SSAS and SSRS.

Cons

Other BI solutions provide more intuitive features and better ETL/ELT solutions. SSIS & SSRS can be clunky, but they get the job done with extremely low overhead relative to Microsoft's competitors. If permissions are mismanaged, they can get messy very quickly.

 
 

Carl from Day & Zimmermann
Specialty: Construction / Contracting

September 2016

September 2016

Comfortable and still kicking

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Likes Best

Microsoft SQL Server has served me well, handling all kinds of tasks from Data warehousing, automated data pushes, reporting, notifications and ad-hoc analysis. Since we started using SQL Server several years ago, it has allowed us to better serve our customers with consistent data analysis and file pushes. There are also plenty of third party add ins which add immense value to the program.

Likes Least

This program has been around for a long time and most of the complaints I have ever had have been ironed out in recent versions. There is not much to dislike about the program. I will say that there are other vendors with better support than Microsoft but it is not lacking in any way, just not quite the personal touch you get from other vendors. Lastly, it would be nice if Microsoft would incorporate some of the extra features that third party vendors have created. They have slowly incorporated some of them in the past and I am sure it will continue though.

Recommendations

Just make sure you have the proper hardware for your instance and you are good to go. There is not a lot of complication surrounding this install and evaluation is a cinch.

 
 
 
Showing 1-20 of 58

Joihn from Cito

May 2017

May 2017

Good

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Userfriendly administrators use it efficiently as it is easy to manipulate. The issues are very much included in the software and more easily used.

Cons

License is costly if the organization doesn't have an enterprise agreement. Sometimes the support is difficult to understand as a language barrier

Source: Capterra
 

Bill from Trinidad Rancheria

May 2017

May 2017

While difficult to set up for the novice, once done, it is almost bulletproof.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Fast, simple to manage with third party tools.

Cons

Not the easiest to set up and use. Prepare to spend time on Google to figure out setup. They need better management and status tools,

Source: Capterra
 

Ted from Nevada Supreme Court

May 2017

May 2017

Very good product

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

The software is very easy to use and simple to navigate through. I enjoy the interface and the functionality.

Cons

I tend to experience patches in the system. This can be quite discouraging. Repairing these patches would be such a help/

Source: Capterra
 

Jeffrey from Admerex Solutions Inc.

April 2017

April 2017

MS SQL Server a reliable database system.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We are processing and storing large volume of data, we find MS SQL Server an ideal DB system in terms of capacity and efficiency. There are also several features that we can use to do regular DB maintenance like purging, shrinking and re-indexing.

Source: Capterra
 

Johnson from JJTech

April 2017

April 2017

My database is sql

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

As a web developer sometimes i write desktop program and that time i use sql. It is the fast db for windows programs.

Source: Capterra
 

Rufat from LighTech

April 2017

April 2017

Best DB ever

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

5 years ago I started to use SQL Server. From that time I am very happy with this server. Because I can store my data in db very easily

Source: Capterra
 

Elisa from Lozier

April 2017

April 2017

SQL gives us Independence

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Using SQL has allowed us to continue using our Access based programs. We have not lost any time due to learning a new software, but the programs runs better.

Source: Capterra
 

Eric from First Quality

April 2017

April 2017

Microsoft SQLserver Review

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Loaded with functionality, easy to use. Provides the backbone for our company. Recommended to any size company.

Source: Capterra
 

Barry from Mineown

March 2017

March 2017

Not to bad

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Was a little hard at times but over all I say pretty good experience in the short time I had with it would recommend to other sites

Source: Capterra
 

Brandon from Chester Eye Center

February 2017

February 2017

EHR uses this database

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We use maxSQL for our eye care EHR and this is a good database. We have run in to speed issues but we have been pleased with its performance.

Source: Capterra
 

Madhavi from Infosys

February 2017

February 2017

SQL Server for small application development

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We use SQL Server for developing small application at our organization and we are really happy with the application. It is very cost effective to build small user application for specific tasks

Source: Capterra
 

VIJAY from Deloitte

February 2017

February 2017

SQL Server for small application development

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We use SQL Server for developing small application at our organization and we are really happy with the application. It is very cost effective to build small user application for specific tasks

Source: Capterra
 

VIJAY SAI from Scoular

February 2017

February 2017

SQL Server for small application development

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We use SQL Server for developing small application at our organization and we are really happy with the application. It is very cost effective to build small user application for specific tasks

Source: Capterra
 

Rose from -

February 2017

February 2017

Expensive but functional

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

I am glad the ability to automatically load balancing, increased fault tolerance. Thanks to the creators for a good tool!

Source: Capterra
 

Sumit from Wipro
Number of employees: 10,000+ employees Employees number: 10,000+ employees

February 2017

February 2017

Good Relational database

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We use it to manage part of our enterprise ETL process. Microsoft SQL Server is
being used extensively in my organization. It is the default database for SharePoint sites and
also the default choice for custom database applications. SQL Server Database is very
commonly used in the IT department since it is well suited with the Microsoft products.

Pros

MSSQL Server Express is free, but has all the features of the full MSSQL Server. SQL
query syntax is very similar to MySQL and other SQL databases. you can create your
reports with MS Reporting Services and your DWH/datamart structures with MSSQL
Integration Services. Fantastic product for your business, excellent the AlwaysOn
functionality and in-memory tables.

Cons

Too much slow with xml data type, It's also a little bit "huge" in installation, and
requires really a lot of hardware resources, and so the cost is high for the licenses.

Source: Capterra
 

Vijay from Enterprise
Number of employees: 201-500 employees Employees number: 201-500 employees

February 2017

February 2017

SQL Server for backend development

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We use SQL Server for small applications development many times at our organization, though it is not fancy as high profile ERPs, SQL Server is good at what it can do, for the money we spent, we recommend SQL Server for other organizations also

Pros

Easy to Operate, Low Cost

Cons

Not very great UI for operational use

Advice to Others

SQL Server is more technical user oriented, not really a user facing application, but IT user can easily work with it

Source: Capterra
 

Renu from Xerox

January 2017

January 2017

Easy to admin with some very good features

Ease-of-use

Functionality

Product Quality

Customer Support

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Support

Microsoft SQL Server has served me well, handling all kinds of tasks from Data warehousing, automated data pushes, reporting, notifications and ad-hoc analysis. Since we started using SQL Server several years ago, it has allowed us to better serve our customers with consistent data analysis and file pushes. The product is stable and mature, and the best is the "integration". Integration with Visual Studio, with Reporting Services, Analysis Services, Integration Services

Pros

These are a few in a long list of optimizations that result in a faster-running product. Under the theme of data protection, security capabilities are improved with the introduction of data masking on tables, new encryption capabilities and row level security SQL Server 2016 has been developed on the existing code base making it stable and compatible, and allowing customers to take advantage of new features easily.

Cons

Upgrading becomes more critical if you are on an old version such as SQL Server 2005, as you will no longer be able to obtain product fixes for the version.

Source: Capterra
 

Chris from Snap-on Inc.
Number of employees: 5,001-10,000 employees Employees number: 5,001-10,000 employees

January 2017

January 2017

SQL Server Review

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

I've been using SQL Server for about 15 years. We are primarily an Oracle DB shop but we have grown our SQL Server environment significantly. I'm a part programmer, part administrator, and part user when it comes to SQL Server. I'm pleased with the tools available (SQL Server Management Studio). I would recommend this to any business!

Pros

Fairly easy to use if you have a SQL background.

Cons

I don't pay for it but I've been told the licenses are expensive.

Advice to Others

We have a dedicated DB Team and it is good to have trained professionals backing you up.

Source: Capterra
 

sumit from wipro
Number of employees: 10,000+ employees Employees number: 10,000+ employees

January 2017

January 2017

Favorite tool for DB related tasks

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

The performance is really good, complex queries with dozens of different joins execute quite fast. The SQL Management Studio is one of the best tools I've seen for running queries, it allows to concentrate on typing the query while auto-filling a lot of code for you. Executing the SQL query plan provides very good info that can be used to optimize one's queries. Built-in reports that provide a lot of metadata info for the DB.

Pros

It supports database snapshot and content databases which are very useful way of managing multiple DB requirements. Client tool is one of best add-on, almost 99% of activities can be performed using intuitive GUI console, easy for newcomers and also provide advanced capabilities for advanced DBAs.

Cons

No portability for Unix system.

Source: Capterra
 

Kleopas from VITeC

December 2016

December 2016

the king of the market

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

As the king of the market, MySQL needs no introduction. There is no way you work in IT and never heard of MySQL. I used it so many times that now is like an automatic procedure for me now.

Source: Capterra
 
 
Write a Review