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

72 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 (8)
More Reviews (64)

Showing 1-8 of 8

James from UHealth - University of Miami Health Care System
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

August 2017

August 2017

Consitent and Performance

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

I like the consistancies of the the software over time. They are able to bridge generations of coders to be able to continue.

Cons

I hope they could bridge the gap so that everyone could feel powerful programming in different languages.

 
 

Gavindra from UHealth
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

August 2017

August 2017

A very powerful tool in data analytics, data warehousing, and big data in general.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

An extremely powerful and versatile Database Engine that integrates well with multiple platforms. In addition it has tools that provide lots of flexibility for automation.

Cons

Depending on the usage, the Database can eat up resources very quickly and does not tend to release them without some manual intervention.

 
 

James from United Metropolitan Nigeria Life Insurance Ltd
Specialty: Banking & Financial Services
Number of employees: 51-200 employees Employees number: 51-200 employees

July 2017

July 2017

Effective database management software

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

A good software, one of the best around.

Pros

Continuous improvement and addition of more functions for easy of use. The application is a complete bundle for data management, development and BI.

Cons

Limited GUI tool for newbies in database development. Express edition is also very limited, needs to be improved on.

 
 

Dinesh Kumar from Lennox International Inc
Specialty: Banking & Financial Services
Number of employees: 2-10 employees Employees number: 2-10 employees

July 2017

July 2017

Microsoft SQL Server

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Performance of SQL Server's database engine is a huge plus.
Performance gets better and better with new versions of SQL Server. Keep upgrading to newer versions

Cons

Compatibility with other versions of SQL Server is tough.
Not all companies use the same version. Administrative tasks changes with every version of SQL Server

 
 

anudeep from MicroinfoIT
Specialty: Software / Technology
Number of employees: 51-200 employees Employees number: 51-200 employees

June 2017

June 2017

Its amazing software to do lot of things.

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

Easy when compared to other platforms like DB2 and Oracle.
Can organize the data in a proper manner.

Cons

One needs to have knowledge of databases.
Need to know the concepts of traditional databases.
PL/SQL knowledgs.

 
 

Caitlin from MMSG
Specialty: Banking & Financial Services
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

June 2017

June 2017

One of the easiest places to exhibit your SQL brilliance

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

The colour formatting is smart, and being able to shrink/expand coding chunks for smarter faster skim reading.

Cons

Auto-fill can sometimes be hard to reverse as it persists with the wrong value, I've found myself reverse typing the field names so it didn't do this.

 
 

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 64

Jisu from Infosys Ltd
Number of employees: 5,001-10,000 employees Employees number: 5,001-10,000 employees

August 2017

August 2017

The simplest friendliest RDBMS 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
Pros

I have worked with several Database products, and Microsoft SQL Server is the easiest. We use it for our light-weight applications, because it is easy to manage and easy to train our new employees. It comes with a GUI interface, and the databases are pretty much "plug and play"

Cons

We haven't tested it extensively to its limits, but we feel a performance issue when the database size grows close to 1 TB. We dont have some of the features of other RDBMS like flashback, Automatic Database Diagnostic Manager, historical snapshots etc

Source: Capterra
 

Freddy from Rofrer S.A. ( Budget Car Rental Venezuela)
Number of employees: 51-200 employees Employees number: 51-200 employees

August 2017

August 2017

For handling large amounts of data, it is best. Allows the analysis of the same.

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

Saving time and financial resources to the company, keeping information centralized in a powerful system.

Pros

Is designed for the management of many information at the same time, its speed in processing.It can be used for the design of related databases, in small and large companies, making more efficient the management of the information, its traceability and its audit.

Cons

The administration of many commands. The system needs to handle a large amount of physical memory to be able to process the information, making the equipment where it resides, be a machine rubusta and updated.

Source: Capterra
 

Tasleem from Q Soft
Number of employees: 2-10 employees Employees number: 2-10 employees

August 2017

August 2017

Performance is very poor and unexpected

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

its easy to learn

Pros

Easy to manage for new users
good management interface that help new users to learn fast
managing databases and automation tasks are easy

Cons

MS SQL Server is very poor in performance as compared to other products
in MS SQL Server complex queries take too long
gain in performace only when profiler is on

Source: Capterra
 

Phillip from NetPotential
Number of employees: 2-10 employees Employees number: 2-10 employees

August 2017

August 2017

Easy to use management software for Microsoft-based SQL commands. Free for new start-ups.

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

Easy to use SQL commands and reporting.

Pros

I love how there are now fast-release cycles compared to back in the day where release cycles were slower.

Cons

I wish the UI was upgraded every second release like they used to do, they have lost the ball on this for the last one or two releases.

Source: Capterra
 

Simone from Credito Valtellinese

July 2017

July 2017

SQL server - great 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

It allows you to easily create databases with huge amounts of data. With sql server we can create store procedures that help us extract data from the company data warehouse and, using reporting services, create reports with them.

Cons

When the size of the tables becomes important the performance decreases drastically and requires a lot of hardware resources

Source: Capterra
 

Carlos from Promerica

July 2017

July 2017

Easy to use

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

Whether they advertise it a lot or not, Microsoft invests heavily in SQL Server¿s core database engine in every new version. Back in the old days, a nine-table join was a recipe for disaster; now it¿s no big deal. The same holds true for SQL Server 2012: You can expect better overall performance when compared side-by-side to older versions, and ¿better performance¿ is always a reason to consider an upgrade.

Cons

Newest versions of SQL Server brings some significant changes, and change isn¿t always best. For example, your IT team will have to re-think how they engineer database availability given the completely-changed high availability features in SQL Server. Most other administrative tasks will remain significantly unchanged, but if availability is an important concern for your organization, make sure you understand what you¿re getting into with this new version.

Source: Capterra
 

Vidhi from Paycor
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

July 2017

July 2017

Solid Enterprise Database and great for database work

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

SQL helped with data replication across database with ease. Picking all of those out one by one would have take a long time, but SQL made this processes fast.

Pros

Microsoft SQL is a standard for applying the Structured Query Language to tabular databases, which makes life much easier when your database is massive. You can select the data that you want using clear syntax, and from there work more quickly.

Cons

I dislike that Microsoft SQL isn't as as streamlined as you might expect. For example, it takes many more keystrokes and clicks to import a table than it should, and table entries that are too large may not display properly.

Source: Capterra
 

Jose from CVT

July 2017

July 2017

Ive been working with sql server 2008 for almost 5 years with excellent results cause its easy to ma

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 ease of use you have to manage databases is amazing you can easily manage multiple databases with simple configuration

Cons

sometimes it has a hard time with big databases plus the larger the database the crazy it gets with hardware

Source: Capterra
 

Josh from Herzog-Meier Autogroup
Number of employees: 201-500 employees Employees number: 201-500 employees

June 2017

June 2017

SQL Server helped wonderfully for my work needs

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

Was working as a part time Jr. DBA and being able to use MS SQL was very nice! I really enjoy the large community that uses SQL Server because if I have any questions I can use Microsoft's own community forums to ask!

Source: Capterra
 

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
 

Christian from Re creation
Number of employees: 11-50 employees Employees number: 11-50 employees

May 2017

May 2017

Is the good for small busne

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

Search easy, data consulting is good

Pros

Essay to set up, search motor good, easy upgrade, multilengual system and easy to buy, install queacly

Cons

If the data is damage not recovery easy, for bigger data is to easy to damage and los data, if you no have license the suppr no work

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
 
 
Write a Review