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,429 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

(893)

893

4 stars

(497)

497

3 stars

(35)

35

2 stars

(3)

3

1 stars

(1)

1

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 1429 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

Reasons for Switching to Microsoft SQL Server - BI Edition

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

December 2020

Yuvraaj from Sunrise Enterprises

Company Size: 2-10 employees

Industry: Electrical/Electronic Manufacturing

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

4.0

Functionality

5.0

December 2020

There's a reason why most people choose SQL Server over other database softwares

I have never had any problems with SQL Server. It was always efficient and capable of doing whatever needed to be done.

Pros

Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers. The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient. With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.

Cons

Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality. Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.

Reasons for Choosing Microsoft SQL Server - BI Edition

Our company uses a Microsoft Infrastructure so it would have been really easy to integrate it into operation.

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

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.

January 2021

Anthony from Intertek-PSI

Company Size: 10,000+ employees

Industry: Civil Engineering

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

January 2021

SQL Server | Inexpensive and Impressive

Our organization uses SQL Server Enterprise as the backend for our Laboratory Information Management System. While we had the option to use Oracle, we went the Microsoft route due to licensing costs and in-house expertise. We have had nothing but positive experiences with SQL Server. From day-to-day operations to high-availability to SQL Agent jobs, we use a large portion of the functionality included with SQL Server. In addition to our laboratory system, we link SQL Server to our financial system (running on an Oracle database), which allowed us to create a data mart that we use to mine and report financial data through SQL Server Reporting Services.

Pros

* SQL Server Management Studio is intuitive and fairly straightforward to use * Implementing more advanced features such as SSRS does not require much effort * Simple process to link other database servers (i.e. Oracle) * Robust high-availability solutions available

Cons

* Licensing structure for Enterprise version is per core(s) * Always On Availability Group high-availability solution, while it works well, could have been simpler to set up * Performance/query tuning recommendations are not easy to locate

Reasons for Choosing Microsoft SQL Server - BI Edition

We chose SQL Server over the main competitor due to both cost and in-house expertise. SQL Server was much less expensive than its Oracle counterpart and does an excellent job. As a Microsoft shop, we also have a greater deal of experience and familiarity with Microsoft products.