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,290 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.0

Functionality

4.5

Ratings Snapshot

5 stars

(816)

816

4 stars

(461)

461

3 stars

(35)

35

2 stars

(3)

3

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 1290 results

May 2019

Surender from tecHangouts

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

3.0

Functionality

5.0

May 2019

Best DBMS tool for scalable enterprises

My overall experience is 100% satisfactory because of its robust feature. I recommend this to all either its a large or small scale compan y because SQL server can handle large quantities of data and process it smoothly. Just loving it.

Pros

Microsoft SQL server is one of the best database management system that provide top rated performance optimisation with SQL queries, below is the list of top highlights: 1. Richness of user interface that provides ease of use with cool features like dock able windows. 2. Intelligence window is prominent feature that saves a lot of development time up to large extent. 3. Code debugging and performance tuning with query flow maps is the best features that assures about code optimisation. 4. Microsoft SQL Server Agent is provided with this software and that runs the automatic jobs in very secure way and later we can track the statements executed. 5. We can filter out the records in SQL Server Agent interface based on our interest. 6. Code snippet manager makes it easy to write high standard code that is perfact for code convention. 7. Most prominent feature is that it can handle large quantities of data, runs automatic jobs with concurrent transactions. 8. At last it's a Microsoft product that provides a belief to users.

Cons

I have been using SQL server from version 2012 to 2014 and never troubled with SQL server's performance in any way. However I feel that error details must long descriptive when statement have some syntax error. Sometime its pathetic when we wants to know the exact error line but is hints the whole block of code instead of exact line number. Otherwise Its a great product and happy with it.

July 2018

Anbal from Banco Bicentenario, Banco Universal C.A.

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Value for money

3.0

Customer support

5.0

Functionality

5.0

July 2018

My experience with sql Server has been satisfactory, I have done punctual work.

I have worked several times with this software for different reasons I have been able to simplify developments thanks to the Transact-SQL so it has saved me programming time, the services that I have under my responsibility at work are stable, this gives confidence and tranquility for me and for my bosses, I made restorations in record time.

Pros

This software has as its first advantage that it is a Microsoft product and has the full support of the company and the stability of a well-tested product. At the basic level, I find it very efficient, the sql responses are fast and there are almost no service interruptions, which is a point in its favor when I use it, I find the Transact-SQL language that is used very powerful, I was able to assign commercial processes of the application in the database that allows multiple applications to use them and it is not necessary to program these functions in each application, the SQL server administration tools are very well thought to be all in a Microsoft environment, the integration is perfect, they are very intuitive to find new functions, they do not require prior knowledge, what is important to train new staff, another thing that I like about this software is the scalability that can start with a small database and grow, in A past project had transactional tables that inserted millions of records daily. I like security, it is possible to assign specific permissions to different users who perform different activities within the same database, this makes me trust the product.

Cons

The least I like is undoubtedly the cost SQL-Server does not have a good cost-benefit ratio, other brands offer better benefits in this regard, another point is the high consumption of RAM, it is necessary to allocate a large amount of resources for this And to guarantee the quality of the service, until now I have not found a hosting provider that offers me a PHP server with Sql-server. This stopped once a new development for a client was disappointing to me. It is difficult to learn in a particular way, the free versions of this software are very limited and the certifications are expensive, which reduces the interest when it is investigated.

January 2020

Lasha from Mmedi22

Company Size: 501-1,000 employees

Industry: Hospital & Health Care

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 2020

One of the best DB management systems.

I've been using SQL Server for a few years and I haven't had any problems with it except for partitioning. It's very optimized and stable and due to it being free - it's an amazing choice for small and medium enterprises.

Pros

MSSQL comes jam-packed with features. It's standard library is enough to cover the needs of a small enterprise. It is also very stable and can handle large amounts of database exceedingly well. However, my favorite tool is the built-in scripting language - T-SQL. It is very powerful and flexible and lets you do anything you might need.

Cons

SQL Server takes up a lot of computing resource. We have a small data warehouse and yet it takes up over 1 TB. Views are not as useful as in Oracle. For example, partitioning a fact table by multiple columns is impossible without a workaround.

Reasons for Choosing Microsoft SQL Server - BI Edition

SQL Server is free and offers all the features we needed. Oracle is overkill for a hospital.

November 2019

Imi from IT

Company Size: 201-500 employees

Industry: Political Organization

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Customer support

1.0

Functionality

5.0

November 2019

SQL is getting better as it grows older

SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It is super fast for loading data from the server, and allow large data set that will normally take hours, or even crash the Excel spreadsheet to load without any issue. When I am ready for a web app.. SQL server is easy as piece to develop a simple CRUD application and push live. It seem to connect to every thing - from MS Word Mail merge, MS Excel, MS Access and of course for development environment such as Visual Studios. One Database ( Centralized) and many presentation modes for the end users. I love it!

Pros

MS SQL Server is certainly a competently relational database engine, with reporting service and now R. Easy to install for small onpremise application. Easy to administer, easy to backup, easy because it is a Microsoft application. It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI. You can start from free version and expand as time goes by. The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting. If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.

Cons

The new the version, the more memory intensive this management studio will become. Microsoft need to create some more easy to use tool for change control and change tracking. Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.

Reasons for Choosing Microsoft SQL Server - BI Edition

Cost and community of supporters, access to information on the open internet . Available of training.

September 2019

Vikash Kumar from HPE

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