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

79 Reviews of Microsoft SQL Server - BI Edition

 

Start your review of Microsoft SQL Server - BI Edition

Click to start
https://www.softwareadvice.com/bi/microsoft-sql-review/
Software Advice Reviews (8)
More Reviews (71)

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 71

Victor from NiftyLAS

September 2017

September 2017

A very robust SQL solution. Offers great flexibility with little fuss.

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 is perfect for SMEs. The support is great and the fact that is backed by Microsoft is a very big plus. Also, one of the biggest plus is the multi-CPU query support which is great for CPU intensive work.

Cons

The documentation is very unwieldy and hard to get. The procedural language is a lot of other open-source competitors such as PostgreSQL due it's speed and features that it offers.

Source: Capterra
 

kusum from Brooks Rehab

September 2017

September 2017

New versions have become very robust

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

Ease of use. This is a very robust database server and good for business. I have been using Sql Server for a very long period of time and with every new version there are many new features and ease of use. This product is good for personal, small size, mid size and large organizations. Also very easy to understand as there are many resources available online and so one can get help easily. There are many courses available and has a great job market. I would recommend companies to use this product and organize their data. It also has great BI and reporting which has now become a very important part for any organization.

Source: Capterra
 

Pedro from OCHIN

September 2017

September 2017

Have worked with several DBMSs over the last 17 years but I specialize on MS-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
Pros

Relatively easy to use, both from DBA and developer perspectives, great functionality has been added over the years and improved performance to handle large databases and tables.
I also really like and use the other tools that are part of MS-SQL: SSIS, SSRS, SSAS, etc.

Cons

Upgrades can be difficult from a technical perspective, learning some of the new features especially from a DBA perspective is often a steep learning curve in order to become proficient.

Source: Capterra
 

Rob from CS3

September 2017

September 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

What I like most about this software is that it is fully functional with so many different types of software!

Cons

What I like least about this software is that it can really get confusing for the novices. After some training though its certainly usable.

Source: Capterra
 

Ann from Inverse-Square

September 2017

September 2017

Reliable, solid database platform

Ease-of-use

Functionality

Product Quality

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

I use this software for all of my database needs. It is reliable and easy to use. I can't imagine my work without it.

Cons

The different versions sometimes don't play well together. Also depending on your machine DPI, older versions may not display correctly on your screen.

Source: Capterra
 

carol from GuideOne Insurance

September 2017

September 2017

overall 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

fairly English-like--able to follow the flow, more or less, even if you are not familiar with the language.

Cons

debugging messages are vague making finding your actual error difficult at times. would like a way to display the information coming better.

Source: Capterra
 

Michael from ECL

September 2017

September 2017

Sql server works well and is an industry leader

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

Works well with other Microsoft software and provide the support neccessary to manage your database software

Cons

Sql is a bit costly but still provides all the neccessary functions from effective database management

Source: Capterra
 

Linda from Hydrex Pest Control of Sacramento

September 2017

September 2017

It works great for our small network

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

We have used this software for many years & never had a problem.
It is used to link our Termite & Pest Control software on on our network of computers.

Cons

Sometimes, when we have all 4 computers using the software, it tends to slow or bog down.
I am assuming the SQL is the issue.

Source: Capterra
 

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