Microsoft SQL Server BI Software


474 reviews(4.5/5)
474 reviews(4.5/5)

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.

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

474 Reviews of Microsoft SQL Server - BI Edition

Showing 1 - 20 of 474

Start your review of Microsoft SQL Server - BI Edition

Click to start
  • Lei from University of Utah

    Number of employees: 201-500 employees

    September 2018

    SQL database

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    1 Support multi languages;
    2 Can be used for several types data.

    Cons

    1 Not easy to start for normal user;
    2 A little complicate for de-bug.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • KUMAR from Conduent

    Number of employees: 10,000+ employees

    September 2018

    Easy to use

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    User interface is easy to understand and much functionality.

    Cons

    Sometimes not responding and getting crashed.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Thomas from Hellenic Gaming Commission

    Number of employees: 1 employee

    September 2018

    Database

    Ease-of-use
    Functionality
    Quality
    Support
    N/A
    Pros

    The UI of the management studio can help the user to do easily every database task.

    Cons

    The management studio wasnt possible to be downloaded seperetly.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Sahil from trigma solutions pvt ltd

    Number of employees: 11-50 employees

    September 2018

    Sql Server

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    Easy to use data storage server built by Microsoft. Rich in its amazing feature to handle the big data.

    Cons

    High cost, only affordable by big organisation.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Patrick from OS-Cubed, Inc.

    Number of employees: 11-50 employees

    September 2018

    SQL Server: Mature and powerful relational database, great for Microsoft products

    Ease-of-use
    Functionality
    Quality
    Support
    N/A
    Value for Money

    I love it. The tools are really powerful and have helped me become a better developer.

    Pros

    I love the tools that come with SQL Server. SQL Server Management Studio is a powerful tool and learn something new every week. Check out the Client Statistics feature to gather stats on multiple runs of a query. Also, the Actual Execution Plan feature suggests which indexes to add that can greatly improve performance.

    Cons

    The cost. SQL Server can be very expensive and has always had complex licensing options: per seat, per processor, etc. We are a Microsoft shop and Partner, so we it makes sense for us to use the Microsoft database platform.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • John-ryan from Advent

    Number of employees: 10,000+ employees

    September 2018

    SQL for all our needs

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    Our entire product suite is built on SQL, everything thing I do each and everyday revolves around public views, tables, stored procedures and queries I’ve built to ensure our clients success

    Cons

    Great product, I do wish it was slightly easier to navigate for some of my clients but overall it’s exceptional

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Ramesh from ANALEC

    Number of employees: 51-200 employees

    September 2018

    Easy to use

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    Great intellisense
    Easy to use
    Good user interface

    Cons

    Sometimes it hangs

    Less functioality than cahe db

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Verified Reviewer

    Number of employees: 2-10 employees

    September 2018

    Powerful Software, Tricky to Learn

    Ease-of-use
    Functionality
    Quality
    Support
    N/A
    Pros

    Very easy to manipulate data, and lots of it.

    Cons

    Pretty steep learning curve, tricky to learn at first.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Verified Reviewer

    Number of employees: 501-1,000 employees

    September 2018

    Sql server review by user

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    Easy to use also provide intellisens.
    Available lot of predefined function which are very helpful.
    Have execution plan and sql profiler which are very helpful for user.

    Cons

    Its paid and also cost is very high.
    Lack in features as compared to similar software like Oracle

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Daniel from WorldView

    Number of employees: 51-200 employees

    September 2018

    SQL Server - Microsoft's Best Product

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    I have been using SQL Server for 20 years (starting with version 6.5). I have seen it mature into an outstanding database platform. If you work in the Microsoft space and need a databases there is none better. I know MySQL is great but I would stick with SQL Server.

    Pros

    Feature set is rich and robust. The management tools are great. It runs very well and is reliable.

    Cons

    Really there is nothing I do not like about SQL Server. Yeah, it is expensive but it is a RDMS. Those aren't going to be cheap.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Priyansh from The Alpha Developers

    Number of employees: 11-50 employees

    September 2018

    Enterprise Database Solution By Microsoft

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    SQL Server is the best database tool if you are developing a Windows or Microsoft Windows application. It's support with these technology is just awesome. Very efficient and Powerful tool, can handle even very large application effectively.

    Cons

    Being a Microsoft Tool, You will need to get a licence from Microsoft before using it in your application whose pricing is moderately high.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Verified Reviewer

    Number of employees: 501-1,000 employees

    September 2018

    Most frequent to use

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    It is good but issue occurs only when handling large amount of data otherwise it is very efficient software

    Pros

    This software is user efficient, fast and compatible

    Cons

    Difficult to handle large amount of data

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Karan from Panamax Infotech ltd

    Number of employees: 201-500 employees

    September 2018

    SQL server is the best database with lots of features

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    There easy GUI in SQL server management so you can easily create database.it can handle large data easily so if you are working on application which deal with big data then SQL server can manage it. There is also auto performance tuning available so it will guide user to improve performance in their database.As per my view SQL server is perfect database when we work with big data.

    Cons

    The cost of the SQL server is big cons because there are cheaper database available then it. It's best there is no doubts but it's very costly.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Verified Reviewer

    Number of employees: 10,000+ employees

    September 2018

    Great for Data Related Work

    Ease-of-use
    Functionality
    Quality
    Support
    N/A
    Pros

    Personally I never had to dig down to deep with SQL Server as data analysis was never my main job, but for for my use of running queries to retrieve data from databases it's been great and very easy to work with.
    Feature-wise everything is available as far I am concerned. A free trial is offered as well.

    Cons

    Only con I can think of is the slightly steep learning curve. Once you spend some time with SQL Server you do learn the ins and outs for running queries, but it was a bit confusing at first.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Sukhpreet from OATI

    Number of employees: 501-1,000 employees

    September 2018

    Sql Server- DBMS tool

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    I am using this product to fetch data from databases for the official use of my corporate work.

    Pros

    I am using it around 2 years in a line and I have to say its a great product from Microsoft. One can connect multiple instances of Users, can connect with client side server to fetch data.
    Inbuilt profiler helps a lot to fetch particular query. Intellisense helps to save time.

    Cons

    Its a huge size software. Sometimes it lags.
    Restoring and backing up of Database takes ample amount of time.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Verified Reviewer

    Number of employees: 2-10 employees

    September 2018

    Solid Data Consolidation Platform

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    If you are an IT resource, the experience is great.

    Pros

    SQL Server continues to get better all the time. I use it for helping SMBs consolidate their data for BI/analytics for both on-premise and Azure. The product is solid and never have a problem (especially Azure). If you have used any of the previous versions. Due to its long history and wide use, resources are always available to support the product. The security continues to get better and integrates well into Power BI. Over the last couple of years, Microsoft has also added additional connector services which is great for many IT shops.

    Cons

    If Microsoft wants to stay relevant in the SMB world they need to make it more automated, intuitive and dummy proof for individuals in Marketing and other disciplines. The product requires some serious IT support which is not always available. I have never been happy with their Training and certification programs (basically they suck). Microsoft dictates how classes are to be run and lost connection with the evolving world.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Caroline from LASSO GROUP

    Number of employees: 201-500 employees

    September 2018

    One of the best Relational Database Solution Ever

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money
    Pros

    The version of Microsoft Server I have worked with is version 2017 -Microsoft Server 2017. Depending on what you are using Microsoft server for, it is easy to install and setup. The installation process is pretty much a press 'Next' kind of experience.

    Microsoft server offers powerful options for data recovery, replication change tracking, big data support and predictive analysis which are very relevant for big corporations.

    Another awesome thing about Microsoft SQL server is that there is a lot of documentation on the same. Incase you are stuck with something on the app, it is easy to find forums where others have experienced the same problem and probably found a solution to it.

    Cons

    The downside of Microsoft SQL server according to me is the price. It is not economically friendly to small small companies.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Pranay from Accute Informatics

    Number of employees: 501-1,000 employees

    September 2018

    Best RDBMS I have used

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    This us a great RDBMS by Microsoft. I have been working on database for past two years. This tool makes my work much easier by supporting complex SQL queries.

    Pros

    The best thing about this software is its ease of use. It has a great environment with great features and tools.

    Cons

    It can be improved by allowing more SQL functions to be used.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Shambhavi from Tata Consultancy Services

    Number of employees: 501-1,000 employees

    September 2018

    great RDBMS by Microsoft

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    I have been using this software 3 years. First of all, its environment is great. It is quite easy to use. It comes with great features and functionalities. A variety of SQL functions can be used in it.

    Pros

    The best thing about this software is that it supports variety of SQL functions which are quite easy to implement and understand.

    Cons

    It would be great if its database connection process can be made easy .

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Gabriel from UFSCar

    Number of employees: 51-200 employees

    September 2018

    Powerful and reliable database to work with

    Ease-of-use
    Functionality
    Quality
    Support
    N/A

    The entire database of the facility works with SQL server and is working perfectly.

    Pros

    Can store large amounts of data with important operations like backup and restore. Have different tools for visualizing , code security, search and the SQL Tuning Advisor for indexes and optimize your queries. You can run different instance of others version at the same time and also have an back end for many programming languague.

    Cons

    It´s a heavy software that demands a lot of memory and space, sometimes it gets very slow.

    This review was submitted organically. No incentive was offered
    Review Source: Capterra
Do you use Microsoft SQL Server - BI Edition?Write a Review
In just fifteen minutes, the experts at Software Advice can help you narrow down the right software for your organization. Call us for a Free FastStart Consultation: (844) 680-2046