About Microsoft SQL Server - BI Edition

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....


Read More

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

1,410 Reviews of Microsoft SQL Server - BI Edition

Average User Ratings

Overall

4.59 / 5 stars

Ease-of-use

4.5

Value for money

4.0

Customer support

4.5

Functionality

4.5

Ratings Snapshot

5 stars

(877)

877

4 stars

(494)

494

3 stars

(35)

35

2 stars

(3)

3

1 stars

(1)

1

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 1410 results

March 2020

Filipe from Self-employed

Verified Reviewer

Company Size: 1 employee

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

March 2020

SQL Server review

SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it Can use it locally on on cloud

Pros

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

Cons

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine

Reasons for Choosing Microsoft SQL Server - BI Edition

SQL server is lot less expensive and have a free option for small aplications or for small customers

October 2020

Brenten from PCC Airfoils

Company Size: 10,000+ employees

Industry: Airlines/Aviation

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Functionality

5.0

October 2020

Powerful and Scalable Database Software

Storing large quantities of production data to solve quality and efficiency problems has been a big use for SQL. All of the reporting and power to analyze data has solved countless puzzles for me in my job capacity. I also have done a lot of database administration for our ERP software and the tiles to tune and optimize have always been very helpful.

Pros

One of my favorite things about Microsoft SQL Server is the scalability. Whether you are using the free version for a small program running on a local machine or running an entire factory it is the same basic concept of programming and administration. I really appreciated being able to work to have a database software that could grow and expand when I need it too. Additionally the reporting and automation packages that come with it are super powerful. I would absolutely recommend using Microsoft SQL Server as anyone’s data as software

Cons

The biggest con in my opinion is that some of the more advanced features for big data analysis and high availability are in the top tier pricing which can be hard for smaller companies to afford. Other than that I have never not been able to solve a problem with Microsoft SQL.

Reasons for Choosing Microsoft SQL Server - BI Edition

Microsoft SQL had superior options and capabilities.

September 2019

Vikash Kumar from HPE

Verified Reviewer

Company Size: 10,000+ employees

Industry: Industrial Automation

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

3.0

Functionality

4.0

September 2019

Easy and Fast for Development

Pros

MS SQL makes your life easy by bringing SQL Management tool easy to create new database on the fly. Free express Database for development purpose Easy to troubleshoot performance issue,. Same SQL can be published to azure or get the same feeling on Azure. Most used database

Cons

When DB size grow large then it leads to performance issue. these days in world on No SQL database, ppl tend more use other kind of DBS

August 2020

Prabhu from cognizant

Verified Reviewer

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Functionality

4.0

August 2020

All time market leader

When comes to business critical it can consume the raw data, process it and provide to the user understandable format. More than decades, this software providing tremendous help to business to evolve and reach their goals by fetching data from any formate and load it into structured form and with help of powerful Tsql query languge we able to fetch the right data from database. We can also connect with any visualization tool to provide the better UI(Power BI) to users to take right decision.

Pros

1. Optimized storage and querying business critical data. 2. Powerful Tsql Query language. 3. Query execution plan to predict and optimize the data. 4. Query profiler to find out anomaly and query latency.

Cons

1. We need to take care of all patching works. 2. We need to take care of all infrastructure scalability(RAM,HDD and IO etc) 3. Server maintenance and outrage time is high.

March 2020

Kudakwashe from Madrush Technologies

Verified Reviewer

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

March 2020

Data Management made so easy with MS SQL Server

Pros

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

Cons

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

Reasons for Choosing Microsoft SQL Server - BI Edition

In the case of Oracle DB vs MS SQL Server, MS SQL Server is easy to manage, easy to configure and has a huge community in case when you are stuck with any problem you are guaranteed to get a solution online.